0

Projects

Hello. I have a main table called projects and a sub table for my submittal log and i want to know how i can autogenerate submittal numbers? They are 3 digit and every project starts at 001

 

my submittal table has the following columns:

 

Submittal Tile: Text

Submittal #: Auto Number

Date: 

Status: Combo (Approved/Declined)

1 reply

null
    • Support
    • 5 yrs ago
    • Reported - view

    Hello, 

    I have already invited you to the Webinar EN 2018 team. Please accept the invitation in order to get access to the team and the database. 

    In the team you will find a database "17_Automatic Numbers" where exactly this scenario is shown for "Table A" and "Table B". The formula is inserted in "Table B" in the option "Trigger on create". In order to get a number with leading zeros you have to use a text field for the Auto Number.

    Best, Jörg

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1340Views