Hi Thomas,
There are specific constraint operators that need to be used for single vs list values:
Element vs Element
Let’s say a User’s Name = Thomas and the input’s value = Thomas Jones
Name = Input’s value > would not return the record because it’s not an exact match
Name is in Input’s value > would return the record because the word “Thomas” is in the value “Thomas Jones”
Element vs List
Let’s say a User’s Name = Thomas and a custom state (list)'s value = Adam, Mary, Thomas
Name = Custom state > would not return the record because the Name field is a single value and is incompatible with a list value
Name is in Custom state > would return the record because “Thomas” is in the list “Adam, Mary, Thomas”
Advanced: Custom State contains This User’s Name > would also return the record because the state list contains the single value
List vs List
Let’s say a User’s Friends list is “Adam, Mary, Thomas” and a custom state (list)'s value = “Adam, Sam, Julie”
Friends List contains custom state list > would not return a record because it’s incompatible
Advanced: This User’s Friend’s List intersects with custom state’s value :count > 0 > would return a value if there is at least 1 overlapping item in the two lists
So, remember:
“Contains” should be used for List value contains single value or Text string contains word
“Contains list” should be used for List value contains (an entire) separate list value
“Is In” should be used for Single value is found in a list value
“Isn’t In” should be used for Single value is not found in a list value
" = " should be used for exact matches
“Intersects with” should be used to see if two list values overlap
Hope this helps clear things up!
Gaby at Coaching No Code Apps (formerly Coaching Bubble)
Courses & Products, Tutorials, Private Coaching, and High-level Development
