Project Names/ #s
I want to do a couple of things: I want to auto number our projects - is there a way to do so? I also want to create a field for a project name that is a combination of 4 other fields and autofill...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe best was is to leverage the built in [Record ID#] field. But please please don't rename that field. Just make a formula numeric field called [Project #] and make the formula
[Record ID#]
Or if you want another numbering scheme like 0001. 0002. 0025 etc like leading zeros there are easy ways to do that formatting.
As for the Project Name field you just make a Formula field such as
List(" ", [Project Name Entry] , "#" & [Record ID#], [Division], ToText(Year[Project Start Date]))
The result would be like
OakPines #123 Foundations 2025
Or if you want another numbering scheme like 0001. 0002. 0025 etc like leading zeros there are easy ways to do that formatting. <-- I would like to start at 111001 and would like to sequentially increase from there. I assume you still would suggest using a formula numeric field named Project #? If so, what would that formula look like?
RE: Project Name field
If I wanted to use Project Number, Customer Code, Jobsite City, Jobsite State fields - the correct formula should be the below?
List([Project Number] , [Customer Code], [Jobsite City], [Jobsite State]))
Result?
11101 MWL City State