Every time a user creates a client I want to assign a sequential number of 10 digits with this formatting starting always by a 500… For example:
First client: 5000000001 (10 digits)
Second client: 5000000002 (10 digits)
Client number ten: 5000000010 (10 digits)
Client number eleven: 5000000011 (10 digits)
… the list can grow up to a thousand or maybe more.
I think there are two possible workarounds, one is with workflows and the other is with field initial content. I rather not use workflows because of the workflow count.
I found out to do it with a do a search for “clients”, “last item” “+1” but I don´t know how to maintain the 10 digits because if you put something like 5…9 (10 digits) the next one will be incremented by a number 10 at the final causing a 11 digits.
Thanks a lot.