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 multiple users to get a unique random number at the same time I think the safest bet for a short and unique random number would be some kind of mathematical logic that uses the date and time in combination with a number generated from part of a user’s name and a global num…

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

Shorter row IDs?

Related topics