Complicated Pricing Matrix for a form

  • JWSWaste
    Asked on May 23, 2020 at 8:53 AM

    1590238340z Screenshot 10

    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 Support
    Replied 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.

  • JWSWaste
    Replied 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_A
    Replied 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:

    1590325379Captura de Tela 2020 05 24 à Screenshot 10

    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.

  • JWSWaste
    Replied 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_A
    Replied 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.

    1590347190Captura de Tela 2020 05 24 à Screenshot 10

    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.

  • JWSWaste
    Replied 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?

  • JWSWaste
    Replied 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 Support
    Replied on June 2, 2020 at 6:18 PM

    Hi there,

    I copied your cloned form and I was able to successfully make a submission:

    1591136183j1 Screenshot 10

    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.