I want to create a script, to add\change a specific value to a string field on my Account form from another string field on a different table.
On our Account form, we have a related list for Location (Account location). On the Account location form, we have a string field called 'country'. I want to take that value and add the 2-letter code for that country on another 'country' string field on our Account form. For example, if we have France as the country on our Account location on a specific Account, I'd like to add the 2-letter code for France (FR) to the country field on the Account record. I'd like to create the script so it looks specifically for France on the Account Location and add the 2-letter code (FR) to the other country field on the Account that country (France) is associated with.
Account table: customer_account
String field called 'country'
Account Location table: u_account_location
String field called 'country'
