Skip to main content
I
iswaryan3520
November 3, 2025
Solved

Add new row in the middle of the grid

  • November 3, 2025
  • 5 replies
  • 0 views

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

Best answer by stefanhelzle0001

Did you try the insert() function?

https://docs.appian.com/suite/help/25.3/fnc_array_insert.html

5 replies

harshas2775
harshas2775
November 3, 2025

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
      )
    )
  )
)

    I
    iswaryan3520Author
    November 3, 2025

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

    harshas2775
    harshas2775
    November 3, 2025

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

    stefanhelzle0001
    stefanhelzle0001Answer
    November 3, 2025

    Did you try the insert() function?

    https://docs.appian.com/suite/help/25.3/fnc_array_insert.html

      I
      iswaryan3520Author
      November 3, 2025

      Yes , insert works .

      Terms & ConditionsAccessibility statement