Hello, i wanted to ask if its possible after creating a table, to create a calculated field between 2 or three columns of the table, and for the user in the front end to input a new value in a column and the calculated field to be updated instantly. for example : 10 "units", "bought price" 5 USD. "Current value" 6 USD. Calculated field: "pnl": 10 X (6-5)=11 USD. If user can update the Current value "pnl" field, in front end, in order for the "pnl" field to show the updated correct value.
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.
-
First, the most important point to note, our Formulas are not the same as Excel Formulas.
I will show you some general use-case scenarios and examples that can be made, I recommend first going through these, then you will get a good idea of what is possible with our Plugin's Calculations and Formulas.
Regarding calculation functions, here is our Documentation section with examples, how you can use this.
In short, in our Formulas, you will be able to use basic math operations and brackets.
You can use columns (values for each cell will be inserted), or number values and you can add some 'fixed values' as part of the Formula, if needed.
Only numeric columns are allowed (non-numeric will be parsed as 0).
Basic math operations and brackets are supported. Example: col1*((col2+2)-col3*sin(col4-3)).
Please note the limitations we pointed out about our Formulas on the Documentation Page.
One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
In tables with server-side processing formulas, columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.
Here is another example of how you can present percentages, currency and other columns by using our “Cell content prefix” and a “Cell content suffix” options.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out. Our Support will be available if you have any questions or struggle with any step along the way, and if it doesn't fit your needs, you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Hello, i wanted to ask if its possible after creating a table, to create a calculated field between 2 or three columns of the table, and for the user in the front end to input a new value in a column and the calculated field to be updated instantly. for example : 10 "units", "bought price" 5 USD. "Current value" 6 USD. Calculated field: "pnl": 10 X (6-5)=11 USD. If user can update the Current value "pnl" field, in front end, in order for the "pnl" field to show the updated correct value.
Hello,
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.
-
First, the most important point to note, our Formulas are not the same as Excel Formulas.
I will show you some general use-case scenarios and examples that can be made, I recommend first going through these, then you will get a good idea of what is possible with our Plugin's Calculations and Formulas.
Regarding calculation functions, here is our Documentation section with examples, how you can use this.
You can also create a formula/calculated column.
In short, in our Formulas, you will be able to use basic math operations and brackets.
You can use columns (values for each cell will be inserted), or number values and you can add some 'fixed values' as part of the Formula, if needed.
Only numeric columns are allowed (non-numeric will be parsed as 0).
Basic math operations and brackets are supported. Example: col1*((col2+2)-col3*sin(col4-3)).
Please note the limitations we pointed out about our Formulas on the Documentation Page.
Here is another example of how you can present percentages, currency and other columns by using our “Cell content prefix” and a “Cell content suffix” options.
And i just wanted to point out that you can try wpDataTables before purchasing
on our sandbox Demo sites ( you can find links for the main plugin Demo,
as well as add-on Demos, in my signature),
and there is a 15-day money-back guarantee period,
so if you purchase the plugin, you can safely fully test it out. Our Support will be available if you have any questions or struggle with any step along the way, and if it doesn't fit your needs, you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Let me know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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