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
Jun 11, 2021 10:47 AM
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?},"✅", "❗"))
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.
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?
Jun 11, 2021 11:12 AM
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.