Automatically create sequential Invoice numbers

 Hello,

Airtable already has a field for this it is called “Autonumber”, create a new field in your table and scroll all the way down in the list and select “Autonumber” as the field type, you could also search for this as well.

Thanks anthonyXRay. I was thinking about  f I could use it but did not know how. I appreciate the quick response. 

Vadim_Ciobanu - I tried your idea and it worked as you stated it. Yay! Now, one little quirk. I have over 140 invoices already and I do not want to lose the numbering I have. Can the autonumber be made to start at a particular point and go forward. So I would start at 5925 and go forward and that woulds let me number the next invoice as 6073.

Otherwise I will have to create a deprecated invoice number field to cross reference with what the customers already have.

I look forward to your response.

Many thanks to you both , Scott

Airtable increments the autonumber even if you delete a record.  That is to say, if you have:

1

2

3

And you delete record 2 and add a new record, you’ll end up with:

1

3

4

And so to solve your problem you can just add records to your table until the next record is 6073, and then delete those helper records