Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 20, 2021 08:52 AM
Hi,
I was wondering, if it is possible to automatic update status field. I got a base with a cell call “support” and another cell call “due date”, and i want that the status cell updates according with these conditions:
Thanks.
Jan 20, 2021 09:53 AM
Hi @Miguel_Manga and welcome to the community!
Yes, those triggers are possible in Airtable’s automation (paid account is needed).
Trigger: “when a record matches conditions” > "where ‘support’ is not empty (I’m presuming this is a checkbox field)
Action: “update record” > select “status” field and input “checked” so the checkmark is added
Same, but trigger is “where ‘support’ is empty” and leave input under “status” field empty
Trigger: “when a record matches conditions” > "where ‘Today’ (=> create a formula field, eg, “Today”, with IF({due date}=TODAY(),"deadline"
as a formula) is ‘deadline’ "
AND
“where ‘support’ is empty”
Action: “update record” > select “status” field and leave input under “status” field empty
Does that do the trick?