Help

"HAS ALL OF" operator not working

Topic Labels: Automations
725 2
cancel
Showing results for 
Search instead for 
Did you mean: 
geetee
4 - Data Explorer
4 - Data Explorer

I am trying to have the checkbox (Status) marked check when OPT2 has all of OPT1 values.

OPT1 is fixed value, while OPT2 is user's input.

What is wrong with my automation here? am I using the "has all of" operator incorrectly?

Screenshot 2023-06-07 at 9.33.34 AM.png

Screenshot 2023-06-07 at 9.34.18 AM.png

2 Replies 2

Hi @geetee,

I would try the "when record matches condition" trigger. You might have to copy and paste all OPT 2 cells across all rows to activate the automation after it's turned on.

Hope that helps!
-Stephen

The "has all of" operator works best when you can hardcode the specific options from the dropdown. It doesn't work so well when you are using a dynamic condition because Airtable probably doesn't break down the options in the dynamic conditions as individual options.