It's anyway to save true or false value in differents columns of database but in one unique checkboxfield?

Question

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!

stefanhelzle0001 · Accepted Answer

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" )
      ),
    },
  )
)

Sign up

Login with SSO

Login to the community

Login with SSO