Help

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

Automatic status update

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

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:

  1. When “support” is fill update status to complete
  2. When “support” is not fill update status as in progress.
  3. When the “due date” is reach and the “support” cell is blank mark as incomplete.

Thanks.

1 Reply 1

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

image

Does that do the trick?