How to format reference field values on form, 1st letter in caps, remaining small

[Nikhil80]

Hello community, I need help:

I have reference variable which is referenced to core_country.

the values here are not formatted, some are fully capitalized and some fully small letters.
the values on the table cant be changed because its coming from user records.
So, on form can values be shown in formatted manner?

[Sandeep Rajput]

@Nikhil80 I doubt if you will be able to change this without making the changes on the table being referenced in the reference field. Another option could be to add an additional field (Country Name) on the form on which the value would be set via an onChange script. This onChange script will run on the country field and will set the value on the Country Name, and you can apply string transformation e.g. toUpperCase()/toLowerCase() to format the country name.

[Nikhil80]

@Sandeep Rajput If I create new field how can I use it for this field as it is reference field. Only 1 reference field should be visible to user on portal.

[Sandeep Rajput]

@Nikhil80 Creating another filed would be a temporary solution, I recommend you to run a fix script to fix all the country names once it for all as the similar issues would arise in other cases too and adding new fields would not be an optimal solution in all the cases.

[Dr Atul G- LNG]

Hi @Nikhil80 

No, it is not direct possible, bcz at last data is coming from one source only. So need to update the table where this data is stored. or use the script told by expert @Sandeep Rajput