How to display country name instead of country code in country field?

mipalm
Tera Guru

Hi, 

i have a field for nationality, from the table core_country, however when selecting an option in the form, the value given is the country code and not the country name. how can i make it so the country name is displayed instead?

mipalm_0-1705660599757.png

Thanks in advance

1 ACCEPTED SOLUTION

Hi Mipalm,

 

PFB image for more details about the country field.

 

Pankakkumar_0-1705661274642.png

 

 

Thanks,

 

Pankaj Kumar

 

Please mark this response as correct or helpful if it assisted you with your question.

View solution in original post

6 REPLIES 6

PrashantLearnIT
Giga Sage

What data type have you used?

********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************

Hi, the Nationality field is a reference to the table core_country

mipalm_0-1705661141649.png

 

Pankaj kr
Kilo Sage

Hi Mipalm,

 

You need to set display value of country to true in the core_country table. then it will start appearing in the list instead of country code.

 

path to set the display value: go to application navigator> core_country.config> column> locate country field and set the display field check and save it.

 

Thanks,

 

Pankaj Kumar

 

Please mark this response as correct or helpful if it assisted you with your question.

Hi Mipalm,

 

PFB image for more details about the country field.

 

Pankakkumar_0-1705661274642.png

 

 

Thanks,

 

Pankaj Kumar

 

Please mark this response as correct or helpful if it assisted you with your question.