List field getting cut off and showing sys_id's

[brostoff17]

I have a list field on table I created that references records on another table.

When I try and pick choices on the list field and save the record, it only saves one of my choices and then cuts off the rest, only leaving a few alphanumeric characters.   There are no business rules that are causing this.   Anyone have any ideas?

[Chuck Tomasi]

Hi Josh,

Can you provide some additional details?

Q: What table is the field Target Audience pointing to?

Q: What does the list look like when it's expanded? This might help determine if it's an ACL issue, missing record, etc.

Q: Can you send along an image with a little more context (e.g. more screen region around that field)?

Thanks.

[Pradeep Sharma]

Hello Josh,

I had the same issue in the past when I was working on one of the application. The issue was resolved when the field was deleted and created again.

Please try the same if this option works for you.

[Chuck Tomasi · Accepted solution]

Keep in mind that deleting the field will cause the loss of all data in the record. If you have any records that working properly (e.g. one person listed) you may want to save the field data first, or create a new field and copy over the values from the old one before deleting it.

What Pradeep said makes sense now that I look at it. It appears to be truncating around 40 characters, which is the default length of the string field and that's 1 (32 character) sys_id, a comma, and seven more characters - which is what we see. I've had an issue in the past with other fields types defaulting to 40.

You might be able to go in to the dictionary entry for that field (or add the Max Length field to your dictionary list) and change it to 1000 instead.

[brostoff17]

Thanks Chuck!