- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-20-2024 08:22 AM - edited ‎03-20-2024 08:23 AM
I have an odd situation... I added a field to our Conflict of Interest table with a type of Choice. Initially I set the underlying values to numbers with text labels, but later updated the numbers to text so the values and labels for each choice match (just makes it easier for me when coding).
So I then used a Fix Script to update the historical records. They were just test records but there weren't many so I figured I'd just update them to the new value so there were no future flow issues during testing. However, after I ran the fix script, I noticed one of my choices was truncated by 1 character. I assumed it was a Max Length issue (only 10 letters remained) but I can't find where to update it. When I go to Configure Dictionary for the field, then select one of the Choices, the value has a Max Length of 4000 and the Label has a Max Length of 100. What am I doing wrong?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-20-2024 10:19 AM
Interestingly, when you create a new Choice Type field, the Max Length field displays and allows you to enter a value. I have no idea why I would've put 10 at the time, but apparently I did. I was able to update it using script back to 40, which is the default and max for Choice type fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-20-2024 08:42 AM
Hi @Amy V2 ,
It is not recommended to modify choice field length. Please refer to below thread:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0726986
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0812548
If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!
Thanks & Regards,
Sumanth Meda
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-20-2024 08:57 AM - edited ‎03-20-2024 08:58 AM
I'm not sure you understand... Per your own linked article, I should be able to have choices with a length up to 40.
But in my table, the column is truncating the choice to 10 characters. See the COI Risk Level field in the background behind the Show u_coi_risk_level info box, showing Max Length of 10. Why is this happening?
Here are the choices in the Dictionary, with Medium Risk not being truncated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-20-2024 10:19 AM
Interestingly, when you create a new Choice Type field, the Max Length field displays and allows you to enter a value. I have no idea why I would've put 10 at the time, but apparently I did. I was able to update it using script back to 40, which is the default and max for Choice type fields.