UNIQUEID generator in google sheet

[Gustavo_Eduardo]

Hello everyone, I wonder if it would be possible to generate a uniqueid from google sheet, so that I could load a sheet in appsheet but with the ids preloaded and that these do not match the ids that I already have in appsheet.

Cheers

[Marc_Dillon]

=DEC2HEX(RANDBETWEEN(0, 999999999),8 )

[Gustavo_Eduardo]

Thank you Mark

[scott_robinson]

=MID("abcdefghijklmnopqrstuvwxyz",INT(RANDBETWEEN(1,26)),1)&DEC2HEX(RANDBETWEEN(0, 4294967295),8)

The difference between mine and Marc's formulas is that mine forces sheets to treat the generated ID as a TEXT value in every cell.

I noticed (too late) after adding a random ID to over 10000 records and generating child records with them that sometimes the other formula generated numbers defined as scientific notation which changes how sheets sees them.

It took a lot of time to track down the errors I can tell you!  This might save you that time for many thousands of records.

[Gustavo_Eduardo]

Gracias Scott! buenas Tardes para tí

[Joseph_Seddik · Accepted solution]

Another one 🙂

This is the exact equivalent of what's generated by AppSheet's UNIQUEID():

DEC2HEX( RANDBETWEEN(1; 4294967296); 8 )

[Gustavo_Eduardo]

Aplauso!

[Gustavo_Eduardo]

I am stuck with this solution. It allows you to create records outside of appsheet and then update the app with unparalleled speed and accuracy. Thanks once again to everyone who has commented.

[SkrOYC]

For reference:
Manually generate UNIQUEID() key values - AppSheet Help

Also, the usage of "," or ";" depends on your locale

[Joseph_Seddik]

";" works for all 🙂

[SkrOYC]

Nah, it really depends on your locale.

In my case I've seen that even Excel Online vs Desktop has different separators 👨🏼‍💻

[Joseph_Seddik]

Yes you are right and it would depend also on the program used. I don't have Excel actually, I should have clarified that it works for all locales in Google Sheets. 

[Gustavo_Eduardo]

Buenos aportes. Si alguien puede dejar la fórmula para google sheet para generar el UNIQUE("PackedUUID") le marcaré como solución 😉 gracias amigos.

Good contributions. If someone can leave the formula for google sheet to generate the UNIQUE("PackedUUID") I will mark it as a solution, thanks friends.

what about this?

CONCATENAR( CARACTER(ALEATORIO.ENTRE(65, 90)),CARACTER(ALEATORIO.ENTRE(97, 122)), CARACTER(ALEATORIO.ENTRE(48, 57)),CARACTER(ALEATORIO.ENTRE(65, 90)), CARACTER(ALEATORIO.ENTRE(97, 122)),CARACTER(ALEATORIO.ENTRE(48, 57)), CARACTER(ALEATORIO.ENTRE(65, 90)),CARACTER(ALEATORIO.ENTRE(97, 122)), CARACTER(ALEATORIO.ENTRE(48, 57)),CARACTER(ALEATORIO.ENTRE(65, 90)), CARACTER(ALEATORIO.ENTRE(97, 122)),CARACTER(ALEATORIO.ENTRE(48, 57)), CARACTER(ALEATORIO.ENTRE(65, 90)),CARACTER(ALEATORIO.ENTRE(97, 122)), CARACTER(ALEATORIO.ENTRE(48, 57)),CARACTER(ALEATORIO.ENTRE(65, 90)), CARACTER(ALEATORIO.ENTRE(97, 122)),CARACTER(ALEATORIO.ENTRE(48, 57)), CARACTER(ALEATORIO.ENTRE(65, 90)),CARACTER(ALEATORIO.ENTRE(97, 122)), CARACTER(ALEATORIO.ENTRE(48, 57)),CARACTER(ALEATORIO.ENTRE(65, 90)) )