Table or grid pagination

@chrisbarsis33 I think you could get a similar result with some clever filtering.

The simple version has two controls: records_start and records_end

Add in a Dynamic RowID as described over here: Consecutive Row Numbers?

Then! Filter the table as such: d_rowID >= records_start AND d_rowID <= records_end


If you are looking for a specifically paged view, you should implement this with named fields page_number and records_per_page (type =10 in the canvas and select the dropdown arrow).

You still need the d_rowID as above.

Then, filter the table with: d_rowID > (page_number-1)*records_per_page AND d_rowID <= (page_number)*records_per_page

This gives us rowID between 11 and 20 (inclusive) if we have 10 records per page and select page 2.

1 Like