Automatic status update

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.

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?