Hello, while building my app on google sheets...

security
(Daisy Ramirez) #1

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

(Aparicio Piñeyrúa) #2

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.

(Steven Coile) #3

I agree with @Aparicio_Pineyrua1. You probably have duplicate keys.

(Daisy Ramirez) #4

Yep. That was it - the wrong field was set to the key

  • thanks so much!