Help

Automation - Update record, and save date field with NOW() timestamp

Topic Labels: Automations
880 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Karl_at_Easy_La
6 - Interface Innovator
6 - Interface Innovator

I would like to update a date field in a record, with the last time the automation executed. Is this possible in an automation, in the Update Record Action?

If you choose static, you have to enter the field manually. If you choose a dynamic value, you are only allowed to choose from an existing field or data.

 

Karl_at_Easy_La_0-1691571404829.png

 

5 Replies 5

The only way to do this with Airtable’s native automations is to create a formula field in your database with the NOW() formula. Then, in your update record action, you would insert that formula field into the field that you want to update.

p.s. Note that if you have a large base, the NOW() formula can slow down a base. Other workarounds for this issue include writing your own custom JavaScript, or using Make which offers its own internal NOW function.

cesrua1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Karl,

Another workaround to Scott suggestion is instead a formula field with now formula, to create a Last Modified time field and insert the value of this field in the automation.

Kind regards, 

Or just create a last modified time field with no automation at all! 🙂

That works if he doesn't update the record though other processes right?

Yes, everything would depend on his particular workflow.