hello dear all, some of my UNIQUEID() field shows like ใ3.02E+04ใbutใf10738b3ใ,and itโs randomly happened. how to fix this problem?
by the way, there are over 10000 column in my date sheet, and the database based on google sheet. thanks!
Solved! Go to Solution.
Equivalent, but shorter:
(mid(โabcdefghijklmnopqrstuvwxyzโ, randbetween(1, 26), 1) & uniqueid())
To avoid this situation with gSheet, adding a letter before the UNIQUEID() itself like โAโ&UNIQUEID(). This will take care that gSheet canโt recognize it as a number like 12345E02.
Perhaps it would be good if AppSheet could tweak the UNIQUEID() algorithm so that a letter was automatically placed at the beginning, regardless of whether or not the gSheet column is set to plain text.
Aesthetically, Iโd like to maintain the random appearance of the UNIQUEID() key in my app. Even the students who copy my app probably wonโt notice or care about it, but I somehow still care about the appearance. So, hereโs my solution:
concatenate(INDEX({โaโ,โbโ,โcโ,โdโ,โeโ,โfโ,โgโ,โhโ,โiโ,โjโ,โkโ,โlโ,โmโ,โnโ,โoโ,โpโ,โqโ,โrโ,โsโ,โtโ,โuโ,โvโ,โwโ,โxโ,โyโ,โzโ},randbetween(1,26)),uniqueid())
This randomly picks one of the 26 letters of the alphabet as the first letter. It also slightly enhances the โuniquenessโ of the randomly generated uniqueid().
Equivalent, but shorter:
(mid(โabcdefghijklmnopqrstuvwxyzโ, randbetween(1, 26), 1) & uniqueid())
thanks your help!
@Aleksi, @Steve, @retreat_Ieyasu, @LeventK
This issue has been resolved:
@retreat_Ieyasu
As a side note to @Aleksiโs explanation; please check that the column in your gSheet is formatted as Plain Text as well. When set as automatic, gSheet will treat IDs such as 12345E02 as exponential numbers
Thanks for raising this question, @retreat_Ieyasu! I had the same problem myself (and it caused a problem in the functioning of my app). I was about to post an inquiry but your inquiry saved me the trouble.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |