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

Topic Labels: Data Formulas
1401 4
Showing results for 
Search instead for 
Did you mean: 
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
7 - App Architect
7 - App Architect

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

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:

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



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:


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

thx again 🙂