Skip to main content
nileshr5443
January 31, 2024
Question

Number of rows limit in Editable Grid

  • January 31, 2024
  • 7 replies
  • 0 views

Hi All,

I have a query that "Do we have any limit on number of rows to display in an editable grid?". 

I have a requirement where I am fetching the data from DB and showing in editable grid for user to edit and update but after few months it might be possible that the number reaches to 10k.

So just wanted to know if we have the limit of rows in editable grid. 

    7 replies

    stefanhelzle0001
    Brainy
    January 31, 2024

    There is no hard limit, but the performance will suffer very hard as you try to display hundreds of rows.

    You will have to find a different approach. Maybe this: https://docs.appian.com/suite/help/23.4/recipe-use-links-in-a-grid-to-show-more-details-and-edit-data.html

    harshitb6843
    January 31, 2024

    Or you can add paging to your editable grid like shown here - appianspace.com/.../

    stefanhelzle0001
    Brainy
    January 31, 2024
    mikes0011
    Brainy
    January 31, 2024

    Please please please don't do this.  For data sets beyond a dozen or so items, use a filterable paging grid where each row can (individually) be clicked on to open a separated editor, where the user makes, validates, and saves any changes independently before moving onto other edits.  Editable grids that try to do 1000 different things to 1000 different rows are the bane of user experience (and impossible to maintain, unless kept exceedingly simple).

    The Expression Guru