Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
New Member
Posts: 15
Registered: ‎02-08-2011

Picklists with multiselect options are getting lost

[ Edited ]

Various pick lists (like Interests, Cuisine in Prefs Contact> Details)
are created as varchar fields. For pick lists with multi selected options are saved as comma separated text in varchar field. If the entry is too large, it is truncated when saving, selections may be lost.

 

Thanks slxuser2

 

SalesLogix WebClient 7.5.3

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Picklists with multiselect options are getting lost

Correct.... You would need to make the field longer in the db or just not use "multi-select"

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html