Contains

The Contains function will allow you to do new types of filters on text fields.

Last updated: Oct. 4, 2021

The best way to explain these is with an example. Suppose you have an Opportunity data source that looks like this:

contains.webp

Include text that contains a specific text value

You can use "Contains" to filter on a text field based on the content of the value, for example:

(
Count(Opportunities,Size=
Contains("qualified"))
)

This will return the number of all the opportunities that still need to be qualified. In our example, the returned number will be 2, because of the opportunities 2 and 4.

Include text that does not contain a specific text value

You can reverse the meaning of the filters by using "!=" instead of "=", for example:

(
Count(Opportunities,Size
!=Contains("Small"))
)

This will return the number of all opportunities not containing "Small" in their registration. In our example, the returned number will be 3, because there are three opportunities that do not contain the word "Small".

Case sensitivity: These functions are all case-sensitive. It means that it is important you match your data's UPPERCASE and lowercase letters exactly. 🤓

Was this article helpful?