How to generate random unique id

Hi friends , HOW TO GENERATE RANDOMomly UNIQUEID with only 5 caracters instead of 8 caracteres given by default ??

Try:

 LEFT(UNIQUEID(), 5)

or:

 RIGHT(UNIQUEID(), 5)
1 Like

works perfect , what in case to combine between “ID” and “DATE” that UNIQUEID/TODAY

I’m afraid I don’t understand. :confused:

I use “concatenate” function to combine ID and DATE thank you Steve :slight_smile:

1 Like