autonumber field - docket numbers | Community
Skip to main content
New Participant
March 9, 2017
Declined

autonumber field - docket numbers

  • March 9, 2017
  • 26 replies
  • 3834 views

When we create projects, we would like it to be easily identifiable by a docket number, something sequential eg 17-xxxx and should increment only by the specific object type eg Project. Unfortunately, the only available autonumbering available on Workfront is through all objects, meaning if I have 2 projects created, this could be 17-ABX1 and 17-1257 because of all objects created in between. We need this number to be sequential to the object only.

26 replies

New Participant
November 20, 2018

Being a new Workfront user and just working through Implementation, I am disappointed with the lack of numbering and even more so with their short sightedness of having a more diverse customer base than they had years ago. Very unfortunate.

New Participant
August 27, 2018

We have a work around but this would be much better for us.

We add the year to the front of the Project Number, so our reference is P18_______

We could reuse the same sequential numbers every year and just change to the Year at the front. Love this idea!!!

New Participant
August 21, 2018

@Anna - that totally makes sense! Yet, what people are looking for is essentially a calculated field that counts up from 1, with maybe some minor additional functionality (such as setting the base number, # characters, and a set of leading characters or numbers). We need both a backend system of truly unique IDs and a more rudimentary system that is easy for anyone to reference.

Workfront users and admins will definitely make mistakes using a more basic numbering system - guaranteed (myself included!), but it's still something that is easily available on other, similar systems. Again, keeping the 32-character Unique ID system will guard against major issues. Please reconsider!

PollyCoAuthor
New Participant
August 21, 2018

LOL, community's down and it's sending reference ids for every refresh.

Reference ID: f5a6df72-a54a-11e8-b815-0a4ccd35c2c7

Reference ID: 144f7024-a54b-11e8-9d38-0a4ccd35c2c7

Can you imagine XX years from now, what possible reference numbers you'd be looking at on Workfront ?

ellen_gilmore
New Participant
August 21, 2018

I hope that WF will reconsider. We leverage the project reference number as a primary key to search for all of our projects. With the current volume of objects this number will grow exponentially and will become unreasonably long. Our only other option is to pursue a customized code generator or purchase Fusion.

PollyCoAuthor
New Participant
August 21, 2018

I agree. I'm pretty sure there's more use to setting up a field with unique sequential numbers. It's disappointing to see Workfront's reply to this. We're not asking them to remove the current use of their reference number as I'm sure some users are already using it because they had no other recourse but to use a 6 - 8 alphanumeric code that had no rhyme or reason as it relates to the object.

New Participant
August 21, 2018

I'm surprised at the official reply to this, why not have a unique field that auto populates a unique sequential number for projects within a particular group/request queue. The existing numbering system creates very long numbers over time which we have to concatenate and join with other information to create something (hopefully) unique. There's no need to remove the existing system, this would be an addition to it.

PollyCoAuthor
New Participant
August 20, 2018

@Anna Asaytryan - 4 years ago, your user base may have been different from what it is now. There must be a way for us to have an autonumber field - maybe by calculated fields of some sort, not necessarily permanently attached to the object like the current reference number.

New Participant
August 20, 2018
Thank you for your interest in this request. We used to have the numbers generated based on the objects, but we got requests from several customers that it was creating problems due to reference numbers not being unique. The requirement was to have unique reference numbers even within different object types. As a result we changed the logic, so it won't make sense for us to change it back. We apologise for causing inconvenience on your side.
ellen_gilmore
New Participant
August 15, 2018

We were considering a customization to append a Job Number (year followed by a 5 digit sequential number, i.e. 18xxxxx) to end of the project name so that it can be visible at all times. Each year we would start the 5 digit sequence over again.

Now that it is under consideration by WF perhaps we will wait and see their solution.