Multiple Checkboxes in Editable Grid

Hi Narmada,

Follow the below link, It may help your requirement.
docs.appian.com/.../recipe_use_selection_for_bulk_actions_in_an_inline_editable_grid.html

Regards,
Krishna

Hi,

You can save multiple value in single type variable, here fv!item.ManufacturingSteps is single type variable.

you can join the checkbox values with some special characters,

Note: the data type should be TEXT

try the below code.

a!checkboxField(
label: "Manufacturing Steps" & fv!index,
choiceLayout: "COMPACT",
choiceLabels: cons!DFC_Sites,
choiceValues: cons!DFC_Sites,
value:if(
       isnull(fv!item.ManufacturingSteps),
        null,
        touniformstring( split(fv!item.ManufacturingSteps,"#") )
      ),
saveInto: {

  a!save(
    fv!item.ManufacturingSteps,
     if(
        isnull(save!value),
          null,
          joinarray(save!value,"#")
      )

    )

 }
)

Thanks

Vinay

Hi Narmada,

See the following working code. Specifically note line 60: "value: tostring(fv!item.ManufacturingSteps),"

When the fv!item.ManufacturingSteps is of Any Type, the checkbox will not remain checked. You will need to make sure your value field's type matches the checkBoxField's choiceValue type. 

Let me know if that helps! If it doesn't - please provide similar values to your constants to ensure we can replicate your issue. 

load(
  local!data: {},
  local!items: {
    {
      SiteName: "",
      SiteCountry: "",
      ManufacturingSteps: ""
    }
  },
  with(
    /*local!mfgsite: rule!CMP_qryMfgSitedetails(),*/
    /*local!mfgcountry: rule!CMP_qryCountryDetails(*/
      /*countryode: 1*/
    /*),*/
    a!sectionLayout(
      label: "Supply Chain Details",
      /*isCollapsible: "True",*/
      isInitiallyCollapsed: "True",
      divider: "BELOW",
      contents: {
        a!gridLayout(
          label: "Site Information",
          headerCells: {
            a!gridLayoutHeaderCell(
              label: "Site Name"
            ),
            a!gridLayoutHeaderCell(
              label: "Site Country"
            ),
            a!gridLayoutHeaderCell(
              label: "Manufacturing Steps"
            )
          },
          rows: {
            a!forEach(
              items: local!items,
              expression: a!gridRowLayout(
                contents: {
                  a!dropdownField(
                    label: "SiteName" & fv!index,
                    choiceLabels: {"MAN NAME1","MAN NAME2"},
                    choiceValues: {"MAN NAME1","MAN NAME2"},
                    placeholderLabel: "--Select Site--",
                    value: fv!item.SiteName,
                    saveInto: fv!item.SiteName
                  ),
                  a!dropdownField(
                    label: "SiteCountry" & fv!index,
                    choiceLabels: {"COUNTRY NAME1","COUNTRY NAME2"},
                    choiceValues: {"COUNTRY NAME1","COUNTRY NAME2"},
                    placeholderLabel: "--Select Country--",
                    value: fv!item.SiteCountry,
                    saveInto: fv!item.SiteCountry
                  ),
                  a!checkboxField(
                    label: "Manufacturing Steps" & fv!index,
                    choiceLayout: "COMPACT",
                    choiceLabels: {"Y"},
                    choiceValues: {"Y"},
                    value: tostring(fv!item.ManufacturingSteps),
                    saveInto: fv!item.ManufacturingSteps
                  )
                }
              )
            )
          },
          addRowLink: a!dynamicLink(
            label: "Add site",
            value: {
              SiteName: "",
              SiteCountry: "",
              ManufacturingSteps: ""
            },
            saveInto: a!save(
              local!items,
              append(
                local!items,
                save!value
              )
            )
          ),
          shadeAlternateRows: true
        ),
        a!textField(
          readOnly: true,
          /*value: local!items.ManufacturingSteps*/
          value: typename(typeof(local!items[1].ManufacturingSteps))
        ),
        a!buttonLayout(
          primaryButtons: a!buttonWidgetSubmit(
            label: "Submit",
            style: "PRIMARY",
            confirmHeader: "Warning!",
            confirmMessage: "Steps will be added to the Database.
Please Click Yes to Proceed",
            saveInto: a!writeToDataStoreEntity()
          )
        )
      }
    )
  )
)

Hi Narmada (narmadap) ,

Your code looks fine the only thing is try creating cdt instead of local variable

please find below screenshot which i have tested in my environment

Note:

Try to avoid calling queryentity in with function instead use it in saveInto of cascading components.