• State Verified Answer
  • Replies 5 replies
  • Subscribers 10 subscribers
  • Views 30 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Add new row in the middle of the grid

iswaryan3520

I have enhancement requirement , I have editable grid and when user add new row to the grid it should be inserted before the last row ,  Is that possible if yes can anyone help to get started with?

Below is my existing code 

 

a!localVariables(
  local!feeDetails: ri!feeDetails,
  local!minimumFee: reject(
    fn!isnull,
    a!flatten(
      a!forEach(
        items: ri!feeDetails,
        expression: if(
          and(
            toboolean(
              fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive']
            ) = toboolean(true()),
            tointeger(
              fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId']
            ) = tointeger(
              ri!selectedScenario['recordType!{94f6f945-ec9c-4178-8b3f-684a5547bb00}PRC Scenarios.fields.{ad9e991c-6487-437f-8665-fe15a96eba42}prcScenarioId']
            ),
            tointeger(
              fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{6e4fe629-03b7-49fe-8d52-f541257e3ca5}planId']
            ) = tointeger(
              ri!selectedPlan['recordType!{3b41856e-be2b-486e-b0f7-09436ce2d07e}PRC Plan.fields.{4903a64b-b0f8-4ddb-98d1-00bcc0e648d1}prcPlanId']
            ),
            tointeger(
              fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7e014768-277f-4844-a8d0-7c6baeccf934}iteration']
            ) = tointeger(ri!iteration),
            or(
              isnull(
                fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4a8a03ee-98f5-4712-8135-4c235968e033}serviceExId']
              ),
              contains(
                { 27, 75, 261, 251, 271 },
                fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4a8a03ee-98f5-4712-8135-4c235968e033}serviceExId']
              )
            )
          ),
          fv!item,
          null
        )
      )
    )
  ),
  local!minimumIndex: index(local!minimumFee, 1, {}),
  local!minimumValue: if(
    isnull(local!minimumIndex),
    tointeger(0),
    tointeger(
      index(
        local!minimumIndex,
        'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{67613804-ab49-4df7-91d4-358b515efd47}minimumfee',
        {}
      ),
      
    )
  ),
  {
    a!cardLayout(
      marginAbove: "EVEN_MORE",
      showBorder: false,
      showShadow: true,
      contents: {
        a!sectionLayout(
          contents: a!gridLayout(
            headerCells: {
              a!gridLayoutHeaderCell("Annual Fee"),
              a!gridLayoutHeaderCell("Sequence"),
              a!gridLayoutHeaderCell("Amount"),
              a!gridLayoutHeaderCell(" "),
              
            },
            columnConfigs: {
              a!gridLayoutColumnConfig(width: "NARROW_PLUS"),
              a!gridLayoutColumnConfig(width: "NARROW_PLUS"),
              a!gridLayoutColumnConfig(width: "NARROW_PLUS"),
              a!gridLayoutColumnConfig(width: "ICON")
            },
            rows: a!forEach(
              items: local!feeDetails,
              expression: if(
                and(
                  fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'] = true(),
                  tointeger(
                    fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId']
                  ) = tointeger(
                    ri!selectedScenario['recordType!{94f6f945-ec9c-4178-8b3f-684a5547bb00}PRC Scenarios.fields.{ad9e991c-6487-437f-8665-fe15a96eba42}prcScenarioId']
                  ),
                  tointeger(
                    fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{6e4fe629-03b7-49fe-8d52-f541257e3ca5}planId']
                  ) = tointeger(
                    ri!selectedPlan['recordType!{3b41856e-be2b-486e-b0f7-09436ce2d07e}PRC Plan.fields.{4903a64b-b0f8-4ddb-98d1-00bcc0e648d1}prcPlanId']
                  ),
                  tointeger(
                    fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7e014768-277f-4844-a8d0-7c6baeccf934}iteration']
                  ) = tointeger(ri!iteration),
                  or(
                    contains(
                      { 271, 251, 261, 75, 27 },
                      fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4a8a03ee-98f5-4712-8135-4c235968e033}serviceExId']
                    ),
                    isnull(
                      fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4a8a03ee-98f5-4712-8135-4c235968e033}serviceExId']
                    )
                  )
                ),
                a!gridRowLayout(
                  id: fv!index,
                  contents: {
                    a!textField(
                      readOnly: not(ri!isEdit),
                      value: if(
                        a!isNotNullOrEmpty(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{796cea1b-ff7a-4223-a860-65e23373eab4}annualfee']
                        ),
                        concat(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{796cea1b-ff7a-4223-a860-65e23373eab4}annualfee'],
                          " BPS"
                        ),
                        ""
                      ),
                      saveInto: {
                        a!save(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{796cea1b-ff7a-4223-a860-65e23373eab4}annualfee'],
                          if(
                            or(isnull(save!value), save!value = ""),
                            null,
                            tointeger(save!value)
                          )
                        ),
                        a!save(ri!feeDetails, local!feeDetails),
                        a!save(ri!allfeeDetails, ri!feeDetails)
                      },
                      align: "LEFT"
                    ),
                    a!textField(
                      validations: {
                        if(
                          contains(
                            { "Next", "First", "Over" },
                            fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{08ad88f5-e074-43e5-856e-a3661bdc2ee3}sequence']
                          ),
                          {},
                          "Sequence should not be empty and Only First, Next, Over sequence allowed"
                        ),
                        if(
                          a!isNullOrEmpty(
                            fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{08ad88f5-e074-43e5-856e-a3661bdc2ee3}sequence']
                          ),
                          "Sequence should not be empty",
                          {}
                        )
                      },
                      value: fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{08ad88f5-e074-43e5-856e-a3661bdc2ee3}sequence'],
                      saveInto: {
                        fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{08ad88f5-e074-43e5-856e-a3661bdc2ee3}sequence'],
                        a!save(ri!feeDetails, local!feeDetails),
                        a!save(ri!allfeeDetails, ri!feeDetails)
                      },
                      readOnly: not(ri!isEdit),
                      align: "LEFT"
                    ),
                    a!textField(
                      validations: if(
                        or(
                          a!isNullOrEmpty(
                            fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount']
                          ),
                          tointeger(
                            fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount']
                          ) = cons!WMS_INT_ZERO
                        ),
                        "Please enter a valid dollar amount.",
                        {}
                      ),
                      readOnly: not(ri!isEdit),
                      value: if(
                        a!isNotNullOrEmpty(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount']
                        ),
                        dollar(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount']
                        ),
                        dollar(0)
                      ),
                      saveInto: {
                        a!save(
                          fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount'],
                          if(
                            a!isNotNullOrEmpty(save!value),
                            save!value,
                            0
                          )
                        ),
                        a!save(ri!feeDetails, local!feeDetails),
                        a!save(ri!allfeeDetails, ri!feeDetails)
                      },
                      align: "LEFT"
                    ),
                    a!richTextDisplayField(
                      value: a!richTextIcon(
                        showWhen: contains(
                          {
                            cons!PRC_REF_ID_STAGE_IN_REVIEW,
                            cons!PRC_REF_ID_STAGE_RETURNED_RESUBMITTED_PRICING,
                            cons!PRC_REF_ID_STAGE_REVIEW_PRICING
                          },
                          tointeger(
                            ri!prcRequest['recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{f3e4d721-201d-4797-a17a-cfec05ef3e98}stage']
                          )
                        ),
                        icon: "close",
                        altText: "delete ",
                        caption: "Remove",
                        link: a!dynamicLink(
                          value: fv!index,
                          saveInto: {
                            a!save(
                              local!feeDetails[fv!index]['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'],
                              false()
                            ),
                            a!save(ri!feeDetails, local!feeDetails),
                            a!save(ri!allfeeDetails, ri!feeDetails)
                          }
                        ),
                        linkStyle: "STANDALONE",
                        color: "NEGATIVE"
                      )
                    )
                  }
                ),
                {}
              )
            ),
            addRowLink: a!dynamicLink(
              showWhen: contains(
                {
                  cons!PRC_REF_ID_STAGE_IN_REVIEW,
                  cons!PRC_REF_ID_STAGE_RETURNED_RESUBMITTED_PRICING,
                  cons!PRC_REF_ID_STAGE_REVIEW_PRICING
                },
                tointeger(
                  ri!prcRequest['recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{f3e4d721-201d-4797-a17a-cfec05ef3e98}stage']
                )
              ),
              label: "Add Tier Schedule",
              value: {},
              saveInto: {
                a!save(
                  local!feeDetails,
                  append(
                    local!feeDetails,
                    'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee'(
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{796cea1b-ff7a-4223-a860-65e23373eab4}annualfee': null(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{67613804-ab49-4df7-91d4-358b515efd47}minimumfee': local!minimumValue,
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7fed9839-24ea-47a8-b23b-4cc6245daff8}amount': null(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{08ad88f5-e074-43e5-856e-a3661bdc2ee3}sequence': null(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4a8a03ee-98f5-4712-8135-4c235968e033}serviceExId': ri!services['recordType!{471f50a7-6d9a-4e1b-a1ae-4b84239a4583}PRC Services.fields.{15ae6ce2-ff70-48b8-ac87-a04a0bb310b9}serviceExtId'],
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{6e4fe629-03b7-49fe-8d52-f541257e3ca5}planId': tointeger(
                        index(
                          ri!selectedPlan,
                          'recordType!{3b41856e-be2b-486e-b0f7-09436ce2d07e}PRC Plan.fields.{4903a64b-b0f8-4ddb-98d1-00bcc0e648d1}prcPlanId',
                          {}
                        )
                      ),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId': tointeger(
                        index(
                          ri!selectedScenario,
                          'recordType!{94f6f945-ec9c-4178-8b3f-684a5547bb00}PRC Scenarios.fields.{ad9e991c-6487-437f-8665-fe15a96eba42}prcScenarioId',
                          {}
                        )
                      ),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{fcc63a8b-7dab-4ea1-b0c5-61269e0ff801}createdby': loggedInUser(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{7e014768-277f-4844-a8d0-7c6baeccf934}iteration': ri!iteration,
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{0e58f0ed-17dc-4b31-8622-5f0a01f59e11}createdon': now(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive': true(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{ff8a31de-a89c-4848-b7b4-20726b0a81b9}updatedby': loggedInUser(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{f18ed932-7461-403c-9bde-5580a9831588}updatedon': now(),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{e1f9189a-a80d-4454-b39d-d1b91be1a1ce}prcRequestId': index(
                        ri!prcRequest,
                        'recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{2e588546-edee-47b5-a888-9e8813bbf0d4}prcRequestId',
                        {}
                      ),
                      'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{086743c7-671f-44b9-83ce-4978ed1e0403}wmsRequestId': ri!prcRequest['recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{010c7913-357e-4e1e-8858-7a6a1b7525cd}wmsRequestId']
                    )
                  )
                ),
                a!save(ri!feeDetails, local!feeDetails),
                a!save(ri!allfeeDetails, ri!feeDetails)
              }
            )
          ),
          divider: "NONE"
        ),
        rule!WMS_VerticalSpacer(n: 3),
        a!sideBySideLayout(
          items: a!sideBySideItem(
            width: "MINIMIZE",
            item: a!textField(
              label: "Minimum Fee",
              labelPosition: "JUSTIFIED",
              readOnly: not(ri!isEdit),
              value: if(
                isnull(todecimal(local!minimumValue)),
                dollar(todecimal(0)),
                dollar(todecimal(local!minimumValue))
              ),
              saveInto: {
                /* Save into the first row */
                a!save(
                  local!minimumValue,
                  if(
                    a!isNotNullOrEmpty(save!value),
                    save!value,
                    0
                  )
                ),
                /* Update all matching rows */
                a!save(
                  local!minimumFee,
                  a!forEach(
                    items: reject(fn!isnull, local!minimumFee),
                    expression: a!update(
                      data: fv!item,
                      index: 'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{67613804-ab49-4df7-91d4-358b515efd47}minimumfee',
                      value: if(
                        a!isNotNullOrEmpty(save!value),
                        save!value,
                        0
                      )
                    )
                  )
                ),
                /* Update original feeDetails */
                a!save(
                  local!feeDetails,
                  a!forEach(
                    items: local!feeDetails,
                    expression: a!localVariables(
                      local!match: index(
                        local!minimumFee,
                        wherecontains(
                          tointeger(
                            fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4b8a7034-4307-4a3d-8a34-aff1a0dcdfd5}prcservicesvmapid']
                          ),
                          tointeger(
                            index(
                              local!minimumFee,
                              'recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{4b8a7034-4307-4a3d-8a34-aff1a0dcdfd5}prcservicesvmapid',
                              {}
                            )
                          )
                        ),
                        {}
                      ),
                      if(
                        a!isNotNullOrEmpty(local!match),
                        local!match,
                        fv!item
                      )
                    )
                  ),
                  
                ),
                a!save(ri!feeDetails, local!feeDetails),
                a!save(ri!allfeeDetails, ri!feeDetails)
              },
              align: "LEFT"
            )
          )
        ),
        a!buttonLayout(
          primaryButtons: {
            a!buttonWidget(
              label: "close",
              icon: "check",
              style: "SOLID",
              value: false,
              saveInto: ri!showFeeDetails,
              
            ),
            a!buttonWidget(
              label: "Submit",
              icon: "check",
              style: "SOLID",
              value: false,
              saveInto: {
                ri!showFeeDetails,
                a!startProcess(
                  isSynchronous: true(),
                  processModel: cons!PRC_WRITE_TO_VMAP_FEE_DETAILS,
                  processParameters: {
                    feeDetailsProspect: ri!allfeeDetails,
                    prcRequest: ri!prcRequest,
                    prcServices: ri!allServices
                  },
                  onSuccess: {
                    a!save(
                      local!feeDetails,
                      fv!processInfo.pv.RecordsUpdated1
                    ),
                    a!save(ri!feeDetails, local!feeDetails),
                    a!save(ri!allfeeDetails, ri!feeDetails)
                  },
                  
                )
              },
              showWhen: contains(
                {
                  cons!PRC_REF_ID_STAGE_IN_REVIEW,
                  cons!PRC_REF_ID_STAGE_RETURNED_RESUBMITTED_PRICING,
                  cons!PRC_REF_ID_STAGE_REVIEW_PRICING
                },
                tointeger(
                  ri!prcRequest['recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{f3e4d721-201d-4797-a17a-cfec05ef3e98}stage']
                )
              )
            ),
            
          },
          secondaryButtons: {
            a!buttonWidget(
              label: "Cancel",
              icon: "times",
              style: "SOLID",
              value: false(),
              saveInto: ri!showFeeDetails,
              showWhen: contains(
                {
                  cons!PRC_REF_ID_STAGE_IN_REVIEW,
                  cons!PRC_REF_ID_STAGE_RETURNED_RESUBMITTED_PRICING,
                  cons!PRC_REF_ID_STAGE_REVIEW_PRICING
                },
                tointeger(
                  ri!prcRequest['recordType!{9ffd9a48-c615-4180-a5a0-1782cd09348f}PRC Request.fields.{f3e4d721-201d-4797-a17a-cfec05ef3e98}stage']
                )
              )
            )
          }
        )
      },
      showWhen: ri!showFeeDetails
    )
  }
)

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer

    Making some tweaks to the expression for addRowLink can help achieve the expected. 
    Here is a sample pattern you can refer which has two additional local variables and some changes to addRowLink definition so that expected functionality can be reached. 

    a!localVariables(
  /*  
  * local!employess is provided in this recipe as a way to start with hard-coded
  * data. However, this data is identical to the data created from the entity-backed
  * tutorial. Replace the hard-coded data with a query to the employee data store
  * entity and all of the employee records from the tutorial will appear.
  *
  * To replace this data with your own, replace (ctrl+H or cmd+H) all references to
  * local!employees with your data source, either via rule input or local variable.
  */
  local!employees: {
    a!map( id: 1, firstName: "John" , lastName: "Smith" , department: "Engineering" , title: "Director" , phoneNumber: "555-123-4567" , startDate: today()-360 ),
    a!map( id: 2, firstName: "Michael" , lastName: "Johnson" , department: "Finance" , title: "Analyst" , phoneNumber: "555-987-6543" , startDate: today()-360 ),
    a!map( id: 3, firstName: "Mary", lastName: "Reed" , department: "Engineering" , title: "Software Engineer" , phoneNumber: "555-456-0123" , startDate: today()-240 ),
  },
 local!lastRow,local!newRow,
  a!formLayout(
    titleBar: "Example: Add,Update, or Remove Employee Data",
    contents: {
      a!gridLayout(
        totalCount: count(local!employees),
        headerCells: {
          a!gridLayoutHeaderCell(label: "First Name" ),
          a!gridLayoutHeaderCell(label: "Last Name" ),
          a!gridLayoutHeaderCell(label: "Department" ),
          a!gridLayoutHeaderCell(label: "Title" ),
          a!gridLayoutHeaderCell(label: "Phone Number" ),
          a!gridLayoutHeaderCell(label: "Start Date", align: "RIGHT" ),
          /* For the "Remove" column */
          a!gridLayoutHeaderCell(label: "" )
        },
        /* Only needed when some columns need to be narrow */
        columnConfigs: {
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ),
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ),
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ),
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ),
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ),
          a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:2 ),
          a!gridLayoutColumnConfig(width: "ICON")
        },
        /*
        * a!forEach() will take local!employee data and used that data to loop through an
        * expression that creates each row.
        *
        * When modifying the recipe to work with your data, you only need to change:
        * 1.) the number of fields in each row
        * 2.) the types of fields for each column (i.e. a!textField() for text data elements)
        * 3.) the fv!item elements. For example fv!item.firstName would change to fv!item.yourdata
        */
        rows: a!forEach(
          items: local!employees,
          expression: a!gridRowLayout(
            contents: {
              /* For the First Name Column*/
              a!textField(
                /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */
                label: "first name " & fv!index,
                value: fv!item.firstName,
                saveInto: fv!item.firstName,
                required: true
              ),
              /* For the Last Name Column*/
              a!textField(
                label: "last name " & fv!index,
                value: fv!item.lastName,
                saveInto: fv!item.lastName,
                required:true
              ),
              /* For the Department Column*/
              a!dropdownField(
                label: "department " & fv!index,
                placeholder: "-- Select -- ",
                choiceLabels: { "Corporate", "Engineering", "Finance", "Human Resources", "Professional Services", "Sales" },
                choiceValues: { "Corporate", "Engineering", "Finance", "Human Resources", "Professional Services", "Sales" },
                value: fv!item.department,
                saveInto: fv!item.department,
                required:true
              ),
              /* For the Title Column*/
              a!textField(
                label: "title " & fv!index,
                value: fv!item.title,
                saveInto: fv!item.title,
                required:true
              ),
              /* For the Phone Number Column*/
              a!textField(
                label: "phone number " & fv!index,
                placeholder:"555-456-7890",
                value: fv!item.phoneNumber,
                saveInto: fv!item.phoneNumber
              ),
              /* For the Start Date Column*/
              a!dateField(
                label: "start date " & fv!index,
                value: fv!item.startDate,
                saveInto: fv!item.startDate,
                required:true,
                align: "RIGHT"
              ),
              /* For the Removal Column*/
              a!richTextDisplayField(
                value: a!richTextIcon(
                  icon: "close",
                  altText: "delete " & fv!index,
                  caption: "Remove " & fv!item.firstName & " " & fv!item.lastName,
                  link: a!dynamicLink(
                    value: fv!index,
                    saveInto: {
                      a!save(local!employees, remove(local!employees, save!value))
                    }
                  ),
                  linkStyle: "STANDALONE",
                  color: "NEGATIVE"
                )
              )
            },
            id: fv!index
          )
        ),
        addRowlink: a!dynamicLink(
          label: "Add Employee",
          /*
           * For your use case, set the value to a blank instance of your CDT using
           * the type constructor, e.g. type!Employee(). Only specify the field
           * if you want to give it a default value e.g. startDate: today()+1.
           */
          value: {
            startDate: today() + 1
          },
          saveInto: {
            a!save(local!lastRow,local!employees[length(local!employees)]),
            a!save(local!employees, append(local!employees, save!value)),
            
            a!save(local!newRow,save!value),
            a!save(local!employees,a!update(
              local!employees,{length(local!employees),length(local!employees)-1},
              {local!lastRow,local!newRow}))
            
            
          }
        ),
        rowHeader: 1
      )
    },
    buttons: a!buttonLayout(
      primaryButtons: a!buttonWidget(
        label: "Submit",
        submit: true
      )
    )
  )
)

  • 0 in reply to Harsha Sharma

    Thanks , Harshitha . I will check this approach , tried with insert function it also seems to work for now. 

  • 0
    Certified Lead Developer
     in reply to iswaryan3520

    Oh yes insert() is great for this! can't believe why my mind skipped it. Anyway glad you got the expected results. 

Reply Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.