I've created a checkbox field from a varchar field where the data is a 12 character string composed of 0 and 1 (1 = checked).First I've created the checkbox field with a multiple values (delimitor) as lookup, then change it to multiple values (position) as it was more appropriate for what I need to do. My problem is that now when I open the form, the field is showing the 12 checkbox correctly but when I submit the form, that field is stored wrongly in the mysql database. if all the checkbox are checked then the data in sql should be "111111111111" but instead it is stored as "1;1;1;1;1;1;" so when I open the form again instead of 12 checked box I have the odd box checked and the even box unchecked. Look like the form is showing the field as multiple value (position) but the data is stored as multiple value (deimitor) as it was the first choice I made when created the field lookup. Now there is no way to get rid of that. Remove the field form the form and redo it but still the same problem. Change the field to text field which work find (I was able to put back the "111111111111" but when I go back to checkbox field with multiple value (position) lookup I still have the "1;1;1;1;1;1;" when I submit the form. Any idea apreciated as I'm stuck in my development
No announcement yet.
Form field checkbox lookup multiple value (position) recorded wrong in sql database