This article describes why your Awesome Table is only displaying a handful of records in your datasheet.
1. Active filter(s) in the view
Click the More button and select Clear filters.
Clear all filters.
2. Not all of 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 will be referenced (two for the header and parameters row, and 11 for the dataset) and displayed on your view.
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 will always be included.
Click the UPDATE VIEW button for the changes to take effect. You can learn more about this here.
3. A significant number of records (rows) were hidden
Display the hidden row, 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 view.
4. The spreadsheet is filtered to a specific subset
Clear or remove all filters in the spreadsheet to show or display all of the records on your view.
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 will display on your view even though the entire row is specified in the datasource range (A1:P).
Never filter or hide row(s) of the datasheet.