How To Convert a multiple choice field to a choice field.

Did you make a mistake in designing your database and used a multiple choice field when it was supposed to be a choice field? With this trick you can convert the multiple choice field to a choice field without having to lose any data.

First you need to create a TEXT-field and name it Temp. You can hide it with Diplay field only, if: null so your Form-design won't even change.

Second put this code in the 'trigger after update' of your multiple choice field:

let i := numbers('Multiple choice as a choice field');
let s := 0;
for p in range(0, cnt(i)) do
s := s + item(i, p)
end;
'Multiple choice as a choice field' := s - number(Temp);
Temp := concat(numbers('Multiple choice as a choice field'))

DONE !

Steven