-
bsobotAsked on February 11, 2017 at 3:55 PM
I need help with how to configure this form to show the calculated result based on this conditions.
I have tried everything and I could figure out and still no success. The form can be accessed from the link below
https://form.jotform.com/70416185867161
There are 2 options there.
Option 1 is House Size - each of this house size is and related price is fixed - and i have about 11 groups as follows:
Under 1000 to 5501-6000. the Cost of each groups is as follows with base prices as follows
less 500 (not used)
less than 1000 = $25
1001-1500 = $50
1501-2000 = $100
2001-2500 = $125option 2 - Cleaning frequency,
none (not used)
weekly
every 2 weeks,
monthly,
one-time standard,
one-time deep clean,
move-in move-out
the way this is supposed to work is this.
When option is selected - say first item which is "less than 1000"
The estimate should take into account what the frequency option does. and give the cleaning estimate based on that.
so when option 1 is chosen - "less than 1000", and slider is at option 2, "weekly", we should have something like
$25 as the result. or when "every 2 weeks" is selected, the result should be something like $45, and so on for the first group and option definitions.
I think I have idea what I am supposed to do, but not so sure right now how to accomplish that.
Any help will be appreciated.
Page URL: https://form.jotform.com/70416185867161 -
Kevin Support Team LeadReplied on February 11, 2017 at 8:20 PM
I have checked your form and noticed that the options values are still as default, do note that if you do not change them, each option will increase in 1 which means that the first option will have a value of 1, second 2 and so on.
What you need to do is to set values for your options, for example, the first slider should be set up like this, as per your explanation:
House Size in sq ft
names = less than 1000, 1001-1500, 1501-2000, 2001-2500
values = 25, 50, 100, 125
Do note that when you add values, the min and max variables will be ignored, you can also set a default value, but it needs to be one from the "values" variable.
If you have also values for your frequency options, then you should set them the same way as the House Size, here's also a cloned form of yours with the change applied and it works fine: https://form.jotform.com/70417506197963
You can also clone it and inspect what I changed to the widget: How-to-Clone-an-Existing-Form-from-a-URL
Hope this helps.
-
b. simonReplied on February 15, 2017 at 4:56 PM
I was able to solve this problem using the idea that you started with your answer.
However, Now I have a different problems,
I am trying to capture each option points from the slider and output the results on the confirmation form, or pass the values to in a string to the booking system.for example, if the customer selected house size 2001 - 2500, and frequency of weekly, for a total of $4
I want to be able to capture the values of 2001 - 2500 and weekly frequency and pass those states to a booking form to complete booking.
So, how do I figure out exactly which form parameters I need to pass. This slider with calculated result does not expose that information.
Any thoughts on this will be appreciated.
Thanks.
-
Kevin Support Team LeadReplied on February 15, 2017 at 6:19 PM
Glad to know this helped.
Regarding to your second question, I have moved it to another thread since it's not related to this one, you will find it here: https://www.jotform.com/answers/1067617
We will assist you on that thread as soon as possible.