Hi there,
I dealing with huge amount of data and to display it I am using “Table” view but the pain I have go throuh whole of the list in same view (Eg if I want to visit last record in the table). Is there any way by which I can achieve close to something as share in screenshot
As per my understanding pagination for table as you mention is not available in AppSheet.
However typically while browsing any large data, the user is likely to follow some pattern.
Not directly pagination but a good option one may think of is grouping the table records on some logical pattern that user brows the data in a table.
For example, one may group data by say Year, month and week. In some cases, this grouping may be more useful for the user instead of plain page numbers.
Also if the user knows what he is searching for , for example , say a company name, then the user may find that by using search option.
Hi Suvrutt,
Apprieciate your prompt response, Well grouping of data wont work for me as I can only group data based on ID
Beside searching field isnt there any other option ?
Please explore following workaround
Please add a virtual column called say Record Number with an app formula something like
CEILING(([_ROWNUMBER]-1)/10.0) if you wish the pagination by 10 records or
CEILING(([_ROWNUMBER]-1)/100.00) if you wish the pagination by 100 records and so on.
In the table view of the table, in the group by setting, please include Group by column as [Record Number] folowed by second group by column as [_ROWNumber]
You will get a grouping or we may say vertical pagination something like below
1 will have records from 1-10 or 1-100 and so on.
