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 #2979670
Can you apply
Closed

Comments

  • Benjamin started the conversation

    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.

  •  1,894
    Miloš replied

    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)smile.png

    - Nevertheless, what you described can be made, it just needs a person who knows how to properly calculate BMI with proper measuring units.smile.png

    4331632292.png

    ; here is the page with the form and table together:

    8647336286.png

    - and the back-end of wpDT :

    7418470801.png


    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 | 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