Invoice going up

[idan_bernard]

how can i make a field of invoices thats starts from 1000 and goes up?
like
1001
1002
1003?

im kinda stuck, much appriciated! :grinning_face_with_big_eyes:

[JonathanBowen · Accepted solution]

Hi @idan_bernard - have a field that is an autonumber:

Then make your primary field a formula and use:

1000 + AutoID

You can hide the AutoID field if you don’t want to see that.

Worth noting that if you delete a record, you also delete the autonumber associated with it, so that won’t then be available:

JB

[idan_bernard]

thank you so much jonathan, is there any chance i can ask you a couple Airtable questions in email or whatsapp?
i really need to do a small task for a job application it will be so much appriciated.
thank you so much.