CONTAINS Function: Determine If a Field Contains an Exact Match for a Specified Character String

Article Number:040506

The CONTAINS function returns TRUE if a specified field contains an exact match for a specified character string, and returns FALSE if it does not.
The CONTAINS function can be used to determine the following conditions.

  • If a specified option is selected for a "Check box" or "Multi-choice" field
  • If a field in a table contains a value that exactly matches a specified character string

The evaluation of a CONTAINS function can also be used together with the IF function.

CONTAINS function syntax

The content has been copied.
CONTAINS(field_code, "search string")

Both the "field_code" and "search string" arguments need to be specified.

For the "field_code" argument, specify the field code of the field to be searched.
You can specify the following fields.

  • "Check box" fields
  • "Multi-choice" fields
  • Fields in tables:
    • "Text" fields
    • "Radio button" fields
    • "Drop-down" fields
    • "Lookup" fields (If a field of the "string" data type is set as the Key Field)

If you set a formula with the CONTAINS function for a field in a table, the following fields can be specified as the argument.

  • "Check box" fields in the same table
  • "Multi-choice" fields in the same table

For the "search string" argument, specify the character string you want to search for enclosed in double quotation marks (""). If a value that exactly matches the character string specified as the "search string" is found, the function returns TRUE.

Formula examples

When specifying a field in a formula, make sure to specify the field code as the argument (and not the field name).
In the examples below, the field code is set for each field as the field name with underscores instead of spaces (e.g., the field code for the "Check box" field is "Check_box").

Formula to display "Checked" if the "Completed" checkbox is selected

The following formula displays "Checked" if the "Completed" checkbox is selected for the "Check box" field, and "Unchecked" if it is not selected.

The content has been copied.
IF(CONTAINS(Check_box, "Completed"),"Checked","Unchecked")

Screenshot: "Checked" is automatically displayed because the "Completed" checkbox is selected for the "Check box" field

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.

Formula to display "Working on Sundays" if the "Sunday" checkbox is selected

The following formula displays "Working on Sundays" if the "Sunday" checkbox is selected for the "Workdays" field, and "Not Working on Sundays" if it is not.

The content has been copied.
IF(CONTAINS(Workdays, "Sunday"), "Working on Sundays", "Not Working on Sundays")

Screenshot: "Working on Sundays" is automatically displayed because the "Sunday" checkbox is selected for the "Workdays" field

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.

Formula to display "Working on Weekends" if the "Saturday" or "Sunday" checkbox is selected

The following formula displays "Working on Weekends" if either the "Saturday" or "Sunday" checkbox is selected for the "Workdays" field.
The OR function is used to combine conditions.
AND, OR, and NOT Functions: Combine Conditions

The content has been copied.
IF(OR(CONTAINS(Workdays, "Saturday"),CONTAINS(Workdays, "Sunday")), "Working on Weekends", "")

Screenshot: "Working on Weekends" is automatically displayed because the "Saturday" checkbox is selected for the "Workdays" field

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.

Formula to display a different cost depending on whether a checkbox is selected

The following formula displays a different lodging cost depending on whether the checkbox in the "Lodging Option" field is selected.

If the "Breakfast Included" checkbox is selected for the "Lodging Option" field, the lodging cost is displayed as $95, which is the cost of breakfast ($15) added to the regular lodging cost ($80). If the checkbox is not selected, the lodging cost is displayed as $80.

The content has been copied.
80+IF(CONTAINS(Lodging_Option, "Breakfast Included"), 15, 0)

Screenshot: A lodging cost that includes the cost of breakfast is automatically displayed because the "Breakfast Included" checkbox is selected for the "Lodging Option" field

Formula to display "Completed" when all of a field's checkboxes are selected

The following formula displays "Completed" in the "Inspection status" field when all of the checkboxes (A, B, and C) are selected for the "Check" field.
The AND function is used to combine conditions.
AND, OR, and NOT Functions: Combine Conditions

The content has been copied.
IF(AND(CONTAINS(Check, "A"),CONTAINS(Check, "B"),CONTAINS(Check, "C")),"Completed","")

Screenshot: "Completed" is automatically displayed in the "Inspection status" field because all of the checkboxes (A, B, and C) are selected for the "Check" field

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.

Formula to display "Not Completed" if not all of a field's checkboxes have been selected

The following formula displays "Not Completed" in the "Inspection status" field when any one of the checkboxes (A, B, and C) is not selected for the "Check" field.
The OR function is used to combine conditions. AND, OR, and NOT Functions: Combine Conditions

The content has been copied.
IF(OR(CONTAINS(Check, "A"),CONTAINS(Check, "B"),CONTAINS(Check, "C")),"","Not Completed")

Screenshot: "Not Completed" is automatically displayed because not all of the checkboxes (A, B, and C) have been selected for the "Check" field

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.

Formula to display "Urgent order" if "Urgent" is entered in a table

The following formula displays "Urgent order" in the "Order priority" field if "Urgent" is entered in the "Priority" field of a table, and "Normal" if it is not.

The content has been copied.
Formula: IF(CONTAINS(Priority, "Urgent"), "Urgent order", "Normal")

Screenshot: "Urgent order" is automatically displayed because "Urgent" is entered in a row of the "Priority" field in a table

The formula in this example needs to be set for a "Text" field. Place a "Text" field on the app form, select Calculate automatically in the field settings, then enter the formula.
If a value of the "Priority" field is an exact match for the character string "Urgent", "Urgent order" is displayed.