Yes - we use this all the fine for record names.

Our solution may not be the most elegant you get but here it is

1: create a column called autonumber. - this will start a count at the first record of one

2: decide where you want the record number to start - let’s say 900000

3: create a formula that adds the relevant number to your field - so you get a record called 900001,900002 etc - let’s call this customer number

4: the tables name field is another formula - concatenation - so for Employee records concatenate(“employee”, {customer number})

Step 2 and 3 are optional but I like having the same


Length fields and it needs a starting number high enough to make this happen.

Hi, thank you.


I’ve got it to work, and agree a bit clunky.

Pity i couldn’t set the character length to the ‘autonumber’ to ‘0000’ and then it would work quite well

While it would be nice if the autonumber field type would allow for varying lengths, this could be done with a formula field:

RIGHT("0000" & Autonumber, 4)

Autonumber defaults to 1, 2, 3, 4 and there's no way i can see to edit it.

Nevermind, i'll just do it in Excel since its a new table