Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Our experts will be answering your questions starting TOMORROW at 8 AM PST!

Project Number Help

Avatar

Level 2
We've been using the reference number for a project as an identifying job number since our implementation. This was working OK--but after only 6 months in, the number is already 6 digits long, so we're on the hunt for another solution. Does anyone have any recommendations on how you populate job numbers that don't require a manual effort?
26 Replies

Avatar

Level 5
Polly/William, Completely agree! Not mutually exclusive. If Workfront were to poll all their marketing/creative companies- I bet 99% of them use job#'s. Might be considered old school, but job#'s are ingrained in how we do business! When we were vetting project management systems- and I asked about job#'s- they said "yes"(which turned out to be the ref ID #) we can do that- and I didn't press any further because it was such a basic functionality that most other project management systems for creatives possess. It NEVER occurred to me press for more details in the sales process. We currently have a work around- but it's NOT ideal by any means. I was extremely disappointed. Just adding my two cents. tks Karen Karen Rutz Harvard: Alumni Affairs & Development

Avatar

Level 9
It does seem peculiar that Workfront read your request as a rollback of existing functionality rather than a request for something new. Perhaps they simply feel that two unique identifiers (GUID and Reference Number) are plenty for any object, and they don't want to create more overhead with a third one. Lots of different use cases were presented in this thread for identifiers in various forms. (We too had a custom-built project identifier, but we decided to scrap it when we transitioned to Workfront, as we could handle all that information via reporting and custom data fields. The executives needed some persuading, but we are totally accustomed to 7-digit reference numbers now. For us, the number is important only for its uniqueness.) My suggestion for those who want "special" sequential job numbers is to use the API to auto-create your own special brand of job number and then populates it into a custom field. Or perhaps Doug Den Hoed at the AtAppStore already has a solution that can do something like this...? ~Eric Eric Manning Language Line Translation Solutions

Avatar

Level 3
The numbers are sequential example of the last 8 that have been entered this week (most recent to oldest). There are gaps in the the numbers but they are sequential and you can determine around the time the project was entered by the year and month. AT1808857 AT1808824 AT1808793 LS1808654 PP1808322 VP1808275 PA1808223 UD1808197 Tamara O'Brien Integrated Marketing Communications

Avatar

Level 10
I believe a lot of us are doing that of some sorts - trying to make do with what Workfront currently have. Or for some, looking at other workflow solution that would accommodate this - as they say, for marketing and creative, this is an important number. Most of us believe should be a BASIC in a workflow solution that targets marketing and creative. Polly Co

Avatar

Level 10
While I understand that may be the case for smaller generation of reference numbers, you should also see that in terms of sequential numbering that it can fail when you've switch to the next thousand generating a lot of reference data across all objects eg let's say in the next month 1809 your reference number is already at 1998. So 1809998 next project could possibly be 1809020 not easy at a quick glance which one was project went ahead first. The only way to possibly make it work to avoid this is to increase the reference numbers to 4-5 depending on the assumption/risk on how often you'd generate more reference numbers. Polly Co

Avatar

Level 10
Thanks for the call out Eric, We do indeed have an answer for "just so" project numbering: our UberCalc solution, which does that and then some. That said, for the BASIC type of simple, sequential numbering that Skye identified, I've asked the elves in the workshop to see what we might be able to whip up, for those who simply need that lightest touch. Stay tuned. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads