How to format the items for a checkbox field ?
By loic on Wednesday, 25 June 2014
Posted in Technical Issues
Replies 5
Likes 0
Views 549
Votes 0
Hello,

i am creating custom field and i wonder :

1/ How do it's better to format the items for a checkbox field :
- Did the title and value can contain accentuated letters ? space ? other special characters
http://awesomescreenshot.com/08431gfa19
- To be well searchable, it's probably better to maintain space between words in values ??

2/ I have checked my database and found this :
http://awesomescreenshot.com/0b831g92b5
For one checkbox field the values are stored 2 differents ways in database :
In one case the values are separated by comma... in the other case not !!
is it possible ? what is the correct or better one for future use ??

Thanks in advance for you help

Loïc
Hi,

The old data is with comma, while the new data is with a space.

Regardless though, the raw column is only used for search index purposes and it won't affect the field as it is not used as "data" in the field. The raw column is expected to be deprecated in the upcoming 1.3 or 1.4.
Jason Rey
·
Thursday, 26 June 2014 12:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello loic,

You don't really need to format anything. You should just add the value as it is and our scripts would automatically add those spaces for you.
Mark
·
Wednesday, 25 June 2014 23:32
·
0 Likes
·
0 Votes
·
0 Comments
·
hello mark
thanks for your answer

can you have a look to question 2 and specially database screenshot :
http://awesomescreenshot.com/0b831g92b5
For one checkbox field the values are stored 2 differents ways in database :
In one case the values are separated by comma... in the other case not !!

this is due to beta or changes on firsts easysocial releases ??

anyway, i can correct it, i have some others clean up to do with my users datas (CB migration !)...

what is the correct way to format those data : with comma or space ??

thanks in advance
loïc
loic
·
Thursday, 26 June 2014 00:05
·
0 Likes
·
0 Votes
·
0 Comments
·
hello
thanks for information
loïc
loic
·
Wednesday, 02 July 2014 14:41
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome
Mark
·
Wednesday, 02 July 2014 23:35
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post