How to prevent UNIQUEID() to to generate scientific number in Google Sheet

[kvngo94]

I use uniqueid() for table's ID / Key column

But sometimes it create errors like this in google sheet and can' t view in appsheet

Could you guys please suggest me ways how to avoid this ? Thank you in advance

[Nantha]

I think the + sign is because it's not showing the entire column. Try expanding the column width

[dbaum · Accepted solution]

Change the column's formatting to Plain Text.

[kvngo94]

Thanks dbaum, 

But there is another way to avoid this ?

Because as sometimes when I create new sheet for new table, I can easily forget to change this to plain text and this error happens

[dbaum]

Keep in mind that the source of the issue is Sheets functionality. Just like any other data source, Sheets has settings and options that need to be configured properly to optimize the file's use with an AppSheet app. This is analogous to using a SQL data base where each column's data type must be explicitly set to, say, text vs. number.

That said, in AppSheet it would be possible to modify your expression for the table ID column to remove any "e" character, which I believe is what a Sheets column misinterprets when its value formatting is set to "Automatic".

[Jonathon]

SUBSTITUTE(
  UNIQUEID(),
  "e",
  MID("0123456789abcdf", RANDBETWEEN(1, 15), 1)
)