What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Complex calculation using calculate field or what do you suggest?Asked by tidychamps on January 17, 2017 at 06:40 PM
I am configuring the form to populate service rate based on 2 factors only - 1) House size and 2) Type of Service . That seems like a simple calculation however here are the problems:
When a customer select condition 1, they have to choose one of 6 options under condition 2. Here is how it works:
Condition 1 - checkbox (10sf, 20sf, 30sf) - form responded will select one of the 3 options.
Condition 2 - checkbox (daily, 1x per week, 1x every 2 weeks, monthly, one-time standard, one-time deep, moving)
When they selected one of the options in condition 1, they have to choose one of the services in condition 2
Case 1 - customer has 10sf but they have to select what service option they need
10sf and daily = service price for daily 10sf
10sf and 1x weekly = service price for 1x per week 10sf
10sf and 1x every 2 weeks = service price for 1x every 2 weeks 10sf
10sf and monthly = service price for monthly 10sf
Case 2 - customer has 20sf but they have to select what service option they need
20sf and daily = service price for daily 20sf
20sf and 1x weekly = service price for 1x per week 20sf
20sf and 1x every 2 weeks = service price for 1x every 2 weeks 20sf
20sf and monthly = service price for monthly 20sf
Case 3 - customer has 30sf but they have to select what service option they need
30sf and daily = service price for daily 30sf
30sf and 1x weekly = service price for 1x per week 30sf
30sf and 1x every 2 weeks = service price for 1x every 2 weeks 30sf
30sf and monthly = service price for monthly 30sf
I need help getting this together.
I think jotform can handle this but not sure if this is is too much for calculate/update field to handle, or if this is for math function or array, or whatever. I have stuggled with this for some time and someone out there could help me, that will be great.
I have attached what is expected on the result in a table
Please allow me some time to investigate this further and I will get back to you with a possible workaround. Regards.
Based on the information provided, I have setup a demo form that will calculate the rates based on your requirements. Please follow this link to view the demo: https://form.jotform.com/70168987091972 You can also clone it to your account by following this guide: How to Clone an Existing Form from a URL
The way I set it up is I first added a base rate as the calculation value for each of the options in the condition 2. You can add calculation values by following this guide: How to Assign Calculation Value
weekly = 20
1 every 2 weeks = 30
three weeks = 40
Then assign a calculation value for each option in Condition 1.
10sf = 0
20sf = 5
30sf = 15
Once this is done, I have added a calculation field where we will insert the calculated value.
I then setup several conditions that will add the calculation values from both radio fields. You can clone the form as instructed above to check each of these conditions. Here's a guide that may help: Smart Forms Using Conditional Logic
After that, you're all set. You can clone and modify the demo per your requirement. If you need further assistance, please let us know.