Skip to main content

Hi all,

I am in the process of building an archive base to transfer records to in order to keep our operations base within its record limit. I have set up a basic 1-way sync that does not delete records in the archive base when deleted in the main base.

Can I consider record comments to be lost? Or does anyone know a way to copy them to a text field?

thx

Hey ​@Mark_Newton,

You can absolutely get comments. However, on such call you need to pass the very specific record id.

You can check List Comments from the Airtable API documentation.

If you need any help setting this up, please feel free to reach out. I’d be happy to help.

Mike, Consultant @ Automatic Nation 
YouTube Channel

Thanks Mike this is helpful. I think I can get this going, I have a working API script set up in my archive base.

Sounds great!

For any future reader, do note that there is no need to actually work with scripting if you do not feel comfortable doing so. You can make specific and simple API calls using HTTP Request modules/nodes on no-code automation tools such as Make or n8n (more on these here :D).

Kind of off-topic: ​@Mark_Newton. Usually I try not to rely on Airtable native comments feature, as it lacks specific granular data, you cannot trigger automations from such comments, and other reasons. What I many times use instead, is create a “Comments” table, that will be linked to any tables/records as needed. In such way you can capture very specific information e.g. specific date (rather than “7 days ago”), trigger automations when a comment is created or when a comment matches certain conditions, include tags for the comments (single select), so on and so forth. Just putting this out there :D

Mike, Consultant @ Automatic Nation 
YouTube Channel

Terms & Conditions