Skip to main content

Automatic status update

  • January 20, 2021
  • 1 reply
  • 25 views
M

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

Databaser
Forum|alt.badge.img+25
  • Databaser
  • Brainy
  • January 20, 2021

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?

Jan - Databaser
Terms & ConditionsAccessibility statement