Reset Auto Number for each hardware version

[Adrian_Boo]

Hi!

I have an alarm rent business and I am building an ERP with Airtable to manage stock of devices, kits and availability.

One thing I want to do, is to create unique ID reference for each kit (a kit have some devices) and for each device. This reference is a concatenate of words and numbers.

For example, for kits I want to use the version and the number dependent on each version, and when the version change, the autonumber start again in 1. Ex:

Kit Version A
Kit number 0001
Kit ID: A0001

Kit Version A
Kit number 0002
Kit ID 0002

…
I want to automate this, when I manually change the version, the kit number (autonumber) reset automatically to 0001 again:

Kit Version B
Kit number 0001
Kit ID: B0001

So I have a column to name the version, and have other column to autonumber, but I need to make a formula to restart the autonumber each time that I manually change the version.

Do you think is it possible?

This is the example base:

My example base

[Justin_Barrett]

This is definitely possible, and I created a Show and Tell topic (and example base) demonstrating the setup:

Automatic Sequential Numbering of Non-Sequential Items (READ JUN 9 2021 FOLLOW-UP) Show and tell

Summary This setup allows Airtable to automatically number collections of items that may not be in sequential order. Item length can be either fixed or variable, with only minor changes needed to the core system to accommodate the latter. Example To borrow from the thread that inspired this endeavor, say you’re building product codes that have a variant sub-code, and want that sub-code to automatically increment each time an item of a given product code is added in a new record. However, it n…