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	520	July 16, 2021
Generating shorter unique ID for every user Ask for Help	25	4686	July 8, 2024
Generate Unique Random Words per User Ask for Help	6	132	October 25, 2024
Need unique 9-digit number to compile into longer ticket ID Ask for Help	2	263	July 16, 2024
Generate registration ID Ask for Help	10	2038	April 9, 2020

Shorter row IDs?

Related topics