Need help with EQUAL TO condition on my form

  • cjamps
    Asked on May 22, 2016 at 3: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.

    Need help with EQUAL TO condition on my form Image 1 Screenshot 20

  • Elton Support Team Lead
    Replied on May 22, 2016 at 5: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.

  • cjamps
    Replied on May 25, 2016 at 4: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.

  • beril JotForm UI Developer
    Replied on May 25, 2016 at 8: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:

    Need help with EQUAL TO condition on my form Image 1 Screenshot 20

    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.

  • cjamps
    Replied on May 26, 2016 at 6: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

     

  • beril JotForm UI Developer
    Replied on May 26, 2016 at 8: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:

    Need help with EQUAL TO condition on my form Image 1 Screenshot 40

     

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

    Need help with EQUAL TO condition on my form Image 2 Screenshot 51

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

    Need help with EQUAL TO condition on my form Image 3 Screenshot 62

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

     

  • cjamps
    Replied on June 8, 2016 at 5: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.

  • beril JotForm UI Developer
    Replied on June 8, 2016 at 7: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.

    Need help with EQUAL TO condition on my form Image 1 Screenshot 30

    It should be as you see below:

     

    Need help with EQUAL TO condition on my form Image 2 Screenshot 41

     

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

     

  • cjamps
    Replied on June 8, 2016 at 7: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.

  • beril JotForm UI Developer
    Replied on June 8, 2016 at 9:28 AM

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

     

    Need help with EQUAL TO condition on my form Image 1 Screenshot 50

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

    Need help with EQUAL TO condition on my form Image 2 Screenshot 61

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

    Need help with EQUAL TO condition on my form Image 3 Screenshot 72

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

    Need help with EQUAL TO condition on my form Image 4 Screenshot 83

     

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

  • cjamps
    Replied on June 9, 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.

  • Elton Support Team Lead
    Replied on June 9, 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!