Document numbering

[Sylvain_Dionne]

Hello everyone,
I use Airtable to manage projects and elements (Balcony, Terrace, Stairs, Separator Screen) in projects. I look for a method to automatically create drawings numbers. Indeed in elements table I have a link to projects table and for each element I create a drawing. I want drawings numbers drawing like this:
ProjectNumber-ElementCode-Number
the numbers is reset for each different element in same project.
Example:
Project1-Balcony A-01
Project1-Balcony A-02
Project1-Terrace X-01
Project1-Terrace X-02

Project2-Balcony A-01
Project2-Balcony A-02
Project1-Terrace X-01
So, as you see, the numbers at the end are reset for each element in same project, and reset between project.
Can someone help me?
Thanks
SDionne

[Sylvain_Dionne]

Hello, no one has an idea or a solution track?

Any help will be welcome.

Thanks
SDionne

[Btbml · Accepted solution]

In the past week or so I remember seeing someone’s solution for exactly this.

Edit- I should say that I just saw the post, I haven’t looked at the base and I haven’t tried it either.

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…

[Sylvain_Dionne]

it’s very interesting, I will check that with attention.
Thanks Btbml for your answer
SDionne