Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2638155
form input fields and column calculations
Closed

Comments

  • Jan Willem de Lange started the conversation
    December 21, 2020 at 11:32am

    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

  •  2,572
    Aleksandar replied
    December 22, 2020 at 12:59pm

    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