How to generate random unique id

[Soufiane_M]

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

[Steve · Accepted solution]

Try:

 LEFT(UNIQUEID(), 5)

or:

 RIGHT(UNIQUEID(), 5)

[Soufiane_M]

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

[Steve]

I’m afraid I don’t understand.

[Soufiane_M]

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

[pex]

Hello!

Try

LEFT([ID]&[DATE]), 5)

OR

RIGHT([ID]&[DATE]), 5)