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.
There are several other limitations to be aware of when using formula columns in wpDataTables:
One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
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.
Adding a sum in the sum row for formula columns is not yet supported.
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.
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.
There are several other limitations to be aware of when using formula columns in wpDataTables:
- Let me know if that makes sense and if you have any questions. Thank you
Kind Regards,
Miloš Jovanović
milos.jovanovic@tmsproducts.io
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