Hey ​@Louieala!

Interesting question for sure. There is no way to get that done via Airtable basic automation blocks. However, you would be able to get that done via API calls -which means that you would need to (a) use scripts on your automation, or (ii) use external automation systems such as Zapier, Make, or n8n.

You can check Airtable’s documentation for creating comments via API here.

You can also read more about different automation systems here.

Hope this helps!
Mike, Consultant @ Automatic Nation

If you do end up using Make to do the API calls, you may hit an issue where it tells you you don’t have enough permissions or something.  Not too sure why that’s a thing, but when I was doing this I got around it by just creating a personal access token instead and that seemed to fix it

You’d use the ‘Make an API call’ module and here’s how it might look, with the URL format of /v0/{baseId}/{tableIdOrName}/{recordId}/comments

I wrote a guide on how to trigger a Make scenario via an Airtable button here that’ll get you 90% there, and ​@Pello provided a quick one liner script that you can use to do this via an automation here!