Pagination in Editable Grid

The code I included above is only meant to serve as a template - the logic for getting the by-row RowIndex will need to be tested/refined by anyone attempting to implement it.  But otherwise, this solution should work and will be the most straightforward way of accomplishing this use case.

That said - I can't help you with just "gives error".  Can you share what the error says / post a screenshot / etc?

This code can be used to build pagination UI for editable grid

with(
  local!maxStartIndex: 1 + rounddown(
    (
      ri!totalCount - 1
    ) / ri!pagingInfo.batchSize,
    0
  ) * ri!pagingInfo.batchSize,
  local!style: "STRONG",
  if(
    rule!replaceNull(
      ri!showWhen,
      true
    ),
    {
      a!richTextDisplayField(
        align: rule!replaceNull(
          ri!align,
          "CENTER"
        ),
        value: {
          a!richTextIcon(
            icon: "angle-double-left",
            size: "MEDIUM",
            link: if(
              property(
                ri!pagingInfo,
                "startIndex",
                1
              ) <> 1,
              a!dynamicLink(
                saveInto: {
                  a!save(
                    ri!pagingInfo,
                    a!pagingInfo(
                      startIndex: 1,
                      batchSize: property(
                        ri!pagingInfo,
                        "batchSize",
                        - 1
                      ),
                      sort: property(
                        ri!pagingInfo,
                        "sort",
                        null
                      )
                    )
                  ),
                  ri!saveInto
                }
              ),
              null
            ),
            linkStyle: "STANDALONE"
          ),
          a!richTextIcon(
            icon: "angle-left",
            size: "MEDIUM",
            link: if(
              property(
                ri!pagingInfo,
                "startIndex",
                1
              ) <> 1,
              a!dynamicLink(
                saveInto: {
                  a!save(
                    ri!pagingInfo,
                    a!pagingInfo(
                      startIndex: max(
                        1,
                        property(
                          ri!pagingInfo,
                          "startIndex",
                          1
                        ) - property(
                          ri!pagingInfo,
                          "batchSize",
                          0
                        )
                      ),
                      batchSize: property(
                        ri!pagingInfo,
                        "batchSize",
                        - 1
                      ),
                      sort: property(
                        ri!pagingInfo,
                        "sort",
                        null
                      )
                    )
                  ),
                  ri!saveInto
                }
              ),
              null
            ),
            linkStyle: "STANDALONE"
          ),
          a!richTextItem(
            text: concat(
              " ",
              min(
                ri!totalCount,
                property(
                  ri!pagingInfo,
                  "startIndex",
                  1
                )
              ),
              " - ",
              min(
                ri!totalCount,
                property(
                  ri!pagingInfo,
                  "startIndex",
                  1
                ) + if(
                  property(
                    ri!pagingInfo,
                    "batchSize",
                    - 1
                  ) = - 1,
                  ri!totalCount,
                  property(
                    ri!pagingInfo,
                    "batchSize",
                    - 1
                  )
                ) - 1
              )
            ),
            style: "STRONG",
            size: "STANDARD"
          ),
          a!richTextItem(
            text: concat(
              " of ",
              ri!totalCount,
              " "
            ),
            style: "STRONG",
            size: "STANDARD"
          ),
          a!richTextIcon(
            icon: "angle-right",
            size: "MEDIUM",
            link: if(
              property(
                ri!pagingInfo,
                "startIndex",
                1
              ) <> local!maxStartIndex,
              a!dynamicLink(
                saveInto: {
                  a!save(
                    ri!pagingInfo,
                    a!pagingInfo(
                      startIndex: min(
                        local!maxStartIndex,
                        property(
                          ri!pagingInfo,
                          "startIndex",
                          1
                        ) + property(
                          ri!pagingInfo,
                          "batchSize",
                          0
                        )
                      ),
                      batchSize: property(
                        ri!pagingInfo,
                        "batchSize",
                        - 1
                      ),
                      sort: property(
                        ri!pagingInfo,
                        "sort",
                        null
                      )
                    )
                  ),
                  ri!saveInto
                }
              ),
              null
            ),
            linkStyle: "STANDALONE"
          ),
          a!richTextIcon(
            icon: "angle-double-right",
            size: "MEDIUM",
            link: if(
              property(
                ri!pagingInfo,
                "startIndex",
                1
              ) <> local!maxStartIndex,
              a!dynamicLink(
                saveInto: {
                  a!save(
                    ri!pagingInfo,
                    a!pagingInfo(
                      startIndex: local!maxStartIndex,
                      batchSize: property(
                        ri!pagingInfo,
                        "batchSize",
                        - 1
                      ),
                      sort: property(
                        ri!pagingInfo,
                        "sort",
                        null
                      )
                    )
                  ),
                  ri!saveInto
                }
              ),
              null
            ),
            linkStyle: "STANDALONE"
          )
        }
      )
    },
    {}
  )
)

Use indexing like this, or the data will be overwritten for the same row across all pages.

Mohan Reddy Kethireddigari said:

Use indexing like this

The setup you've pictured here might work, though at this point I recommend, instead of writing out that huge index expression every time, that the value be stored in a row-specific Local variable for reuse (and ease of debugging), if anything.

Also, I stand behind my usual recommendation that devs avoid the approach of manually adding paging to editable grids unless literally all other approaches have been tried and found to be insufficient.  I still (over "4 years later" in the case of this Zombie Thread) recommend going with read-only ("paging") grids where each row has an individual "edit icon", which shows a mini editing interface for just that row after being clicked, which the user can then "save" or "cancel" out of - this offers better and more easy control over things like validation, and less space constraints.