Skip to main content

Hi everyone,

 

I am trying to simplify the record ID function output as I don't need a complex unique ID. 

2 solutions:

- Is it possible to limit the record ID function to 4 maximum digits ? 

- Is there any other function that will generate a unique ID composed of 4 digits with the random choice of number and/or letters ?

Thank you 😉

This function will return the first 4 digits of the record ID:

LEFT(RECORD_ID(),4)
There isn't a function I can think of to produce random choices, you would have to look for a script.
If you have any further questions, I would be happy to help. Feel free to book some time with me using my Calendly link:  https://calendly.com/bruce_consulting/30min

This function will return the first 4 digits of the record ID:

LEFT(RECORD_ID(),4)
There isn't a function I can think of to produce random choices, you would have to look for a script.
If you have any further questions, I would be happy to help. Feel free to book some time with me using my Calendly link:  https://calendly.com/bruce_consulting/30min

thank you but unfortunately it's not what I am looking for as it generates duplicate solution 😕😕 (cf picture attached)

 

How about creating an autonumber field and concatenating it with the above formula.  This should give you an unique 4 digit number for each record:

CONCATENATE({AutonumberFieldName},LEFT(RECORD_ID(),3))

How about creating an autonumber field and concatenating it with the above formula.  This should give you an unique 4 digit number for each record:

CONCATENATE({AutonumberFieldName},LEFT(RECORD_ID(),3))

Smart - that's a solution indeed - thx
will leave this post open in case there are other ideas.

thx again 🙂

Reply


Terms & Conditions