Hello AppSheet Users,
Iโve been wondering why a โkeyโ is necessary and how can I incorporate it into my app?
As of now, I currently have an โimplicit row keyโ which is the row number. This is because every other row is repeated, so there isnโt any โunique rowโ in my data. However, at the same time I would like multiple users to use the app at the same time without any data loss. What can I do if I have no unique row but yet I would like multiple users to add entries on the app? Thanks in advance.
Itโs very easy. Simply add a column to your table to house the key. Then hide it, and mark it as the key in the editor, and make the initial value =UNIQUEID()
Appsheet pretty much handles the restโฆ (You would need to go ahead and manually enter unique โnumbersโ into your data for the rows that already existsโฆ)
@Grant_Stead Awesome, works exactly as you say. Thanks so much
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |