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.