Error there is already a row with the key

[JhersonSanchez]

I have made an application using the Google sheets spreadsheet, the application is used to capture inventory information and store the data in the sheet. I asked several collaborators the favor of entering the app with the same email and password (10 users). When the 10 people collect information at the same time, but with different products, the appsheet shows the error: “There is already a row with the key”. Is there a way for multiple people to work with the same app and not show this error.

[Fael]

It shouldn't happen unless you are using some weird expression as a key.

May you share more information about your app? What exactly does "collect information at the same time" means? Could you post a screenshot of the AppSheet data structure? Most important: what is your key field and how is it calculated?

[AleksiAlkio]

Yes it's possible, but you need to take care of key column's value so it's always unique. One way is to use UNIQUEID() with the initial value in your key column.

[Patrik]

Maybe create an ID colum with an UNIQUEID() as initial value, and a Virtual Column with [ID] in formula and set it as key column.