Help

Re: Set Created Time and Modified Time from imported fields

Solved
Jump to Solution
1026 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Edward_Brey
4 - Data Explorer
4 - Data Explorer

Is there a way to initialize fields of type Created Time and Modified Time from existing records of an imported sheet? That way, those fields will be correct for imported records and will be automatically updated as we add and edit subsequent records.

1 Solution

Accepted Solutions

A workaround I used was to hide the imported columns with the original timestamps and use a formula to combine the imported timestamps with Airtable generated timestamps for new records:

IF(TimeFieldFromImport=BLANK(),CREATED_TIME(),TimeFieldFromImport)

See Solution in Thread

3 Replies 3

Yes, just add the created time and last modified time field types to your table.

The {Created time} and {Last modified time} fields are automatically calculated. They cannot be directly set at all. When you import a sheet, they will be set to the time of import, because that will be when they are created/modified.

Do you want to set the {Created time} and {Last modified time} values to something prior to the time of import? If so, I’m afraid that is not possible. The best you could do is create new date/time fields for the imported values and then use formula fields. But it would very ugly and could create other headaches later on.

A workaround I used was to hide the imported columns with the original timestamps and use a formula to combine the imported timestamps with Airtable generated timestamps for new records:

IF(TimeFieldFromImport=BLANK(),CREATED_TIME(),TimeFieldFromImport)