Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Document numbering

Topic Labels: Formulas
Solved
Jump to Solution
1068 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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.

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