Hi @Joseph7, great use case!
I mention a very similar solution in Leigh’s post here.
In your Clients table, include the following fields:
- Prefix (short text) - a prefix for the client (e.g. ACM)
- Current ID (number) - defaults to 0
- Next ID [equation] -
{Current ID} + 1 - Padding (short text) - contains three conditional rules:
- Next ID [equation] is less than 10, set to
0 - Next ID [equation] is less than 100, set to
00 - Otherwise set to blank
- Next ID [equation] is less than 10, set to
- Next ID (text formula) -
{Prefix}-{Padding}{Next ID [equation]}
You can use the same principle in my video in the other post to then update the Case with the next available ID, and then update the Current ID field back in the Clients table.
Let me know how you go!