-
Jasmin PopovskiAsked 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.
Page URL: https://form.jotform.co/83236494625867 -
tolgatuzcuReplied 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.
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
Let us know if you have any questions or if you need further assistance.
-
Jasmin PopovskiReplied on December 12, 2018 at 11:43 PMCould 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.
... -
tolgatuzcuReplied 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.
2. Click Properties.
3. Click the Fields tab. Select currency box to enter price unit. Enter the names of Row.
4. Click the Settings tab at the top of the page. Click on the Conditions tab and then click on plus.
5. Click Update / Calculate Field.
6. Select the Monthly Expenses for the IF part. Select Is Filled for STATE
7. Select Calculate a field’s value for DO.
8. Select the field to add to the Monthly Expenses.
9. In the table, select all rows except Total.
10. Make add Field except the last one and add plus between them.
11. In the Summary section, select Monthly Expenses.
12. Select and save the total.