Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 06, 2023 05:32 AM
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?
Jan 06, 2023 11:58 PM
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
Jan 10, 2023 06:20 AM
But then I would need to create a new Table for every year which sadly messes with my automations.
Jan 11, 2023 10:24 PM
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?