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