@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?
Explain what is the use case of this?
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,โฆ
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |