Automatic status update

[Miguel_Manga]

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.

[Databaser]

Hi @Miguel_Manga and welcome to the community!

Yes, those triggers are possible in Airtable’s automation (paid account is needed).

Miguel_Manga:

• When “support” is fill update status to complete

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

Miguel_Manga:

• When “support” is not fill update status as in progress.

Same, but trigger is “where ‘support’ is empty” and leave input under “status” field empty

Miguel_Manga:

1. When the “due date” is reach and the “support” cell is blank mark as incomplete.

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?