Choice field on a table showing duplicate values

srimanta sahoo1
Tera Contributor

HI 

I have a business application table and the field architecture type field showing duplicate values.

 

srimantasahoo1_0-1732805180971.png

Any idea why it is generating duplicate values and how to solve it. The duplicate value showing in Blue color.

There is no default value given for the choice field.

 

Thanks,

Srimant

 

 

12 REPLIES 12

Community Alums
Not applicable

Hi @srimanta sahoo1,

 

When you notice a value highlighted in blue, it indicates that the field was initially assigned a value and saved, but later that value might be deleted. The original choice value is then shown in blue. To resolve this issue, update the record with the correct value and save it. This will eliminate the duplicate blue value.

 

If you find this information helpful, please consider marking it as correct by selecting "Accept as Solution" and mark as "Helpful".

Regards,

Prudvi

Community Alums
Not applicable

Hi @srimanta sahoo1,

 

When you notice a value highlighted in blue, it indicates that the field was initially assigned a value, and that value might be deleted now. The deleted value is then shown in blue.To resolve this issue, update the record with the correct choice and save it. This action will eliminate the duplicate blue value.

 

If you find this information helpful, please consider marking it as correct by selecting "Accept as Solution" and mark as "Helpful".

 

Regards,

Prudvi

Bert_c1
Kilo Patron

Check the records here:

 

https:///<instance_name>.service-now.com/sys_choice_list.do?sysparm_query=GOTOelement%3Dplatform%5Ename%3Dcmdb_ci_business_app&sysparm_view= 

 

See if there are duplicates. Check client scripts for "g_form.addOption". See:

 

https://developer.servicenow.com/dev.do#!/reference/api/washingtondc/client/c_GlideFormAPI#r_GF-AddO...