Creating automation based on multi-select field containing more than one value

[just_the_intern]

I am trying to create an automation that updates a record when certain conditions are met:

Let's say I am evaluating my retail inventory and want to identify inventory boxes requiring certain follow up tasks: I created a Box Flags field to aggregate a few different record fields into 2 flags: boxes that need to be replaced, and boxes that need their contents separated.

I have created an automation to update records for the first flag, but am struggling with the conditions for the second. 

I only want the "separate contents" flag on boxes with more than one field value. "Has any of" retrieves all boxes, "has all of" requires a tedious number of conditions to capture every combo of values, "is exactly" and "is/is not empty" don't apply. 

In other apps I've worked in, I could write a condition like Box Contents contains A,B,C,D,E AND (Box Contents is not equal to A OR Box Contents is not equal to B OR...) to filter out the single value records, but I can't seem to wrangle these Airtable operators.

Is my objective possible using conditions, or do I need to resort to script or some other means within AT functionality? I have a little SQL experience but that's the extent of my programming knowledge.

tyia!

[TheTimeSavingCo]

Hm, could you provide a screenshot that contains records with data setup where you do not want the automation to trigger for as well as records you do want it to trigger for?  Don't really understand what you're asking, sorry!

[ScottWorld]

@just_the_intern 

You have the ability to create complex conditions like that by using the "Filter" button back in your View.

So I would create your filtered view, and then trigger your automation based on "when a record enters that view".

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[just_the_intern]

I'll give this a try, thank you!!