Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Create new Record and increase number by 1

Topic Labels: Automations
1641 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