This article explains why your Awesome Table is only displaying a handful of records in your datasheet.
Not all the data rows are specified in the datasource range
Your current data range must be configured to exclude other relevant rows or records.
In our example, there are 26 rows of data but only 11 are shown because P13 was specified in the data source range. As a result, only 13 rows are referenced (two for the header and parameter rows, and 11 for the dataset) and displayed on your app.
Always specify the entire column to include all records or rows of your datasheet.
Follow the prescribed format of entering the data range:
This ensures that the last row or record of your dataset is always included.
Click the Update app button to apply your changes.
A significant number of records (rows) were hidden
Display the hidden rows, as follows:
not_interested Never hide a column or a row in the spreadsheet that you want to display. If data is hidden, it will not be displayed in your app.
The spreadsheet is filtered to display a subset of records
Clear or remove all filters in the spreadsheet to display all the records on your app.
In our example, there are 26 rows of data but only two are shown because it’s currently filtered to show the category Spreadsheet under column E (Type). As a result, only two records are displayed on the app even though the entire row is specified in the datasource range (A1:P).
Never filter or hide row(s) of the datasheet.
Clear filters in the app
Click the More actions button and select Clear filters.
Clear all filters.