We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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

Comments

  • Carlos started the conversation

    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,894
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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