Looking at previous records to count up a number

[Jonielele]

Hello everyone, 

I am trying to automate project numbers in Airtable. For this year I have used autocount to get a rising number of project IDs. My problem now is that for every new year, I want to reset this count. 

So for example the last project in 2022 had the ID 22-105 and the first one for this year should be 23-001.

My logic for this function was

If [previous_record_date_year] == [current_record_date_year] {
   [current_record_number] = [previous_record_number] +1
} else {
   [current_record_number] = 1
}

Is there a way to implement it that way or am I thinking too lazy?

[TheTimeSavingCo]

I would argue that you're not thinking lazy ENOUGH!  If I were you I'd just make a new `Autonumber` field for this year instead hahahah

[Jonielele]

But then I would need to create a new Table for every year which sadly messes with my automations.  

[TheTimeSavingCo]

Ahh, yeah fair enough.  And I take it you want all of your projects to be in a single table, if not you'd just duplicate the table, use the duplicate as the archive, and clear out the main one

I reckon if I had a Pro account I'd just script it, and if not I'd link all the projects to a single helper record and use a "Count" field with an automation to paste that count value into the project's ID?