Formula column as the Primary Key for Linked Table - Not Auto Populating

Hi Guys,

I’m new to Airtable. I recently created a linked table where based on the code it will look up on the second table for a zone.

image

so Centre Country is a formula referring to Centre cut and then I made it as a link to the Zone table
Zone is the Value I return from the Zone table

It works if I manually type the data in the Centre Country but I want it to automatically refer to the Centre cut and then pull the zone number.

Every time a new value comes it doesn’t update. I know I can create an automation to update but is there a way to do without creating automation or using any integrations?

No, there isn’t really another means of doing this since linking records together is a manual process by nature. Your options are basically copy your Formula column over to your Link column, or have an automation do it for you. Setting up an automation for this would be fairly straightforward.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.