Alphanumeric RecordID

lledl

Hi,

I want to assign Record IDs to my record like starting from AB1 to AB1000032.. How do I do it in alphanumeric style

Thank you

Best Practices

Accepted answers

MarqueeCrew

RECORD ID
1. STRING
2. Starting Value 1
3. Length 6
SELECT
1. Change TYPE to VString and adjust length to 8 (or more)
Formula Tool
1. Update your RecordID with the following code:
2. ```
"AB"+[RecordID]
```
Have a cup of coffee...

Cheers,

Mark

All comments

MarqueeCrew

RECORD ID
1. STRING
2. Starting Value 1
3. Length 6
SELECT
1. Change TYPE to VString and adjust length to 8 (or more)
Formula Tool
1. Update your RecordID with the following code:
2. ```
"AB"+[RecordID]
```
Have a cup of coffee...

Cheers,

Mark

ebirckholtz

Hi Mark,

I found your response very helpful.

Do you know of any other ways to create an alphanumeric string? I was able to follow the first two steps to create the numeric half of the RecordID. However, I'm unsure how to assign a unique alpha ID.

Ideally I'd like the RecordID to be "AB011111", "AC011112", "AD011113" etc.

Do you know if something like this is possible?

Thanks for any help!

Elizabeth

LordNeilLord

@MarqueeCrew wrote:
4. Have a cup of coffee...
@MarqueeCrew Does it have any impact on the process if you do 4 first?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703