I'am interested in the wpdatatables plugin, I checked the tutorials but could not find the answer. I would like to use wpdatatables for price calculations. Above the table you have your the filters, plus 1 or 2 input fields to be used in calculations in columns to calculate a total price based on user input. For example the user enters a value for number of copies: 200. And filters the table for size, like 'poster size 70x100'. In the list there is a price range for 100 to 500 copies and a price per piece, for example 0.15. I would like to show in the table a column with total price, in this example: 200 x 0.15 = 30.
Unfortunately, the plugin doesn't have options like this. You can add filters, but the data that's supposed to be entered is going to be saved in the table, so this approach would not work.
The only workaround is to populate the table with all possible options, and include a formula column which would show the filtered data. So, the table would only show contents by which it is filtered.
Hello,
I'am interested in the wpdatatables plugin, I checked the tutorials but could not find the answer. I would like to use wpdatatables for price calculations. Above the table you have your the filters, plus 1 or 2 input fields to be used in calculations in columns to calculate a total price based on user input. For example the user enters a value for number of copies: 200. And filters the table for size, like 'poster size 70x100'. In the list there is a price range for 100 to 500 copies and a price per piece, for example 0.15. I would like to show in the table a column with total price, in this example: 200 x 0.15 = 30.
Is this possible with wpdatatables?
Thanks,
Jan Willem de Lange
Hello Jan Willem
Thank you for your interest in wpDataTables.
Unfortunately, the plugin doesn't have options like this. You can add filters, but the data that's supposed to be entered is going to be saved in the table, so this approach would not work.
The only workaround is to populate the table with all possible options, and include a formula column which would show the filtered data. So, the table would only show contents by which it is filtered.
Kind Regards,
Aleksandar Vuković
[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