Hi - I have a

custom record type

, which has a

field

of type list/record pointing to

Country

When I create a

saved search

for this

record type

, the country column returns full country names (e.g. "United States" Is there a way to have a column showing the

country code

(such as US) instead? FYI: if I use a formula with

country_field_name.id

, it will return an integer ID

You can do it in suiteQL. You could always create a case when statement is saved search do it. Just in case you need, the Below query will provide you the results.

SELECT 
cr.countryField,
c.id
FROM
customrecord AS cr
LEFT OUTER JOIN Country AS c ON cr.countryField = Country.uniquekey

Thanks - I needed it in a saved search I had to write a UE script for that Thanks though!

@Milcho Dimkov - In the Results field choose Formula (Text) CASE WHEN {custom_country_field} IN (‘United States’ )THEN ‘US’ WHEN {custom_country_field} IN (‘Canada’) THEN ‘CAN’ WHEN {custom_country_field} IN (‘Mexico’) THEN ‘MEX’ ELSE NULL END

yes, yes, of course... and this one I need to do only 256 times 😄 @Andrew Altringer

Wow! 😩