Applies to Infiniti v8.1 or later


NotContains() determines whether none of the values retrieved from a repeating section, page or data source matches a specified value. Note that the value must be an exact match, although it is not case sensitive. This is the opposite of the Contains() function.

Returns 1 if no values match or 0 if any values match.


NotContains( p1, p2[, p3…])



The value to search for.


Reference to a question within a repeating page, repeating section or multiple row data source.

[p3 …]

Optional additional references to extend the data set being matched.


The example below returns true or false values based on whether the value ‘inactive’ is found in the ‘Account’ field from a multi row data source question.

notcontains("inactive", [Q5.account])

Related Articles

Document Format

Contains and NotContains functions

Infiniti Design Functions



Format Design Formula contain