Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Apr 25, 2021 12:55 PM
I have a table that get’s updated with external date via zapier.
One of the columns it updates is called ‘Shipping Country’, it get’s updated with a two latter country code, there’s another empty column ‘Shipping Country - Full Name’.
I have a different table, on the same base that has 2 column and over 200 rows. of country code in the first column, and full country name in the second column.
I’d like that when a country gets populated in the ‘Shipping Country’ column, It triggers an action that populates the ‘Shipping Country - Full name’ column with the country’s full name, either using the country code table, or manually setting 200+ actions and triggers.
Regards,
Tomer
Apr 26, 2021 09:11 AM
Link to Another Record
-type field named {Shipping Country} (link)
which will link to your [Countries]
table.{Shipping Country Full Name}
column into a Lookup
-type field that looks at the [Countries]
table’s {Full Name}
column.{Shipping Country}
is not blank.Update record
action step to the Automation to copy the value from {Shipping Country}
into {Shipping Country (link)
.