-
JWSWasteAsked on May 23, 2020 at 8:53 AM
Hi There, we are looking to see whether this may work for us to add a form to our website for pricing, we have a complex pricing matrix that I would like to use as the background information, I have attached a copy of it.
Its complicated as it relies on 3 elements to generate a price
Container Size
Waste type
Post Code
I've tried a few different ways on here with drop downs and product matrix but i just cant seem to make it conditional on 3 variables?
Can you assist? Thanks a million
Alyson
-
Kenneth JotForm SupportReplied on May 23, 2020 at 10:21 AM
Thank you for reaching support,
To clarify, you will be using 3 variables(Container Size, Waste type, Post code) in your calculations for the price?
If so, then feel free to any of our form elements and get the "Unique name" or "field name" and use it in your form calculation: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget
Feel free to check on our conditional logic guide: https://www.jotform.com/help/57-Smart-Forms-Conditional-Logic-for-Online-Forms
Let us know how your form build goes.
Best.
-
JWSWasteReplied on May 24, 2020 at 5:02 AM
thanks for that but its more complicated than that, so each variable can have multiple variables
so
Container size (6 options - each priced differently)
Waste type (8 options all priced differently)
Postcode (90 options all priced differently)
so a working example is
8 yard skip with general waste to M6 would be different to
8 yard skip with construction waste to M6
It would be so much easier if in the 'if' questions I could but a range of postcodes for example instead of just a single one?
-
Flavio_AReplied on May 24, 2020 at 9:11 AM
Hi Alyson
Unfortunately, it is not possible to set a condition based on a range of postcodes. The best you could do to save some work is to add more than one possible condition for the same output, as shown below:
Additionally, if I understood you correctly, there are only three different price categories according to the postcode. If that is correct, you could save some work by creating a hidden field named Postcode Zone, for example, then use it to group the postcode conditions. Afterwards, you would just need to use that field with three variables to set up the remaining conditions.
Alternatively, even though I know you wanted it all in the background, you could exhibit the postcode zones table in your form and ask the user to choose the correct zone.
Please consider those options and let us know if we can assist you any further.
-
JWSWasteReplied on May 24, 2020 at 1:10 PM
that sounds doable but can you show me how to do the 2nd part of that, I cant figure it out,
-
Flavio_AReplied on May 24, 2020 at 3:29 PM
Hi @JWSWaste
I have built this demo form so you can understand it better:
https://form.jotform.com/201444068237048
Basically, I have created a group of conditions for each of the three postcode zones, as you can see below. You can expand the lists of postcodes within each zone.
That is useful because you will be reducing the number of conditions you will have to create with the other variables.
I have built the demo form with 2 variables for Waste type and 2 variables for Container size. Considering I had 3 postcode zones, it amounts to 12 conditions created. You can clone the demo form and have a closer look at the conditional logics I created.
You could save some work if any of those variables are fixed. In that case, instead of creating more conditions, you could use a form calculation using a widget. For example, you could define that by choosing a specific type of waste, clients would pay +$10 whatever the other variables are.
Please have a look at the form I made and let us know if you need any further assistance.
-
JWSWasteReplied on May 24, 2020 at 3:30 PM
also the integration with zoho is not working, it looks as it if does but only brings up and empty white window?
-
JWSWasteReplied on June 2, 2020 at 5:07 PM
HI there, I cloned the form and it seemed to work and now I seem to have broken - could I ask you to take a look to see if you can establish what I have done wrong? Its called Clone of Matrix Form, thanks so much
-
Kenneth JotForm SupportReplied on June 2, 2020 at 6:18 PM
Hi there,
I copied your cloned form and I was able to successfully make a submission:
Do you mind telling us what seems to be broken on this form? Also, I don't see any Zoho integration on this cloned form.
Thank you for being patient with us.
Awaiting your response.