Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Update a Single Status based across multiple fields

Topic Labels: Automations
202 1
Showing results for 
Search instead for 
Did you mean: 

Hi all,

I currently use Airtable to do a series of date checks. I have about 15 of these per record, for various points along a user’s timeline:

IF(DATETIME_DIFF(TODAY(),{5d}, "days")>-1, IF({5d Email?},"✅", "❗"))

Screen Shot 2021-06-11 at 10.48.38 AM

I’m looking to be able to create a Kanban view where I can see any record that has a - indicating an outreach is needed - but this requires a single-status field in order to make this work.
Screen Shot 2021-06-11 at 10.44.32 AM

If I want to create a single-status field that automatically changes to “needs outreach” whenever there is a emoji in any field in the record, is that something that’s possible to check easily?

Is there another, more elegant solution I am missing? Or am I out of luck?

1 Reply 1

Hey Sterling. You could use an automation do accomplish this. Trigger on the “ :exclamation: ” (OR’d across multiple fields), and update the record as the action. You would want another automation to set the single select back to empty (or whatever) if the record gets all check marks.