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!
Hi,
I have a wpdatatable created by data from a Forminator form. I want to know if it is possible to apply formulas to existing data i.e:
1) A user fills out a form telling me their weight and height
2) A wpdatatable is created
3) An additional column is created which apply the formula weight x height to find their BMI
Is it possible to apply formulas to raw data in this way? I currently export data to an excel spreadsheet where I can apply formulas and filter it back to the website however, it would be great if there is a way to add these formulas within the one table.
Hi, Benjamin
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.
- Yes, this can be done. I just made an example from your description; a real simple Forminator Form, that takes two input fields, for weight and height;
then made a table linked to the form; I made a couple of rows, and added a calculation column, called it BMI;
I failed to create an accurate formula for BMI, to be honest; because I struggled to convert different measuring values; watched something on Youtube, out of curiosity, but didn't get an accurate result, as you can see on my table ( first tried height as cm, then meters, but didn't really succeed)
- Nevertheless, what you described can be made, it just needs a person who knows how to properly calculate BMI with proper measuring units.
; here is the page with the form and table together:
- and the back-end of wpDT :
Here is a detailed documentation section about Formula calculated columns.
- Just to note that, as you probably know, for the integration to work, you need to have all three installed and activated on WordPress: wpDataTables, the Forminator plugin, and the wpDataTables integration for Forminator Forms.
Contact us further if you need more guidance.
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