Welcome to the Airtable community!

This can be done with a script.

Would you mind sharing how to do that?

if you know how to write code, the scripting documentation explains the Airtable specific concepts.

If you do not know how to write code, but are interested in learning, this is a good project to try once you know some of the basics of JavaScript.

If you do not write code and are not interested in learning how to code, you can try to find someone to write the script for you. There are several people on these forums who write scripts for hire, including myself. This would be a fairly easy script for someone experience at writing Airtable scripts.

Or for anyone else that’s interested, just use this: Apps - Airtable Marketplace

Ooh thanks for posting. There are so many apps that it is hard to remember them all.