It’s curious to me that the last mod time for any cell is not available through the scripting, REST, or metadata API as part of any records’ metadata.
For example, I would think that for Airtable to display the data in a last mod time field, especially comparatively when more than one field is specified in the config, the last mod time would need to be stored somewhere. Perhaps I am just thinking about it incorrectly.
That the cell values update accordingly when the last mod time field is reconfigured (e.g. a specific field has a date from months ago, but when the last mod time field is reconfigured to show all fields and something was updated today, it shows a date-time value from today) makes me think the data must be somewhere… just not accessible :man_shrugging:
Per the API doc on lastModifiedTime, the cells are read only and creating or updating such fields is unsupported.
Where or how does Airtable gets this data when a last mod time field is created and configured? I.e. where or how does Airtable get the data of any field’s last mod timestamp?
Context: I have a bunch of records to merge which all have been inconsistently updated. The table has close to 200 fields, about 50 of which are modifiable and in need of updating by comparison. I’d like to compare the last modified times per record, per field as the most recent mods are likely to be the most accurate. Is my only option to manually create last mod time fields for all 50 fields? If so, that seems kind of cray, but definitely not as craycray as the maintenance of this table’s records.
:grinning_face_with_sweat: