Hello, while building my app on google sheets I just noticed a view attached directly to the table (no security filters, no slices etc) is not showing all of the records I have on the google sheet (only shows 9 of 12 records).
Iโve done the following:
*Viewed data from the appsheet table to confirm appsheet is receiving all records and all 12 records are there. *Ran Sync several times *Ran Save & verify data several times *Created a clean slice directly on the table - only 9 of 12 show *Created a new view directly on the table - only 9 of 12 show *Closed the google sheet, re-opened, ran sync - only 9 of 12 show
Can someone help with what I might be missing? I believe this is happening with another google sheet on the same app as well.
A million thanks
Check the Key column.
The key column must be a unique value in the spreadsheet. In the editor you need to select that column as Key.
I agree with @Aparicio_Pineyrua1. You probably have duplicate keys.
Yep. That was it - the wrong field was set to the key
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |