Hi @laura_jones and welcome to the community!
It can’t be done via the standard action options in Airtable, but maybe via scripting, Zapier, Integromat, … I’m not an expert on that, so let’s hope someone else will be able to point you in the right direction.