A filter is used to control when an action should be performed. It allows you to set conditions that must be met for the workflow to continue. Filters help ensure that only relevant data triggers an action, thus preventing unnecessary executions.
For example, you can set a filter to add data to Google Sheets only if a form entry contains a specific keyword.
Here is a list of filters you can use:
Filter Condition | Description | Examples |
is equal to | Matches values that are exactly the same as the filter value. | status is equal to "Approved" |
is not equal to | Matches values that are different from the filter value. | status is not equal to "Rejected" |
is greater than | Matches values that are larger than the filter value. | lead_value is greater than 10000 |
is greater than or equal to | Matches values that are larger than or equal to the filter value. | lead_value is greater than or equal to 5000 |
is less than or equal to | Matches values that are smaller than or equal to the filter value. | lead_value is less than or equal to 5000 |
is less than | Matches values that are smaller than the filter value. | lead_value is less than 10000 |
contains | Matches values that include the filter value within them. | feedback contains "urgent" |
does not contain | Matches values that do not include the filter value. | feedback does not contain "spam" |
ends with | Matches values that finish with the filter value. | email_address ends with "@example.com" |
doesn't end with | Matches values that do not finish with the filter value. | email_address does not end with "@spam.com" |
starts with | Matches values that begin with the filter value. | phone_number starts with "+1" |
doesn't start with | Matches values that do not begin with the filter value. | phone_number does not start with "+44" |
is | Matches values that are the same type as the filter value. | price is of type "number" |
is not | Matches values that are not the same type as the filter value. | date_of_birth is not of type "string" |
is empty | Matches values that have no content. | comments is empty |
is not empty | Matches values that have some content. | comments is not empty |
Still have some questions? Contact us at support@konnectify.co