0

Number Questions

I have a main "Projects table" that i have a relationship with my "Punch List table" and want to generate auto number but add the "Id" from the "Projects Table" Currently i have the auto number working but want to generate this way . ID.Number . (Example 033-001)

I currently have no items in my Punch List - RFI - or Submittals so if i should change my data it is not a bid deal.

 

Thanks in advanced

2 replies

null
    • russhenry715
    • 5 yrs ago
    • Reported - view

    Currently "On Create" i have the following code that is kinda working. The only issue is i want the number to reset to 1 for every project

     

    let y := year(Completed);
    let c := cnt(select Punch where year(Completed) = y);
    'Punch Item No' := format(c, "000")

    • Birger_H
    • 5 yrs ago
    • Reported - view

    The information is not really sufficient.

    You can book a screensharing session with me via this link:
    https://calendly.com/birger-hansen/15min

    Birger

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1772Views