Hy,
in a form application I have a field of type int called COLOR
User can select a combination of different colors choosen among RED,BLU,GREEN,ORANGE using a binary checkbox.
As far as I understand SC should save into the DB the binary integer corresponding to the selection.
For example:
RED —> 1 (binary 0001)
BLU —> 2 (binary 0010)
RED and BLU —> 3 (binary 0011)
RED and BLUE and GREEN —> 7 (0111)
and so on
but SC saves always 0 regardless the selection.
What is the size of your INT and what are you actually storing: e.g. for RED and BLUE, is it 3 or 0011 you are storing? If its INT and you store 3, there is no way you will have 0. Could you have interchanged them mistakenly in your manual lookup set up?
Sorry, had never used that but it sure seems like a bug to me: tested by setting a default value for the field. On form load, it shows the correct checkboxes ticked. But once you get into onValidate etc, the value becomes empty.
Just opened a ticket to the SC support. Let’s see what they say. To me it’s a bug too.