JotForm Tables: Displaying the total value of Product list without clicking the field

  • SachsAssociates
    Asked on October 29, 2020 at 12:09 PM

    Hi,

    I just started testing your new "Product List" integration but noticed that although total price is displayed in the form, once I receive submission and look at it under submission table - total price is not displayed, only individual items and i need to click on them to see individual price and then total... Any ideas how I could just get total price as individual table column and avoid need to click?

    Thanks in advance,

    BR,

    Tomas

    Jotform Thread 2666044 Screenshot
  • Laura JotForm Support
    Replied on October 29, 2020 at 2:53 PM

    Hi Tomas,

    Thank you for contacting us.

    Currently, that is the way how the Product List appears on the Tables.

    I will send a feature request for our developers to show the total amount of the Product List without the need to click on it in the tables. However, we cannot confirm when the feature would be implemented. If there are any updates, we will let you know here on this ticket.

    For now, you can add a hidden calculation field into your form that has the total of the products. This way you will have an additional field in the tables that will display the total amount of the product list.

    1603997072 5f9b0d90e45bc product total Screenshot 10

    I cloned one of your forms and created a demo for how this would work. Please see the link below; you can clone the form to try and test it, and use it as a base for you.
    https://form.jotform.com/203026056490953

    Here you can find how to clone a form:
    https://www.jotform.com/help/27-how-to-clone-an-existing-form-from-your-account

    To add a calculation and hide fields, please see the guides below:
    https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget

    https://www.jotform.com/help/434-how-to-hide-form-fields

    Hopefully this helps. Please let us know if you have any further questions, and we are happy to help!

    Best Regards,



  • Laura JotForm Support
    Replied on October 29, 2020 at 3:00 PM

    Hi Tomas,

    I just wanted to let you know that I have sent the feature request to our back end team.
    We will keep you updated when we have any news.

    Best Regards,