Document numbering

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

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

Any help will be welcome.

Thanks
SDionne

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.

1 Like

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

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.