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