Hi,
my trouble here is that I don't know how can I save true or false in differents boolean columns in my database. I tried something like that:
a!checkboxField( label: "", labelPosition: "ABOVE", choiceLabels: { "Limpieza","Plaga","Manipulador" }, choiceValues: { "Limpieza","Plaga","Manipulador" }, value: {if(isnull(fv!item.inLimpieza),{},"Limpieza"),if(isnull(fv!item.inPlaga),{},"Plaga"),if(isnull(fv!item.inManipulacion),{},"Manipulador")}, saveInto:{ a!save( fv!item.inLimpieza, if(contains( save!value, "Limpieza" ), true,false) ), a!save( fv!item.inPlaga, if(contains( save!value, "Plaga" ), true, false) ), a!save( fv!item.inManipulacion, if(contains( save!value, "Manipulador" ), true, false) ), }, disabled: ri!readOnly, validations: {} ),
But It's not wortking correctly.
Actually, I have every data of every column in differents checkbox, but I would like to group all my checkbox in only one. Thanks for your help!
Discussion posts and replies are publicly visible
The issue you had is that you wrote true/false to the booleans, but checked for null in the value parameter. Make sure to prefill the boolean fields properly. A null-boolean is always a troublesome value. Made this working:
a!localVariables( local!item: a!map( inLimpieza: false, inPlaga: false, inManipulacion: false ), a!checkboxField( choiceLabels: { "Limpieza","Plaga","Manipulador" }, choiceValues: { "Limpieza","Plaga","Manipulador" }, value: { if(local!item.inLimpieza, "Limpieza", {}), if(local!item.inPlaga, "Plaga", {}), if(local!item.inManipulacion, "Manipulador", {}) }, saveInto:{ a!save( target: local!item.inLimpieza, value: contains( save!value, "Limpieza" ) ), a!save( target: local!item.inPlaga, value: contains( save!value, "Plaga" ) ), a!save( target: local!item.inManipulacion, value: contains( save!value, "Manipulador" ) ), }, ) )
Thanks for your help. It's fixed!