Check Box Multiple Select In a Editable Grid

Hi All,

In a interface i am showing all the  product details  of a single order id getting from a record using a editable grid which is coming from the assistant buyer  to Buyer , buyer should give his approval or rejection by selecting products in a editable grid along with his comments for each product in the grid how to achieve this 

product id product name quantity price assist buyer comments buyer comments
1 biscuit 1 20 please approve
2 chocolate 2 30 please approve
3 ice cream 2 50 please approve

  Discussion posts and replies are publicly visible

  • hii thanks for your response in my case , i am getting the product details from a record and showing in the editable grid by filtering with orderid ,  how to achieve multi select 

  • 0
    Certified Senior Developer
    in reply to Ramesh Babu

    Same thing just  replace  local!items (Where he used Map) , you gonna add your queried data. 

  • a!localVariables(
      local!RafDB:rule!RRL_RangeAmendmenttable(
        ResetID:ri!ResetID
        ),
        local!FinalTaskID:rule!RRL_To_Get_FinalTaskTable_FinalTaskID_by_ResetID(
          ResetID: ri!ResetID
        ),
      local!item:ri!record,
      local!selecteditems:tointeger({}),
    {
      a!columnsLayout(
        columns: {
          a!columnLayout(
            contents: {
              
                a!gridLayout(
                  label: "RAF",
                  labelPosition: "ABOVE",
                  /*totalCount: count(local!item),*/
                  headerCells: {
                    a!gridLayoutHeaderCell(label: "RAF ID",
                    align: "CENTER"),
                    a!gridLayoutHeaderCell(
                      label: "Action Type"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Product Name"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Product Description"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "PIN"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "PIN Description",
                      align: "CENTER"
                    ),
    
                    a!gridLayoutHeaderCell(
                      label: "Own Brand",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Bar code",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Supplier Code",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Supplie site code",
                      align: "CENTER"
                    ),
    
                    a!gridLayoutHeaderCell(
                      label: "Case Pack",
                      align: "CENTER"
                    ),
    
                    a!gridLayoutHeaderCell(
                      label: "Indiative No of stores",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Store Code",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Per store per week unit forecast",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Local ",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Online CFC",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Online store pick",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Wholesale",
                      align: "CENTER"
                    ),
    
                    a!gridLayoutHeaderCell(
                      label: "Replacement PIN",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "New supplier",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "New Supplier Site",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Effective date from",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Effective date to ",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "New Shelf fill",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "New No of stores restrictions",
                      align: "CENTER"
                    ),
                    a!gridLayoutHeaderCell(
                      label: "Comments",
                      align: "CENTER"
                    ),
    
    
    
                  },
                  columnConfigs: {
                    a!gridLayoutColumnConfig(
                      width: "DISTRIBUTE"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "WIDE"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "DISTRIBUTE"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
    
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width:  "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: 
                      "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
    
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "NARROW_PLUS"
                    ),
                    a!gridLayoutColumnConfig(
                      width: "MEDIUM"
                    )
    
                  },
                  rows: {
                    a!forEach(                                   
                      items: local!RafDB,
    
                      expression:a!gridRowLayout(
                     
                        contents:  {
                          a!integerField(
                            label: "RafID",
                            labelPosition: "ABOVE",
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{912b0b14-c029-4f74-8c83-cc192b13a9f7}rafid'],
                            saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{912b0b14-c029-4f74-8c83-cc192b13a9f7}rafid']},
                            refreshAfter: "UNFOCUS",
                            readOnly: true(),
                            validations: {}
                          ),
                          a!textField(
                            label: "ActionType",
                            labelPosition: "ABOVE",
                            /*value:if(fv!item.ActionType=ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{08e20d1c-adc0-4959-b710-971a226887c8}actiontype'],fv!item.ActionType,ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{08e20d1c-adc0-4959-b710-971a226887c8}actiontype']),*/
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'],
                            saveInto: {
                              fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype']},
                            refreshAfter: "UNFOCUS",
                            validations: {}
                          ),
                          a!textField(
                            label: "Product Name",
                            labelPosition: "ABOVE",
                            /*value:if(fv!item.ProductDescription=ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{e36939ea-4aed-4856-b730-7f7d40a17ac3}productdescription'],fv!item.ProductDescription,ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{e36939ea-4aed-4856-b730-7f7d40a17ac3}productdescription']),*/
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{1c9ff245-977a-4fde-8029-fedf07ae694b}productname'],
                            saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{1c9ff245-977a-4fde-8029-fedf07ae694b}productname']},
                            refreshAfter: "UNFOCUS",
                            validations: {}
                          ),
                          a!textField(
                            label: "ProductDescription",
                            labelPosition: "ABOVE",
                            /*value:if(fv!item.ProductDescription=ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{e36939ea-4aed-4856-b730-7f7d40a17ac3}productdescription'],fv!item.ProductDescription,ri!record['recordType!{7ecc7842-55a4-49f3-847b-1471c77d2f0e}RRL Range Amendment Form.fields.{e36939ea-4aed-4856-b730-7f7d40a17ac3}productdescription']),*/
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a02e7fc5-fb31-404e-8d8b-41e0754c4c34}productdescription'],
                            saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a02e7fc5-fb31-404e-8d8b-41e0754c4c34}productdescription']},
                            refreshAfter: "UNFOCUS",
                            validations: {}
                          ),
                          a!integerField(
                            label: "PIN",
                            labelPosition: "ABOVE",
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{cf54d2bc-8ee5-4261-91b2-fea37c3637b1}pin'],
                            saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{cf54d2bc-8ee5-4261-91b2-fea37c3637b1}pin']},
                            refreshAfter: "UNFOCUS",
                            validations: {}
                          ),
                          a!textField(
                            label: "PIN Description",
                            labelPosition: "ABOVE",
                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{e97f8605-1202-4722-ba08-17de37d0e303}pindescription'],
                            saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{e97f8605-1202-4722-ba08-17de37d0e303}pindescription']},
                            refreshAfter: "UNFOCUS",
                            readOnly: false(),
                            disabled: if(
                              {
                                contains({"Delist product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","Supplier change","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                              },
    
                              true(),
                              false()
    
                            ),
                            validations: {}),
    
    
                            a!textField(
                              label: "Own Brand",
                              labelPosition: "ABOVE",
                              value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{e77b8d44-1633-46cf-ba8e-f6f30c17661d}ownbrand'],
                              saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{e77b8d44-1633-46cf-ba8e-f6f30c17661d}ownbrand']},
                              refreshAfter: "UNFOCUS",
                              required: false(),
                              readOnly: false(),
                              disabled: if(
                                {
                                  contains({"Delist product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","Supplier change","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                },
    
                                true(),
                                false()
    
                              ),
                              validations: {}),
                              a!textField(
                                label:"Bar Code",
                                labelPosition: "ABOVE",
                                value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{1951e235-ac60-4752-8576-e53171be36eb}barcode'],
                                saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{1951e235-ac60-4752-8576-e53171be36eb}barcode']},
                                refreshAfter: "UNFOCUS",
                                readOnly: false(),
                                disabled: if(
                                  {
                                    contains({"Delist product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","Supplier change","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                  },
    
                                  true(),
                                  false()
    
                                ),
                                validations: {}
                              ),
                              a!textField(
                                label:"Supplier Code",
                                labelPosition: "ABOVE",
                                value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{2932e997-a42d-449c-8eed-33d3b7ab7247}suppliercode'],
                                saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{2932e997-a42d-449c-8eed-33d3b7ab7247}suppliercode']},
                                refreshAfter: "UNFOCUS",
                                readOnly: false(),
                                disabled: if(
                                  {
                                    contains({"PlaceHolder for new product","Supplier change"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                  },
                                  false(),true()
                                ),
                                validations: {}
                              ),
                              a!textField(
                                label: "Supplie site code",
                                labelPosition: "ABOVE",
                                value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{780bbae2-d5f9-496e-8917-9f85ab1dda63}suppliesitecode'],
                                saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{780bbae2-d5f9-496e-8917-9f85ab1dda63}suppliesitecode']},
                                refreshAfter: "UNFOCUS",
                                readOnly: false(),
                                disabled: if(
                                  {
                                    contains({"PlaceHolder for new product","Supplier change"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                  },
                                  false(),true()
                                ),
                                validations: {}),
    
                                a!textField(
                                  label: "Case Pack",
                                  labelPosition: "ABOVE",
                                  value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{d5f02527-3e47-4352-8902-cb2bc0d2d1d0}casepack'],
                                  saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{d5f02527-3e47-4352-8902-cb2bc0d2d1d0}casepack']},
                                  refreshAfter: "UNFOCUS",
                                  readOnly: false(),
                                  disabled: if(
                                    {
                                      contains({"PlaceHolder for new product"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                    },
                                    false(),true()
                                  ),
                                  validations: {}),
                                  a!textField(
                                    label: "Indiative No of stores",
                                    labelPosition: "ABOVE",
                                    value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ff8fdddd-e5e1-4eaa-a976-222cf5e95c2e}indiativenoofstores'],
                                    saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ff8fdddd-e5e1-4eaa-a976-222cf5e95c2e}indiativenoofstores']},
                                    refreshAfter: "UNFOCUS",
                                    readOnly: false(),
                                    disabled: if(
                                      {
                                        contains({"PlaceHolder for new product","New product","Product Distribution Increase","New ingredient","Product Distribution Decrease"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                      },
                                      false(),true()
                                    ),
                                    validations: {}),
                                    a!textField(
                                      label:"Store Code",
                                      labelPosition: "ABOVE",
                                      value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{d2fce41a-f511-4d65-b770-6f5f3de9fa0d}storecode'],
                                      saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{d2fce41a-f511-4d65-b770-6f5f3de9fa0d}storecode']},
                                      refreshAfter: "UNFOCUS",
                                      readOnly: false(),
                                      disabled: if(
                                        {
                                          contains({"PlaceHolder for new product","New product","Product Distribution Increase","New ingredient","Product Distribution Decrease"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                        },
                                        false(),true()
                                      ),
                                      validations: {}
                                    ),
                                    a!textField(
                                      label: "Per store per week unit forecast",
                                      labelPosition: "ABOVE",
                                      value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{b4bcc3dd-a61c-4190-b7ac-fdd12aa7da70}perstoreperweekunitforecast'],
                                      saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{b4bcc3dd-a61c-4190-b7ac-fdd12aa7da70}perstoreperweekunitforecast']},
                                      refreshAfter: "UNFOCUS",
                                      readOnly: false(),
                                      disabled: if(
                                        {
                                          contains({"New product","New ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                        },
                                        false(),true()
                                      ),
                                      validations: {}),
                                      a!textField(
                                        label: "Local",
                                        labelPosition:
                                        "ABOVE",
                                        value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{216f9911-ede5-4600-92bd-8ce5b80fb53e}local'],
                                        saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{216f9911-ede5-4600-92bd-8ce5b80fb53e}local']},
                                        refreshAfter: "UNFOCUS",
                                        readOnly: false(),
                                        disabled: if(
                                          {
                                            contains({"PlaceHolder for new product"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                          },
                                          false(),true()
                                        ),
                                        validations: {}),
                                        a!textField(
                                          label: "Online CFC",
                                          labelPosition: "ABOVE",
                                          value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{62f2859a-e474-4f61-baa2-64a2ddf88b9f}onlinecfc'],
                                          saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{62f2859a-e474-4f61-baa2-64a2ddf88b9f}onlinecfc']},
                                          refreshAfter: "UNFOCUS",
                                          readOnly: false(),
                                          disabled: if(
                                            {
                                              contains({"PlaceHolder for new product"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                            },
                                            false(),true()
                                          ),
                                          validations: {}),
                                          a!textField(
                                            label: "Online store pick",
                                            labelPosition: "ABOVE",
                                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{2a466a3f-f879-46da-9d60-e278e2819c56}onlinestorepick'],
                                            saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{2a466a3f-f879-46da-9d60-e278e2819c56}onlinestorepick']},
                                            refreshAfter: "UNFOCUS",
                                            readOnly: false(),
                                            disabled: if(
                                              {
                                                contains({"PlaceHolder for new product"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                              },
                                              false(),true()
                                            ),
                                            validations: {}),
                                            a!textField(
                                              label: "Wholesale",
                                              labelPosition: "ABOVE",
                                              value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{28e479b8-26c9-4a53-a1d1-9cffd0777763}wholesale'],
                                              saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{28e479b8-26c9-4a53-a1d1-9cffd0777763}wholesale']},
                                              refreshAfter: "UNFOCUS",
                                              readOnly: false(),
                                              disabled: if(
                                                {
                                                  contains({"PlaceHolder for new product"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])
                                                },
                                                false(),true()
                                              ),
                                              validations: {}),
    
                                              a!textField(
                                                label: "Replacement PIN",
                                                labelPosition: "ABOVE",
                                                value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{fbb78389-6e9c-4c02-ba10-db2f1af86b9d}replacementpin'],
                                                saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{fbb78389-6e9c-4c02-ba10-db2f1af86b9d}replacementpin']},
                                                refreshAfter: "UNFOCUS",
                                                readOnly: false(),
                                                disabled: if(
                                                  {
                                                    contains({"Delist product","PlaceHolder for new product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","Supplier change","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                    true(),false()
                                                ),
                                                validations: {}),
                                                a!textField(
                                                  label: "New supplier",
                                                  labelPosition: "ABOVE",
                                                  value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{cb95960e-37ac-496f-aa7f-71fe3544a69f}newsupplier'],
                                                  saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{cb95960e-37ac-496f-aa7f-71fe3544a69f}newsupplier']},
                                                  refreshAfter: "UNFOCUS",
                                                  readOnly: false(),
                                                  disabled: if(
                                                    {
                                                      contains({"Delist product","PlaceHolder for new product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                      true(),false()
                                                  ),
                                                  validations: {}),
                                                  a!textField(
                                                    label: "New Supplier site",
                                                    labelPosition: "ABOVE",
                                                    value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{bccd620a-1092-4335-a06c-ec91a878a954}newsuppliersite'],
                                                    saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{bccd620a-1092-4335-a06c-ec91a878a954}newsuppliersite']},
                                                    refreshAfter: "UNFOCUS",
                                                    readOnly: false(),
                                                    disabled: if(
                                                      {
                                                        contains({"Delist product","PlaceHolder for new product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","Delist outer case code","New outer case code","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                        true(),false()
                                                    ),
                                                    validations: {}),
                                                    a!textField(
                                                      label: "Effective date from",
                                                      labelPosition: "ABOVE",
                                                      value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{c5882fe8-4338-4859-85bf-f238cce498a1}effectivedatefrom'],
                                                      saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{c5882fe8-4338-4859-85bf-f238cce498a1}effectivedatefrom']},
                                                      refreshAfter: "UNFOCUS",
                                                      readOnly: false(),
                                                      disabled: if(
                                                        {
                                                          contains({"Delist product","PlaceHolder for new product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                          true(),false()
                                                      ),
                                                      validations: {}),
                                                      a!textField(
                                                        label: "Effective date to ",
                                                        labelPosition: "ABOVE",
                                                        value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ed7b62b4-704e-4d51-8126-60d66532d51e}effectivedateto'],
                                                        saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ed7b62b4-704e-4d51-8126-60d66532d51e}effectivedateto']},
                                                        refreshAfter: "UNFOCUS",
                                                        readOnly: false(),
                                                        disabled: if(
                                                          {
                                                            contains({"Delist product","PlaceHolder for new product","New product","Product Distribution Increase","Product Distribution Decrease","Product shelf space decrease","New ingredient","Delist ingredient"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                            true(),false()
                                                        ),
                                                        validations: {}),
                                                        a!textField(
                                                          label: "New Shelf fill ",
                                                          labelPosition:
                                                          "ABOVE",
                                                          value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{379bed0c-2800-47a6-90a4-00b8fb1d068b}newshelffill'],
                                                          saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{379bed0c-2800-47a6-90a4-00b8fb1d068b}newshelffill']},
                                                          refreshAfter: "UNFOCUS",
                                                          readOnly: false(),
                                                          disabled: if(
                                                            {
                                                              contains({"Product shelf space decrease"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                              false(),true()
                                                          ),
                                                          validations: {}),
                                                          a!textField(
                                                            label: "New No of stores restrictions",
                                                            labelPosition: "ABOVE",
                                                            value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{c52e7478-e078-475a-872b-0881e4fbaff8}newnoofstoresrestrictions'],
                                                            saveInto:{fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{c52e7478-e078-475a-872b-0881e4fbaff8}newnoofstoresrestrictions']},
                                                            refreshAfter: "UNFOCUS",
                                                            readOnly: false(),
                                                            disabled: if(
                                                              {
                                                                contains({"Product Distribution Increase","Product Distribution Decrease"},fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{a83f9b8c-678a-4ef6-85e1-6e1adbe51440}actiontype'])},
                                                                false(),true()
                                                            ),
                                                            validations: {}),
    
                                                            a!textField(
                                                              label:"Comments",
                                                              labelPosition: "ABOVE",
                                                              value:fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ddc8fd6a-7c22-4557-9108-45008ca583f5}comments'],
                                                              saveInto: {fv!item['recordType!{88cc2e50-4c44-4185-820b-62d4d8966c39}RRL _RAF.fields.{ddc8fd6a-7c22-4557-9108-45008ca583f5}comments']},
                                                              refreshAfter: "UNFOCUS",
                                                              readOnly: false(),
                                                              validations: {}),
    
    
                        }
                      )
                    )},
                    selectable: true(),
                    selectionValue: local!selecteditems,
                    selectionSaveInto: a!save(local!selecteditems,a!flatten(save!value))
    
                  
                  /*addRowLink:a!dynamicLink(*/
                    /*label: "ADD RAF",*/
                    /*value: 'type!{urn:com:appian:types:RRL}RRL_RAF'(),*/
                    /*saveInto: a!save(*/
                      /*local!RafDB,*/
                      /*append(local!RafDB, save!value)*/
                    /*),*/
                  /*),*/
                  
                  
                ),
              a!columnsLayout(
                columns: {
                  a!columnLayout(
                    contents: {
                      a!buttonArrayLayout(
                        buttons: {
                          a!buttonWidget_23r3(
                            label: "Reject",
                            saveInto: {a!save(ri!record,local!RafDB),
                            a!save(ri!Action,"Rejected"),
                            a!startProcess(
                              processModel: cons!RRL_RAF_Update_PM,
                              processParameters: {
                                record:local!RafDB,
                                ResetID:ri!ResetID,
                                FinalTaskID:local!FinalTaskID,
                                Action:"Rejected"
                              }
                            )
                            
                            },
                            submit: true,
                            size: "STANDARD",
                            width: "MINIMIZE",
                            style: "NORMAL",
                            loadingIndicator: true,
                            confirmHeader: "Confirm",
                            confirmMessage: "Are you Sure want to Reject ?",
                            confirmButtonLabel: "Yes",
                            cancelButtonLabel: "No"
                          )
                        },
                        align: "START"
                      )
                    }
                  ),
                  a!columnLayout(
                    contents: {}
                  ),
                  a!columnLayout(
                    contents: {
                      a!buttonArrayLayout(
                        buttons: {
                          a!buttonWidget_23r3(
                            label: "Approve",
                            saveInto: {a!save(ri!record,local!RafDB),
                             a!startProcess(
                               processModel: cons!RRL_RAF_Update_PM,
                               processParameters: {
                                 record:local!RafDB,
                                 ResetID:ri!ResetID,
                                 FinalTaskID:local!FinalTaskID,
                                 Action:"Approved"
                               }
                             ),
                             a!save(ri!Action,"Approved")
                            },
                            submit: true,
                            style: "NORMAL",
                            confirmHeader: "Confirm",
                            confirmMessage: "Are you sure want to Approve ?",
                            confirmButtonLabel: "YES",
                            cancelButtonLabel: "NO"
                          )
                        },
                        align: "END"
                      )
                    }
                  )
                }
              )
              
            }
          )
        }
      )
    }
    )

    i am getting null and i am unable to select multiple , plase help me to resolve this

  • 0
    Certified Lead Developer
    in reply to Ramesh Babu

    you haven't given a value for the "id: " parameter within a!gridRowLayout().  That is what determines the value that gets grabbed by the "selectionSaveInto" control in the grid itself.