@IsNotMember (Formula Language)

Syntax

@IsNotMember( textValue ; textListValue ) or @IsNotMember( textListValue1 ; textListValue2 )

Parameters

textValue

Text.

textListValue

Text list.

textListValue1

Text list.

textListValue2

Text list.

Return value

flag

Boolean

• Returns 1 (True) if the textValue is not contained in textListValue
• Returns 0 (False) if it is contained
• If both parameters are lists, returns 1 if all elements of textListValue1 are not contained in textListValue2

Usage

In processing lists, @IsNotMember differs from a simple != test. != returns True if the pair-wise comparison of two entities has no entities in common and False only if the pair-wise comparison of the two entities finds all pairs to be equal. @IsNotMember does not perform a pair-wise comparison, but tests each element in textListValue1against all the elements in the textListValue2 and returns False if it is equal to one of them.

@IsNotMember returns True only if no member of the first argument is contained in the second argument.

Examples

1. This example returns 0.

   @IsNotMember("computer";"printer":"computer":"monitor")

2. This example returns 1 if R&D is not in the list of values in the field name Department; returns 0 if R&D is in the list.

   @IsNotMember("R&D";Department) 

3. This example returns Marketing in the Dept field if the current user is not contained in the list in the SalesDepartment field; otherwise Sales is returned in the Dept field.

   FIELD Dept:=@If(@IsNotMember(@Username;SalesDepartment); "Marketing"; "Sales"); 

4. This example returns 1 if both the [WebTeam] and [ManageFiles] roles are assigned to the current user; it returns 0 if only one or neither of the roles is assigned to the user.

   @IsNotMember("[WebTeam]":"[ManageFiles]";@UserRoles)