+13I 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.
Best answer by Karl_at_Easy_La
Actually I had solved this quite neatly, using a simple Javascript script. It keeps the table clean, no extra fields added, or having to use a formula field with NOW() either. I never remembered to post a reply about it.
It involves adding a 'Run a script' step, with the below simple Javascript code:
var dt = new Date();
output.set('nowTimestamp', dt.toISOString());
Then, you can use the output value 'nowTimestamp', in any value.
I hoep
I hope this helps. If anyone wants any further clarifications, ask away.
+33The 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.
+3Hi 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,
+33Hi 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! 🙂
+3Or 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?
+33Yes, everything would depend on his particular workflow.
+12This one is still killing me years after running into a roadblock with it.
I have an automation that triggers when certain fields are updated. So I have a "Last Modified Time" field which is tracking those same fields. But over the years I have modified which fields trigger the automation.. and forgotten to simultaneously change the "Last Modified Time" configuration to match... And to make it worse, one of the fields that the automation is watching is a lookup. Which means I need three more fields to make this work: a "Last Modified Time" for the table that's being looked up, a lookup of that timestamp, and a formula field to combine the actual last modified time and the looked-up last modified time. What a mess.
All because you can't write the current time to a record. And because NOW() doesn't actually work.
Sorry, I'll stop complaining now!
+12Actually.. thinking about it again finally prompted a better solution.
In the above example, both "Update record" actions are updating the same record. But you need to break it into two separate actions so that the second can reference the first.
This is a much more robust solution than my previous mess, and does not rely on the dubious NOW() function.
+13Actually I had solved this quite neatly, using a simple Javascript script. It keeps the table clean, no extra fields added, or having to use a formula field with NOW() either. I never remembered to post a reply about it.
It involves adding a 'Run a script' step, with the below simple Javascript code:
var dt = new Date();
output.set('nowTimestamp', dt.toISOString());
Then, you can use the output value 'nowTimestamp', in any value.
I hoep
I hope this helps. If anyone wants any further clarifications, ask away.
+2Actually I had solved this quite neatly, using a simple Javascript script. It keeps the table clean, no extra fields added, or having to use a formula field with NOW() either. I never remembered to post a reply about it.
It involves adding a 'Run a script' step, with the below simple Javascript code:
var dt = new Date();
output.set('nowTimestamp', dt.toISOString());
Then, you can use the output value 'nowTimestamp', in any value.
I hoep
I hope this helps. If anyone wants any further clarifications, ask away.
@Karl_at_Easy_La - does the script solution slow down the Database? My use-case would require the script to run hundreds maybe thousands a day.
Thank you
+1Actually I had solved this quite neatly, using a simple Javascript script. It keeps the table clean, no extra fields added, or having to use a formula field with NOW() either. I never remembered to post a reply about it.
It involves adding a 'Run a script' step, with the below simple Javascript code:
var dt = new Date();
output.set('nowTimestamp', dt.toISOString());
Then, you can use the output value 'nowTimestamp', in any value.
I hoep
I hope this helps. If anyone wants any further clarifications, ask away.
Hello @Karl_at_Easy_La ,
Thank you for this, it is excellent and has saved me some time.
A couple of small questions on how to take this further:
1 - I need to do a similar action, where however the time stamp is 2 weeks from the date the action is carried out. Aka, when I trigger the action, I need a date to be set at 2 weeks from today, and remain statically as that date. How could the code by amended for this?
2 - I also need a similar action that only stamps the current year, how could the code by amended for this?
Thanks again.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
