Create new Record and increase number by 1

[sehenley]

Hi

In my base I have a very simple table, the records primary field is a number, each new record is the previous number plus one. All the other fields are formulas or links to other tables that fill in automatically. 

Each week I need to create a new record in this table at a given time, I want to do this with an automation. I want to find the most recently created record (not recently updated as other fields will update at different times) find the name of the record +1 to it and name the new record that value. Is this possible? Maybe with a script, which is a bit beyond me. I can't seem to figure out a way to do it. 

Thanks for the help.

[jwag]

Hi Sehenley,

There's a field type called Autonumber which may work for you. You can then set this as your primary field.

It's worth noting though that if you create a record and delete it, it will still be counted and your next record will skip that number.

There will be a way to do it with some extra fields and an automation but I'm not sure off the top of my head.

Cheers,

Josh