Case for Record Revision History API

[Jeremy_Oglesby]

@Kasra - In reference to this, from the AMA session

AMA Custom Blocks Contest Edition #1 - Getting Started with the Airtable Product Team (Live on Wedne...

There isn’t an API for getting this information at the moment, but I’ll note your +1 for it! Out of curiosity, what are you hoping to build with it?

One thing I could imagine being potentially useful is a Custom Block that can stream updates to particular records or a particular table, along with the source of those updates - it could provide a useful place to keep an eye on changes to critical records/tables within a base while working in a different part of the base.

I think opening up an API to record revision history in the SDK could be potentially useful for that kind of thing.

[Jeremy_Oglesby · Accepted solution]

Launched: created by and last modified by fields Announcements

Hello again! Two new field types are now available to everyone today: Created by field [created by] The new created by field displays the name of the collaborator who created a record. A couple of notes: Since the person who created a given record will always be the same, there is no way to directly edit the contents of a created by field. Records created prior to the time when the created by field was enabled (June 2020) will have blank values in a created by field. Records created using a…

This probably addresses, or comes very close to addressing this use-case.

[Mingi_Ryu]

Thank you for addressing this use case. I think it’ll be very helpful for creating Blocks application for collaboration. Since Airtable already has revision history, the challenge would be in designing Blocks API for revealing these effectively.

As for the created by last modified by fields, is it available via Blocks APIs? Also, is it just the collaborator data or does it also have a timestamp like the revision history.

Thanks!

[Michelle_Valent]

Hi @Mingi_Ryu :wave: Yes, these are both available via the Blocks SDK. You can review it in the blocks documentation, where there is also last_modified_time that could be of interest.