Help

Create new Record and increase number by 1

Topic Labels: Automations
392 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sehenley
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1
jwag
6 - Interface Innovator
6 - Interface Innovator

Hi Sehenley,

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

Screenshot 2023-10-13 at 09.57.04.png

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