Features

Filter and path rules in FlowMattic

Estimated reading: 5 minutes

Use filters to guarantee that operations are only carried out on the objects you choose. With filters, you can specify a certain criterion to reach the desired level of granularity.

For instance, you can configure a filter to only record emails with a particular topic line or just clients who make a particular product transaction. Therefore, the next action in your FlowMattic workflow is initiated when the data from your previous action steps including triggers satisfies the criteria of a filter. No more actions are taken if a filter stops an item.

A task that is not passed by a filter is not executed while the workflow execution. Only tasks that are passed by filter are executed..

Filter rule types

Different logical rules can be applied using filters. Only the type of data that is indicated in brackets can be used with conditions. Text, numeric, date/time, boolean, and generic are the five different categories of filter rules.

Examples

You can see which fields would satisfy a particular rule in this table. Each example’s Rule is the filter rule that we’ve specified, the Value is what we’re comparing it to, and the Examples are inputs from action or trigger responses that the filter is comparing.

RuleValueExamples that would passExamples that wouldn’t pass
(Text) ContainsApples and bananasApples Apple Apples and bananasStrawberries
(Text) Does not containApples and bananasStrawberriesApple
(Text) Exactly matchesApplesApplesApple (not plural) apple (not uppercase)
(Text) Does not exactly matchApplesApple Banana And moreApples
(Text) Is inApples, bananasApples BananasApple Banana Strawberries
(Text) Is not inApples, bananasStrawberries AppleApples Bananas
(Text) Starts withAppApples ApplesauceApricots Bananas
(Text) Does not start withAppApricots BananasApples Applesauce
(Text) Ends withsBananas Apple and bananasApple
(Text) Does not end withsApple BananaApples Bananas
(Number) Greater than10111009-1
(Number) Less than109-1100
(Date/time) After12/31/2018 1:0001/01/2019 12/31/2018 01:0112/31/2017
(Date/time) Before12/31/2018 1:0012/31/201701/01/2019
(Date/time) Equals12/31/2018 1:0012/31/2018 1:0012/31/2019 12/31/2018 00:00
Existsn/aApple 10 01/01/2019
Does not existn/aApple 10 01/01/2019

Text filters

Text filters only work with text data, so they won’t work with numbers or dates.

  1. Contains: Verifies if a field contains a specific value. It is not case-sensitive.
  2. Does not contain: Verifies if a field does not contain a specific value. It is not case-sensitive.
  3. Exactly matches: Checks if a field matches a value precisely, letter-for-letter. It is case-sensitive.
  4. Does not exactly match: Checks if a field does not match a value precisely, letter-for-letter. It is case-sensitive.
  5. Is in: Determines if a field exists in a list of values. It is not case-sensitive.
  6. Is not in: Determines if a field does not exist in a list of values. It is not case-sensitive.
  7. Starts with: Validates if a field starts with a particular value. It is not case-sensitive.
  8. Does not start with: Validates if a field does not start with a particular value. It is not case-sensitive.
  9. Ends with: Verifies if a field ends with a specific value. It is not case-sensitive.
  10. Does not end with: Verifies if a field does not end with a specific value. It is not case-sensitive.

Number filters

Number filters only work with numeric values, like 1 or 100. They do not work with written forms of numbers (one, two, one hundred) or dates.

  1. Greater than: Checks if a numerical field is greater than a specific value.
  2. Less than: Checks if a numerical field is less than a specific value.
  3. Equal to: Checks if a field is equal to a specific value. This is case-sensitive for text fields and exact for numerical fields.
  4. After (date/time): Checks if a date or time field occurs after a specific date or time.
  5. Before: Checks if a date or time field occurs before a specific date or time.
  6. Equal: Checks if a field is equal to a specific value. This is case-sensitive for text fields and exact for numerical fields.

Boolean filters

  1. Is true (Boolean): Checks if a Boolean field is set to true.
  2. Is false: Checks if a Boolean field is set to false.

Generic filters

  1. Exists: Checks if a field has a value or is not empty.
  2. Does not exist: Checks if a field does not have a value or is empty.

If you have a series of items like this:

Whether FlowMattic continues to pass the filter depends on whether you use positive or negative filter conditions.

Examples of positive filter conditions are “contains” and “starts with”.

Examples of negative filter conditions are “does not contain” and “does not start with”.

If all filter conditions are positive

If all conditions are positive, at least one line item must pass all filter conditions for FlowMattic to continue.

In the example below, one item satisfies both positive conditions, even though the other does not, so FlowMattic continues. 

If the filter condition is both positive and negative, or all negative

If negative conditions are included, all line items must pass all filter conditions for FlowMattic to continue.

In the example below, one or more line items did not meet the filter criteria, so FlowMattic will not continue. 

Share this Doc

Filter and path rules in FlowMattic

Or copy link

CONTENTS

How to Embed Table on Frontend of your website?

Displaying tables on the frontend of your website is an excellent way to share s

License Activated, but Still Shows Not Active on Integrations Page

If you’ve activated your FlowMattic license but still see a “License

Delay or Scheduled Workflows not working

If your delayed or scheduled workflows in FlowMattic are not working as expected

Webhook not capturing response

If your webhook is not capturing a response in FlowMattic, there could be a vari

Number Formatter by FlowMattics

FlowMattic’s Number Formatter is a versatile tool designed to handle various num

Webpage Parser by FlowMattic

FlowMattic’s Webpage Parser is a versatile tool designed to streamline the proce

XML Parser By FlowMattic

FlowMattic’s XML Parser is an essential tool designed to streamline data integra

CSV Parser by FlowMattic

The CSV Parser by FlowMattic is a powerful tool designed to help users effortles

Counter by FlowMattic

The Flowmattic Counter is a versatile feature designed to track and manage numer

Tables by FlowMattic

Step 1: Set the Database Location The first thing you need to do to use the Tabl

Understanding the Status Page

FlowMattic Status Page The FlowMattic Status Page provides an overview of the cr

Setting up FlowMattic Connect for X ( Twitter ) integration

In this article, we will guide you through the process of setting up the FlowMat

Chat Icon Close Icon
Scroll to Top