Formula result auto-links records?


I have a Project Number field (“PROD#”). Next to it I have a formula which extracts just the “Series Code” (ie. just the text portion). This code corresponds to a Primary field in another table. To link the records by this value, I have to copy the resulting “Series Code” from the formula field and paste it into the linked records field. Is there any way to automate this so that the record automatically links based on the “Series Code” result?



I don’t think there’s anyway to do that with vanilla Airtable, but an automation service like Zapier can do it for you - at a cost.