Conditions: Using 2 rules to update a form field value

  • Wtfuck
    Asked on April 29, 2015 at 9:17 AM
    Hello Everyone,

    I am building a new form on Jotform and I have one matter

    I am selling custom Tshirts and I want to make a quotation form in 3 Steps

    1st Step :
    The customer choose between 2 references of Tshirt  (Short Sleeve, Long Sleeve)

    2nd Step :
    The customer choose the quantity of Tshirts he wants to make (example : 41 Tshirts)

    3rd Step :
    The customer choose the number of colors of his logo (example : 3 colors Logo)

    Final Step : Quotation
    To make the quotation, I need that jotform is searching the price in a table like table attached.
    https://www.dropbox.com/s/ufiqkehexklqfok/Example.xlsx?dl=0

    I want jotform say to me that the price for 41 Tshirts 3 colors logo is for example = 5,90€

     

    Is there any possibility to ask jotform to search a value in a double entry table ?

    Thanks

     

    Jotform Thread 561072 Screenshot
  • Jan
    Replied on April 29, 2015 at 11:19 AM

    Hi there,

    You can do this by using 2 rules under 1 condition. I created a demo form, please check it. (http://support.jotform.com/form/51184238900957). You can clone it if you like.

    I used the "Update a form field value" condition and used 2 rules. I created around 12 conditions. I know that you are familiar with using JotForm conditions, so this will be easy for you.

    Conditions: Using 2 rules to update a form field value Image 1 Screenshot 20

    Hope this helps. If not, let us know how can we further assist you.

    Thank you.

     

  • Wtfuck
    Replied on April 29, 2015 at 12:18 PM

    Hello Jan,

    On the number Is it possible to have instead of a radiobox of T-Shirt a textbox with the exact qty of my quotation.

    I need to have exact quantity.

    Thanks

  • KadeJM
    Replied on April 29, 2015 at 2:59 PM

    Did you mean that you want to replace the "Radio Field" with a "Textbox Field"?

     

    You should can do that if you want but then that means the conditions and calculations for it would need to be modified to make it work with each one because you would need a rule to match each of your quantities the workflow you seek for this. 

    Here's an updated demo: https://www.jotform.com/form/51186219347963? 

    I left the original radio there but was just using the first set from the radio above for 15-20 which I reassigned to the text field.

    Conditions: Using 2 rules to update a form field value Image 1 Screenshot 20