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!
Good day,
Kindly assist with setting maximum value for WPdatatable calculation column. Is it possible to do this ? for example, if column C multiples column A and column B, can I set the limit/ max of the value for column C to 100 ? i.e. if users entered 5 in column A and 30 in column B, I would like the calculation column C to give error since the product of A and B is greater than 100.
Regards
Hi, Thabang.
It is not possible to add a "has to be less than 100" as part of a Formula Column,
because in the Formulas of our Plugin, you can only use Basic math operations.
I just made a Test, for example, if i try something like this :
Then the Formula will 'sanitize' the "less than" symbol, since it is not a basic math operation.
But there is a workaround to achieve this in a table.
For example, you can add a Conditional Rule to this Formula Column,
something like : if the value in any cell gets higher than 100, then transform the content of the cell to ( any text you like) :
"Error. This value must not be higher than 100".
Here is an example screenshot how i made this Rule on my Formula Column :
You can see more about our Conditional Formatting, and all the available options you can use there.
https://wpdatatables.com/documentation/table-features/conditional-formatting/
Let me know if that helps.
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