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

    Need help with EQUAL TO condition on my form

    Asked by cjamps on May 22, 2016 at 03:18 AM

    My conditions are not working.  If the city IS EQUAL to "Lakewood", "Brooklyn" or "Spring Valley" nevertheless the category always winds up as "Tiferes Miriam Email Other"

    How can I correct this?

    Thanking you in advance.

    Page URL:
    http://cjamps.wix.com/tiferesmiriam#!register/xiecy

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 22, 2016 at 05:02 AM

    In your screenshot, you are using "IS NOT EQUAL TO" which contradicts your description "IS EQUAL TO". Could this be the problem?

    If you want to use "IS NOT EQUAL TO", I suggest to change "ANY" with "ALL", otherwise, each of the IF statement would be checked and when it is true, it would trigger the condition.

    If you need further clarifications, let us know here.

  • Profile Image

    Answered by cjamps on May 25, 2016 at 04:21 AM

    I changed the NOT EQUAL TO to all and now category contains Tiferes Miriam Email OtherTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email Brook

    Basiically it is an IF ELSE ENDIF statement.

    IF City IS EQUAL TO Brooklyn

    THEN INSERT Tiferes Miriam Email Brooklyn INTO Category

    ELSEIF  City IS EQUAL TO Monsey

    THEN INSERT Tiferes Miriam Email Monsey INTO Category

     City IS EQUAL TO Lakewood

    THEN INSERT Tiferes Miriam Email Lakewood INTO Category

    OTHERWISE

    INSERT Tiferes Miriam Email Other INTO Category

     

    How do I code it.

  • Profile Image
    JotForm Support

    Answered by beril on May 25, 2016 at 08:17 AM

    You need to create your conditions individually. Because the values of the category are different. We would appreciate it if you could create your conditions as you see below:

    You can also clone your test form. Here is your cloned form:

    https://form.jotform.com/61452992579975

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image

    Answered by cjamps on May 26, 2016 at 06:30 AM

    The above reply is how I had it in the beginning. For some reason with the above method even though a member could live in Brooklyn, Lakewood or Spring Valley the Category is always equal to Tiferes Miriam Email Other.

    How can I prevent that from happening?

    Thanx

     

  • Profile Image
    JotForm Support

    Answered by beril on May 26, 2016 at 08:10 AM

    I've tested your cloned form. I am able to reproduce the same issue that you’re having. To solve that issue, we would appreciate it if you could change the condition as you see below:

     

    For testing, I entered the 'Brooklyn' as a value. I am able to see the Brooklyn in Category as you see below:

    After that, I've tested it with another word. It is also working properly on my side.

    We would appreciate it if you could also test it on your side and let us know the result.

     

  • Profile Image

    Answered by cjamps on June 08, 2016 at 05:18 AM

    I set it up like you said (I think?)  I have tested it a few times and it is always being saved as Tiferes Miriam Other no matter where the person lives.  I am using mailchimp.

    Can you see what I am doing wrong?

    Any help or advice would be greatly appreciated.

  • Profile Image
    JotForm Support

    Answered by beril on June 08, 2016 at 07:17 AM

    Thank you for replying us. I don't think, it is related to MailChimp Integration. You need to use All instead of  Any while creating your condition.

    It should be as you see below:

     

     

    If this does not resolve the issue, please let us know and we will be glad to take another look.

     

  • Profile Image

    Answered by cjamps on June 08, 2016 at 07:56 AM

    I appreciate the help.  I must have missed that answer.  

    Ok.  I did change it to all and Category contained:

    I appreciate the help.  I must have missed that answer.

    Ok.  I did change it to ALL and now category contains:

    Tiferes Miriam Email OtherTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email BrooklynTiferes Miriam Email Brook.

    Tiferes Miriam Email Brooklyn is correct.  But why does it say Tiferes Miriam Email Other first and why does it say Tiferes MIriam Email Brooklyn so many times.  I only need it once.!

    Thanx again.

  • Profile Image
    JotForm Support

    Answered by beril on June 08, 2016 at 09:28 AM

    You're most welcome. When I've tested your form I am able to reproduce the same issue that you're having.

     

    That is strange.=) However, I think I found the issue. Could you please delete Category on your condition as you see below?

    After that, you can re-write "Category" by using the keyboard so it will display as a character.

    At that time, it is working properly on my side.

     

    We would appreciate it if you could also test it on your side and let us know the result.

  • Profile Image

    Answered by cjamps on June 09, 2016 at 10:07 AM

    THANK YOU!

    I think it is working now.  I actually took out the word Category from all of them.  I didn't realize that "Category" by summary said it all and I didn't have to put the field name there.

    Your help was much appreciated.  If I have any more issues with it I will let you know.

  • Profile Image
    JotForm Support

    Answered by EltonCris on June 09, 2016 at 11:32 AM

    Great! We are happy to hear that it is working now.

    If you run into any issues again, feel free to let us know by creating a new thread.

    Cheers!