I would like to be able to have a field that is either my SKU number, PO number, Sales order number that escalates as entries increase. In Excel I’d just pull down the cell and it would sequence as I go along. I can do that it seems only with a number field. But the number field doesn’t allow me to start with 00001, 00002. I’d have to change to a txt field but then it seems Airtable only wants to copy the cells over and over, not sequence them.
Is there a work around either as a number field or a text field to get what I want?