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?
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?
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