How to use Calculate Values in the Input Table?

  • Jasmin Popovski
    Asked on December 12, 2018 at 12:22 AM

    Hi 

    I'd like assistance on Page 3 of the document called Franchisee Application Form (sample) - within my account. 

    I'd for the required input figures to calculate within the total cell. 

    I do not understand on how to form the calculations within Properties - Option - Calculation Values.

    Jotform Thread 1670588 Screenshot
  • tolgatuzcu
    Replied on December 12, 2018 at 7:11 AM

    Hi,

    1. After you use INPUT TABLE field into your form you should follow this steps.


    2. Click the SETTINGS tab. You can find it at the top of the FORM BUILDER. Click the CONDITIONS on the left side and then go to UPDATE / CALCULATE FIELD.


    How to use Calculate Values in the Input Table? Image 10


    3. Now create a condition for the INTRODUCTION TABLE. This allows calculation when someone fills the field. Example: IF Input Table IS FILLED, then DO calculate a field's value


    How to use Calculate Values in the Input Table? Image 21

    How to use Calculate Values in the Input Table? Image 32

    Let us know if you have any questions or if you need further assistance. 


  • Jasmin Popovski
    Replied on December 12, 2018 at 11:43 PM
    Could you please provide a step by step process of how to do this – im very confused
    Thank you,
    Jasmin Popovski Franchise Recruitment Manager
    E jasmin.popovski@chatime.com.au
    P 02 9283 0880 F 02 9264 3330
    Suite 2, Level 7, 66 Goulburn Street, Sydney NSW 2000
    [https://chatime.com.au/wp-content/uploads/sites/6/2018/11/181107_Chatime_Gingerbread_781x173px_EmailSignature.jpg]
    Please consider our environment before printing this email. This email and any attachments provided are shared in confidence and should not be distributed in any form to any third party without the express permission of Chatime employees.
    ...
  • tolgatuzcu
    Replied on December 13, 2018 at 9:17 AM

     

    Hello,

     

    I've sampled the steps to follow on your form. You can follow the steps below.

     

    1. First of all, you must enter the name of Monthly Expenses in the table name field.

     

    1544710254Slice 1 Screenshot 10

     

    2. Click Properties.

     

    1544710211Slice 1 2 Screenshot 21

     

     

    3. Click the Fields tab. Select currency box to enter price unit. Enter the names of Row.

     

    1544710296Slice 1 3 Screenshot 32

     

     

    4. Click the Settings tab at the top of the page. Click on the Conditions tab and then click on plus.

     

    1544710330Slice 1 4 Screenshot 43

     

     

    5. Click Update / Calculate Field.

     

    1544710383Slice 1 5 Screenshot 54

     

     

    6. Select the Monthly Expenses for the IF part. Select Is Filled for STATE

     

    1544710420Slice 1 6 Screenshot 65

     

     

    7. Select Calculate a field’s value for DO.

     

    1544710447Slice 1 7 Screenshot 76

     

     

    8. Select the field to add to the Monthly Expenses.

     

    1544710476Slice 1 8 Screenshot 87

     

     

    9. In the table, select all rows except Total.

     

    1544710506Slice 1 9 Screenshot 98

     

     

    10. Make add Field except the last one and add plus between them.

     

    1544710530Slice 1 10 Screenshot 109

     

     

    11. In the Summary section, select Monthly Expenses.

     

    1544710560Slice 1 11 Screenshot 1110

     

     

    12. Select and save the total.

     

    1544710586Slice 1 12 Screenshot 1211