There is already a row with the key

[School_Bus]

Just created an app, and I used uniqueid() to create the key for each of my records. As I complete the form I get the following error “There is already a row with the key ‘ebd46c4d’” The key is generated by Uniqueid(), and I checked my table for the ID. No such ID in my table.

Someone posted a similar problem, but they were able to fix it by going to a previous version of the app. No luck for me doing that. Anyone know what is going on with with my app?

[School_Bus]

@Steve any idea how to fix this? It’s killing me here.

[tvinci]

This used to happen to me. This article helped me.

help.appsheet.com

Manually Generating UNIQUEID() Key Values

How to manually generate UNIQUEID() key values.

[School_Bus · Accepted solution]

Welp, I fell foolish again. Looks like I had the column set to number instead of text. Thus not allowing a new uniqueid. All is fixed now

[Bernard_Redmond]

School_Bus:

to number instead of text

Problem Solved: - I deleted and re-added the Table that was causing the ERROR.

[juliorrojas15]

Hi... I have the same problem, but just in Desktop view... in phone view all is OK... I don't know why... please helpme.

[Steve]

Desktop View is currently a preview feature and under active development. Preview features are not yet suitable for use in important apps. Until it has achieved greater stability, I recommend against using this preview feature except for testing and to help the AppSheet developers in their efforts. To follow the progress of and contribute to the development effort, please visit this dedicated Community topic:

In Preview: New UI design for desktop users