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

    How to setup conditions with multiple any/all rules?

    Asked by athdept on August 16, 2016 at 02:26 PM

    Hello-

    I have conditions set up for my facility managers. When their buildings are selected, they should receive an email. There are two questions related to facilities so I have the condition match set to "Any". I want to add another condition that would prevent them from receiving emails if Q#37 is filled/completed. Is it possible to add this to the existing condition or should I create a separate condition? Take condition #14 for example. I want to revised it to the following:

    If Q#36=Crisler OR Q#35=Crisler AND Q#37 is blank THEN send the email to lenzack.

    Is this possible?

    Page URL:
    https://form.jotform.com/51685529235967

    all Emails create selected hello
  • Profile Image
    JotForm Support

    Answered by Kiran on August 16, 2016 at 03:37 PM

    With the example of the condition #14, it is required to edit the existing condition and also add a new condition as well. Due to the limitations of the conditions on the form, you can set the conditions as shown below:

    1. Q#35=Crisler AND Q#37 is blank then send email

    2. Q#36=Crisler AND Q#37 is blank then send email

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help. 

  • Profile Image

    Answered by athdept on August 16, 2016 at 03:55 PM

    Is there a cleaner solution? I have facility managers that have up to 6 or 7 locations (per question). Doing it this way would cause me to have a significant number of conditions (in addition to the 20+ I already have). I'm after it will causing issues with the form.  Thanks.

  • Profile Image
    JotForm Support

    Answered by Kiran on August 16, 2016 at 04:27 PM

    Please allow me some time to see if I can get any workaround for your requirement. I'll get back to you later with relevant information.

    Thank you for your patience. 

  • Profile Image

    Answered by athdept on August 17, 2016 at 08:47 AM

    No problem. Thanks for looking into this.

  • Profile Image

    Answered by athdept on August 17, 2016 at 08:51 AM

    Could I add another separate condition (just 1 condition) for all facility managers that checks to see if the Q37 is blank? 

  • Profile Image
    JotForm Support

    Answered by Charlie on August 17, 2016 at 11:25 AM

    You could add multiple conditions separately as long as they do not conflict. I am not quite sure if I understood your condition correctly. Could you please provide us more information on what you meant? I see that my colleague mentioned that he is looking for a workaround, I'll notice him about this.

    Thank you.

  • Profile Image

    Answered by athdept on August 17, 2016 at 11:39 AM

    Ultimately I have two questions and either or could have an answer. I want to add a condition but jotform only allows for one "if" rules are matched. I want to create a condition that has two "if" rules are matched. Take the following for example: 

    If Q#36=Crisler OR Q#35=Crisler AND Q#37 is blank THEN send the email 

    If Q36 OR Q35 either is answered (i.e. if any of the if rules are matched) AND IF Q37 is blank (if all of the if rules are matched) then I want to send an email to the appropriate facility manager. 

    Make sense? 

  • Profile Image
    JotForm Support

    Answered by Charlie on August 17, 2016 at 01:03 PM

    You need to create two separate condition blocks.

    Here's how it should be done from what I understood:

    Condition #1:

    IF Q#36=Crisler AND Q#37 is blank then SEND email alert 1

    Condition #2:

    IF Q35=Crisler AND Q#37 is blank then SEND email alert 1

     

    That is the same logical effect of the one you presented. You can have multiple IF statements and use OR/AND on them, the problem is that you cannot create a combination of IF statement with an OR and an AND rule. But it can be done by creating separate conditions as shown above.

    Is that what you are aiming for?

  • Profile Image

    Answered by athdept on August 17, 2016 at 01:34 PM

    That is the what you colleague recommended. The problem  I have facility managers that have up to 6 or 7 locations (per question). Creating a condition for each would cause me to have a significant number of conditions (in addition to the 20+ I already have). I'm afraid it will causing issues with the form. 

  • Profile Image
    JotForm Support

    Answered by Kiran on August 17, 2016 at 03:05 PM

    If you are having the email addresses based on the checkboxes field, you may consider adding the email addresses as the calculation values so that they are copied to a separate textbox field for sending email using an autoresponder. Please see the screencast below that can help you with setting up the calculation values and a condition to read the values to a textbox:

    This text box can be used directly in the auto-responder so that you need not to setup any other conditions except for checking Q37 and helps in minimizing the conditions on the form.

    If the emails are duplicated also in the textbox, the email will be sent only once. Let us know if this doesn't help. We will be happy to assist you further. 

  • Profile Image

    Answered by athdept on August 17, 2016 at 03:23 PM

    This looks like a clever way of handling this issue! Just so I am clear I need to follow the following steps:

    1) I need to add the appropriate email addresses to the checkbox questions (surveying)

    2) Create an email (text box)

    3) Create a condition/calculated field to place the emails into the email (text box)

    4) Create a condition that checks to see if Q37 is filled

     

    Did I miss something?

  • Profile Image
    JotForm Support

    Answered by Kiran on August 17, 2016 at 05:39 PM

    You are right. You can hide the newly added email textbox field on the form so that not to display the email addresses. 

    If you need any further assistance in this regard please let us know. We will be happy to assist. 

  • Profile Image

    Answered by athdept on August 18, 2016 at 03:04 PM

    I have implemented your recommendation and tested it. Seems to be a good solution for my issue! Thanks for your help in this. My only concern is if facilities from #35 is selected only. The email field populates with a comma. Will this cause an error in sending emails?

  • Profile Image
    JotForm Support

    Answered by Welvin on August 18, 2016 at 05:35 PM

    I have just tested the same method, the emails are sent even when there's a comma after the last email. With this, I think that's not going to be a problem.

  • Profile Image

    Answered by athdept on August 19, 2016 at 08:46 AM

    Thanks for validating!