Complexity with Choice field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2024 09:43 PM - edited 10-16-2024 12:37 AM
Hi All,
I had a string field before having values in some fields and other records are empty but I converted it to a choice field through dictionary . Wrote a back ground script to populate existing value of string field on an another field when a user selects others from the choice field. But when I moved the changes to QA and UAT, it is showing a few extra choices which are not added by me . I can hide or inactive those choices but my question is if the field was a string field before so from where can the choices come from and how ? Is there any development issue or something else and what can be the best solution to be provided with that unnecessary choices should not visible.
Please feel free to ask any question regarding this or if you want any more info/clarification .
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2024 10:00 PM
Hi,
It appears that the existing values in the string field were not cleaned up properly, which is why they remain and are now appearing in the choice list.
Thanks,
Dhruv

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2024 10:08 PM
As Dhruv correctly noted, the clean-up script didn't clear the value as expected. What options do you currently see in the choice field? Are there any special characters or blank values? Could you also check the temporary field you used to transfer the existing string data to see if it contains the necessary data? Additionally, what was the volume of records involved in this process?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2024 11:26 PM
Options like TBD, NA, Attached that contains only letter but a few choices contain special character. Yes there is a string field to transfer the existing string data. Actually when user selects others from choice field the string field will be visible and display the existing string data . Above 16k records involved in this process. But Recently I saw my previous development is also not working on 73 records in QA and on 7 records in Test . This issue I had also faced in DEV but I used setWorkflow(false) to resolve and it was working fine. But in QA and Test, the issue is still there after moving the development.