Skip to main content

Hey AT Users.


Has anyone come across a good solution for either timestamping an updated element in a field or generating a timestamp for when a computed field contains a value vs when it is empty?


For context:

In our base there is a rich text field which includes a check list of about 10 items (done to eliminate the need of 10 separate fields, as there is already a LOT of data to process in this base).

Using the following formula I can only return a timestamp for when the entire field was modified, not the particular element in that field:

IF(FIND(" Milestone “,{Milestones Checklist}),DATETIME_FORMAT(SET_TIMEZONE(LAST_MODIFIED_TIME(), ‘America/Toronto’), ‘M/D/YYYY LT’,”"))

If anyone has a work around for either timestamping when each of the 10 elements is marked with an x OR knows a workaround for timestamping a computed field - then I could add an IF(FIND(" Milestone",{Milestones Checklist}),“Yes”,"") field and then timestamp WHEN that yes appears.


Any thoughts???

As far as I know, you would need to use a JavaScript or an Airtable Automation for this, because you’ll need to manually update a normal field (i.e. not a formula field) with the timestamp information.


So you would trigger the automation whenever the ">x] Milestone" is found, and to keep them all of the milestones separate from one another, you would likely need 10 separate automations — one for each milestone.


Perhaps someone else knows of an easier/cleaner way of doing this.

As far as I know, you would need to use a JavaScript or an Airtable Automation for this, because you’ll need to manually update a normal field (i.e. not a formula field) with the timestamp information.


So you would trigger the automation whenever the ">x] Milestone" is found, and to keep them all of the milestones separate from one another, you would likely need 10 separate automations — one for each milestone.


Perhaps someone else knows of an easier/cleaner way of doing this.


Thanks for the input!

I ended up building 10 separate automations base on a plain text summary of the milestones which then updated the designated date/time stamp field with the last updated time when the particular milestone is marked off.

Not 100% slick, but it works!

Reply


Terms & Conditions