Also in the form, I have an input table below. I need to calculate both input tables values into Grand Total? Is that possible. If you can help that w

  • Profile Image
    jharschawf
    Asked on June 25, 2020 at 10:46 AM
    Also in the form, I have an input table below. I need to calculate both input tables values into Grand Total? Is that possible. If you can help that would be great.
  • Profile Image
    KrisLei
    Answered on June 25, 2020 at 12:44 PM

    Hi,

    I have checked your form and cloned it. To clarify, are you referring to the "Cost Categories" Input Field? If so, you would need to add a Short Text Field after the Input Table field.

    The Short Text Field is where it will display the total amount:

    1593102420Total amount.jpg

    Then create a condition to add the values inside the Input Table, through the Update/Calculate Field logic. Please refer to my screencast below:

    1593102872condition.gif.gif

    For reference: Calculate-Values-in-the-Input-Table-Through-Condition

    Here's the condition created to display the values on the short text field:

    1593103418condition.jpg

    Feel free to clone and test it on this cloned form for your reference: https://form.jotform.com/201764968109969 

    Kindly try it on your end, then let us know if you need further assistance.