unique id only creating numbers sometimes

[Phil_Waite]

Hi,

The UNIQUEID() in my orders table is creating only numbers somtimes rather than numbers and letters. This is only sometimes with different users and it stops certain google sheet formulas from functioning such as Index Match.

the middle unique id below has no letters

Any ideas why?

9ca6ba6a

40164746

b2193d23

Thanks

Phil

[dbaum]

AppSheet's UNIQUEID function is working as expected. It generates random values that can be all letters, all numerals, or a combination. It's not related to individual app users.

To address the issue that your data source does not interpret the all-numeral values as you want, format the column as plain text.

[Koichi_Tsuji]

This is one of the bugs, Google never admits...

[Koichi_Tsuji]

On the other threads, some people argued this is not a problem with appsheet but with Google Sheet.

Both same.....

[Steve]

It is not a bug.

AppSheet and Google Sheets are not the same.