Unique ID generating a Zero

AppSheet AppSheet Q&A
1

I have a scenario where AppSheet generates a “0” (zero) as the uniqueid(). The issue causes an old record to be included in csv files they’re not expected to be in among many other things.

  • The field is not visible to the user so they cannot override the field.
  • What might cause the system to generate a zero for the UNIQUEID?
  • What would cause the record to show up on a random file?
  • How do I prevent this from happening?

Any help would be outstanding! A million thanks

3X_2_9_292aa3d6ce4335126c9301beb0492d677fec0682.png
3X_2_9_292aa3d6ce4335126c9301beb0492d677fec0682.png2354×1861 444 KB

3X_5_b_5bac924e2dc43ca2bdf32a2b57c0e4e4390e069e.png
3X_5_b_5bac924e2dc43ca2bdf32a2b57c0e4e4390e069e.png2974×383 70 KB

2

New Bug Encountered: UNIQUEID() changed to scientific notation by Google Sheets’ auto-formatting Questions

A few weeks ago I had an app with just one record that was behaving differently than the others. It kept losing references to child records. When I viewed the Google Sheet, the UNIQUEID() value had been auto-formatted in scientific notation, because it just happened to meet the format of [number] E [number], like 421e24. [Screen Shot 2019-12-12 at 11.50.47 AM] I manually changed that one ID, and updated references in child tables. I figured the chances another key meeting that format were low …

2 Likes
3

Thanks a bunch. I’ll reference this in my email to appsheet support as it seems the issue hasn’t been completely resolved.

Thanks again

3 Likes
4

Always format spreadsheet columns that contain values generated with UNIQUEID() as plain text. In fact, best to format all data cells in the spreadsheet as plain text.

2 Likes