Hello fellow sugarers !
I have a big weird issue with multiple choice dropdowns, the keys in the database are encapsulated within "^" characters
In admin, via the Studio, i create a new Multi choice Dropdown field under Accounts module, called list_test_c
Here are the key and the values i've set :
Keys | Values |
---|---|
choiceone | Choice One |
choicetwo | Choice Two |
choicethree | Choice Three |
choicefour | Choice Four |
Every thing is well displayed under studio.
So, this is well displayed under the account's record view, and i can select one or more choices for list_test_c.
For Record n°1, i've selected Choice One and Choice Two, so in my database, under accounts_cstm's field list_test_c, i assume i will see choiceone,choicetwo.
And for Record n°2, because i've selected only Choice Three, in my database, i will certainly see choicethree.
won't i ?
But Sugar decided not to do that. So in my database i have :
Record n° 1 => ^choiceone^,^choicetwo^
Record n°2 => ^choicethree^
Yes, the "^" caracter is added at the beginning and ending of each key.
Is that even normal ? It does that only for multi select fields, but not for normal dropdowns.
Do you have any clue on that matter ?
Thanks a lot.
Gaëlle