ShowMoreInformationShowMoreInformation

Shows a text box only if the switch field named ShowMoreInformation is toggled to its "on" position.

!Field1.Valid!Field1,Valid

Shows a text box only if Field1 is invalid, that is, if its Valid property returns FALSE. If the text box appears just below the field, it can contain tips for entering correct values.

ISODD(Field1) && (Field2 < 3)ISODD(Field1) && (Field2 < 3)

Shows a text box only if Field1.ValueField1,Value is odd and Field2.ValueField2,Value is less than 3.

!AND((Field1:Field50).Valid)!AND((Field1:Field50),Valid)

Shows a text box if a single field of the Field1:Field50Field1:Field50 range is invalid (as determined by the Valid property of the fields). This range includes the two fields Field1 and Field50 and all fields that appear between them.

The formula (Field1:Field50).Valid(Field1:Field50),Valid returns a logical array with the same number of elements as there are fields in the Field1:Field50Field1:Field50 range, like this array: { TRUE, FALSE, TRUE, TRUE, ...}{ TRUE; FALSE; TRUE; TRUE; ...}. The AND function returns TRUE only if all elements of the array are TRUE.

Finally, the ! operator negates the returned logical value from AND, thereby turning FALSE into TRUE and TRUE into FALSE. The end result is that the text box is shown if a single field of the given range is invalid.

!AND(ISDEFINED(Field1:Field50))!AND(ISDEFINED(Field1:Field50))

Shows a text box if a single field of the Field1:Field50Field1:Field50 range is not filled out (that is, has a value which is blank). This range includes the two fields Field1 and Field50 and all fields that appear between them.

The formula ISDEFINED(Field1:Field50)ISDEFINED(Field1:Field50) returns a logical array with the same number of elements as there are fields in the Field1:Field50Field1:Field50 range, like this array: { TRUE, FALSE, TRUE, TRUE, ...}{ TRUE; FALSE; TRUE; TRUE; ...}. The AND function returns TRUE only if all elements of the array are TRUE.

Finally, the ! operator negates the returned logical value from AND, thereby turning FALSE into TRUE and TRUE into FALSE. The end result is that the text box is shown if a single field of the given range is not filled out.

ENDSWITH(App.UserEmailAddress, "@example.com")ENDSWITH(App,UserEmailAddress; "@example.com")

Shows a text box only if the signed-in user has an email address that ends with "example.com". (To enable users to sign in, make your app private.)

USERHASTAG("Employee")USERHASTAG("Employee")

Shows a text box only if the signed-in user is associated with the tag "Employee". (To enable users to sign in, make your app private.)