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!