As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3180663
How to find column ID number
Closed

Comments

  • Carlos started the conversation
    December 3, 2022 at 5:09am

    Each column that is create has a unique column id, which I would like to know how to find.

    For example: [wpdatatable_sum table_id=1 col_id=4 value_only=0]

    However, calculated columns do not have such shortcode but they still have a column id # to identify it. 

    I would like to know how to find it. Thank you.

  •  1,896
    Miloš replied
    December 5, 2022 at 7:05pm

    Hi, Carlos

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    Formula columns are not being saved in the database, thus they don't have a unique column ID available for shortcodes.

    For example, here is one of my Manual tables, i count 16 columns, with the Formula column,

    but in the database, it only saves 15 columns - the Formula column does not get created in the database.

    4511717830.png
    3379563750.png



    There are several other limitations to be aware of when using formula columns in wpDataTables:

    1. One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
    2. In tables with server-side processing formula, columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.
    3. Adding a sum in the sum row for formula columns is not yet supported.
    4. Using calculation functions in formula columns is not possible


    - Let me know if that makes sense and if you have any questions. Thank you


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables