Create Filters with Advanced Criteria for Sending Conditional Emails

While setting up conditional emails with the Form Emails add-on, you create filters with complex criteria. Each condition in the conditional logic window can contain one or more criteria and you may use AND/OR operators to specify whether the criteria is optional or mandatory.

Filter by Advanced Criteria in Google Forms​

The Google Forms add-on lets you easily create advanced filters with multiple criteria. Here are some examples.

Criteria for Comparing Text Fields​

• Equals - Answer exactly matches the specified text
• Any of - Specify a list of values (comma separated) and the answer should be one of these values
• None of - Answer should not equal to any item in the list (comma separated)
• Contains - Text is anywhere inside the answer field
• Does not contain - Answer does not contain the specified text
• Is Empty - The answer is blank
• Is Not Empty - The answer contains at least one character (not blank)

If you would like to check if an answer is among a list of possible values, use a single Contains criterial instead of creating multiple criteria with the Equals filter.

Comparison operators for Numeric Fields​

• Equal to == - Answer matches the specified numeric value
• Not Equal to != - Answer doesn't match the number
• Greater than - Answer is greater or equal to number
• Less than - Answer is less or equal to number

If you would like to check if an answer is between two numbers, create two conditions for the same field - greater than the lower limit and lower than the upper limit.