Difference Between "Contains" and "Is In"

Support, Troubleshooting, & Help
1

Can’t find Knowledge Base article that differentiates between these two…

2

For contains, it returns all records that “Contains” the string you define.

For Is In, it returns all records that has a match in the list of strings you define.

For example, given a column called “Animals”:
ANIMALS

  1. Dog
  2. Cat
  3. Fish
  4. Turtle
  5. Bird
  6. Chicken
  7. Pig

ANIMALS contains “i” will return

  1. Fish
  2. Bird
  3. Chicken
  4. Pig

ANIMALS is in [“Chicken”, “Pig”, “Dog”, “Fis”] will return

  1. Dog
  2. Chicken
  3. Pig
    (“Fis” doesn’t exist in this list)

Contains checks for one substring within all records, Is In checks for one exact match between the records and the string list you provide.

Another way to look at it is Contains asks for one text to search. Is In asks for a list of texts to look for, but one of the user defined texts in the text list and the record field have match.

Currently, there does not exist a “Is Contained In”, which would hypothetically return all records that contain a text in the user defined text list.

2 Likes