For every user in my user-profile table i want the user to be associated with a “short” 6-8 character unique code ( read as affiliate ID ) which can be used by new users as referral. a. I initially thought of using the unique username the user registers with to be used for this purpose but i do giv…

I believe an arrayformula with some string manipulations here works best. To keep it 6 characters you can possibly use the first 6 characters of the rowID (using LEFT), last 6 characters of the rowID (using RIGHT) or include the row number in there. Tell me how you want it to be, I will construct t…

[image] ThinhDinh: Tell me how you want it to be, I will construct the formula for you. @ThinhDinh I am fine with the first 6 characters. But how do i ensure that this column gets populated only when there is a new entry in the users table? The moment we say formulas we are talking about GSh…

A few different approaches discussed here: [image] Auto Numbering Ask for Help How to setting auto numbering that appear with a new order submit by a form button? Example, i have 3 form submitted. i need the first submitted form showing: 0001 - “form result; …” 0002 - …

[image] Darren_Murphy: A few different approaches discussed here: :exploding_head:

@Darren_Murphy @ThinhDinh Kind of did a bit of reading and came up with this ={"Code";ARRAYFORMULA(IF(A2:A="","",DEC2HEX(RANDBETWEEN(0, 9999999), 6)))} Now this generates a 6 digit code BUT Its giving same value for all rows - which is bizzare ! And every refresh of the sheet or deletion or ad…

For your use case I would steer clear of a spreadsheet solution and instead use the Glide computed columns approach that I offered in that other thread. The problem with the spreadsheet solution is that values will change if a row is ever deleted. With my approach, the values are locked in once the…

[image] Darren_Murphy: With my approach, the values are locked in once they are set. The only downside is that you have to “kick start” it by setting the first value manually. @Darren_Murphy Yes i get that - i can probably use something like a serial number and then use the forumula you have …

@Darren_Murphy You meant this one ? [image] Auto Numbering Ask for Help Here is how I would do it: [Screen Shot 2020-12-28 at 5.43.18 PM] “Padding” is just a simple ITE… [Screen Shot 2020-12-28 at 5.43.32 PM] So putting all that together, 4 columns required: Roll…

Sorry, I was on my mobile just now, so a bit fiddly to provide a direct link. This is the approach I’m referring to: [image] Auto Numbering Ask for Help Here is how I would do it: [Screen Shot 2020-12-28 at 5.43.18 PM] “Padding” is just a simple ITE… [Screen Shot 20…

A bit of playing with the formating ( in spreadsheet ) and came up with this UniqueID Its def not random and but its definitely Unique. Might not be the solution that i wanted or will use. But something easy to achieve for testing purpose on the sandbox. [Screenshot 2021-05-29 at 5.40.09 PM] I t…

Generating shorter unique ID for every user

Ask for Help

Darren_Murphy May 29, 2021, 10:21am 4

A few different approaches discussed here:

Topic		Replies	Views
Generate registration ID Ask for Help	11	2003	March 4, 2024
A nice trick to make unique codes in Glide (without GSheets) Project Showcase	6	633	May 12, 2021
Row ID alternative Ask for Help	8	498	July 16, 2021
Generate a Unique Code based on User's Email Ask for Help	19	185	October 4, 2024
Auto Numbering Ask for Help	58	7720	April 18, 2025

Generating shorter unique ID for every user

Related topics