What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Conditions: Using 2 rules to update a form field value

    Asked by Wtfuck on April 29, 2015 at 09: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

     

    Screenshot
    quotation form quotation conditions update form field using condition rule
  • Profile Image
    JotForm Support

    Answered by Jan 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.

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

    Thank you.

     

  • Profile Image

    Answered by Wtfuck 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

  • Profile Image
    JotForm Support

    Answered by KadeJM on April 29, 2015 at 02: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.