Q: Do you have a calculation function?
Could uses enter data in fields and a chart change based on their inputs? For example, a mortgage calculator? Or loan payoff?
If so, can you show me examples?
Aleksandar_TMS
May 14, 2024A: Hi there.
Sure, we have calculation functions which include calculating the SUM and AVG values for the column, and also show MIN and MAX values for that column. Another option would be to add a formula (calculated) column in which you can include other integer or float columns to be used for calculations. You're able to define a formula in that column, and the results will depend on values from other columns used in the formula.
All charts are connected to the tables they were created from, and if you enable "Follow table filtering", and place both the table and the chart on the same page, filtering applied to the table will also be applied to the chart. Please take a look at our documentation about these features:
https://wpdatatables.com/documentation/column-features/formula-calculated-columns/
https://wpdatatables.com/documentation/table-features/calculation-functions/
https://wpdatatables.com/documentation/wpdatacharts/creating-charts-wordpress-wpdatachart-wizard/
NashTaxPLUSAleksander -
I am asking more about calculating based on User Inputs...
For example, https://www.mortgagecalculator.org/
Can we create calculators that change based on USER inputs???
Hi again NashTax.
Well, every calculation is based on user input - the values they enter would be used in the formula column to calculate the formula you previously defined when you created the column. That goes for editable columns (manual, imported, SQL Query based and Gravity Forms based tables).
From the example site, I see you'd like to see something like a form, where users would enter data, and based on that data, they would see the results. Since wpDataTables doesn't have any Form view, your users would be able to enter the data in a standard "Add new"/"Edit" modal, and see the results in a table.
To use the form - view, you could use something like Gravity Forms or Formidable Forms, and acquire one of our add-ons for these plugins, to be able to create tables from forms. However, all entries will be saved in the table, and displayed to the user.
Unfortunately, wpDataTables doesn't natively offer something like a mortgage calculator, so I don't believe it would be useful for your case.
Kind regards.