I’m currently creating barcodes from the RowID, but the ID is so long the barcode becomes difficult to scan. I’m looking for a way to create unique codes that are no more than eight characters. These codes will be used for user barcodes. Any ideas?

[image] Row ID alternative Ask for Help I would think that RANDBETWEEN could always have the potential to return duplicates and would constantly change, unless you are somehow building in logic to save that random value…and even then, it would have to somehow allow multipl…

I personally use the first letters (function left()) in Google sheet and check if there is a match on sheet or sometime textjoin with significant data in the row. The solution by @Jeff_Hager is great too. Marco

Shorter row IDs?

Ask for Help

Jeff_Hager July 16, 2021, 8:25am 2

Topic		Replies	Views
Row ID alternative Ask for Help	8	498	July 16, 2021
Generating shorter unique ID for every user Ask for Help	25	4614	July 8, 2024
Generate Unique Random Words per User Ask for Help	6	87	October 25, 2024
Need unique 9-digit number to compile into longer ticket ID Ask for Help	3	244	July 23, 2024
Generate registration ID Ask for Help	11	2003	March 4, 2024

Shorter row IDs?

Related topics