Jan 25, 2023 04:46 AM - edited Jan 25, 2023 04:47 AM
I am trying to simplify the record ID function output as I don't need a complex unique ID.
- 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 😉
Jan 25, 2023 06:17 AM
This function will return the first 4 digits of the record ID:
Jan 25, 2023 06:24 AM
thank you but unfortunately it's not what I am looking for as it generates duplicate solution 😕 (cf picture attached)
Jan 25, 2023 07:50 AM
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:
Jan 25, 2023 09:12 AM
Smart - that's a solution indeed - thx
will leave this post open in case there are other ideas.
thx again 🙂