Choice field on a table showing duplicate values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2024 06:50 AM
HI
I have a business application table and the field architecture type field showing duplicate values.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2024 07:37 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2024 07:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2024 08:21 AM
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: