
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2021 09:11 AM
- Add a new
Link to Another Record
-type field named{Shipping Country} (link)
which will link to your[Countries]
table. - Convert your blank
{Shipping Country Full Name}
column into aLookup
-type field that looks at the[Countries]
table’s{Full Name}
column. - Set an Automation to trigger when
{Shipping Country}
is not blank. - Add an
Update record
action step to the Automation to copy the value from{Shipping Country}
into{Shipping Country (link)
.
