Help

How to Limit the number of character of the record ID fct ?

Topic Labels: Data Formulas
863 4
cancel
Showing results for 
Search instead for 
Did you mean: 
jmepok
4 - Data Explorer
4 - Data Explorer

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 😉

4 Replies 4
bruceconsulting
7 - App Architect
7 - App Architect

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)

jmepok_0-1674656637127.png

 

bruceconsulting
7 - App Architect
7 - App Architect

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 🙂