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

  • Profile Image
    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

    Screenshot
  • Profile Image
    Laura_L
    Answered on October 29, 2020 at 02: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.p

    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,



  • Profile Image
    Laura_L
    Answered on October 29, 2020 at 03: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,