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.

Usage:

NotContains( p1, p2[, p3…])

Parameters:

p1

The value to search for.

p2

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.

Example:

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

 

Keywords

Format Design Formula contain