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.