Complicated Pricing Matrix for a form

  • Profile Image
    JWSWaste
    Asked on May 23, 2020 at 08:53 AM

    1590238340z.jpg

    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



  • Profile Image
    Kenneth_C
    Answered 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.

  • Profile Image
    Flavio_A
    Answered on May 24, 2020 at 09: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 à

    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.

  • Profile Image
    JWSWaste
    Answered on May 24, 2020 at 01:10 PM

    that sounds doable but can you show me how to do the 2nd part of that, I cant figure it out,

  • Profile Image
    Flavio_A
    Answered on May 24, 2020 at 03: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 à

    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.

  • Profile Image
    JWSWaste
    Answered on May 24, 2020 at 03:30 PM

    also the integration with zoho is not working, it looks as it if does but only brings up and empty white window?

  • Profile Image
    JWSWaste
    Answered on June 02, 2020 at 05: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

  • Profile Image
    Kenneth_C
    Answered on June 02, 2020 at 06:18 PM

    Hi there,

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

    1591136183j1.png

    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.