+Aleksi Alkio I understand that UNIQUEID() au...

@Aleksi_Alkio I understand that UNIQUEID() autogenerates an 8 length id, can I edit it in such a way that I have an user defined identifier before the uniqueID, For example: 0001_UNIQUEID(). How can I make this happen?

0 4 368
4 REPLIES 4

Explain what is the use case of this?

Mike_A
Participant V

Rather than just UNIQUEID() could try:

Concatenate(โ€œ0001_โ€,UNIQUEID())

Orโ€ฆ use a virtual column as a counter and do Concatenate([counter],โ€œ_โ€,UNIQUEID()) CONCATENATE - Docs editors Help support.google.com

thanks guys @Mike_Adler

@Fernando_Lopez, I am doing this so that every uniqueID generated can be identified in case I need to generated unique for more than 1 system. So 0001 means system 1 there will be 0002, 0003,โ€ฆ

Top Labels in this Space