Workfront Program Unique ID - How To

Question

In our previous system, each "campaign" had a unique number assigned to it.  The numbers grow by 1 with each campaign created.  In Workfront, the Programs have IDs, but they are alphanumeric and very long.  Ideally we need to create an auto-generated number that can be used to help search and track the Program.  Something along the lines of a 5-digit number that can grow as our number of Programs increases.  Is there a way to create a calculated field that will produce this or use Fusion to assist?  Thank you for any assistance!

ChrisStephens · Accepted Answer

You could for sure do this with Fusion, a couple of different ways. Would it just be broadly within the system, every program just iterates by 1? Or you could bespoke it for certain parts of the number mean certain things, i.e. a couple of character could signify portfolio, you could include the year in the number, etc.

If it's just counting up, then there's multiple ways, but here are two ways you can do that.

1. When a new program is created, search for all programs, get the largest number, and add 1 for the new program2

2. Create a datastore that tracks used serial numbers, and on program creation, check your datastore for the largest number and add 1. This would mitigate a risk in option 1, where if someone were to delete out the program with the highest number, on the next program creation that number would get re-used.

skyehansen · Answer

I don't think there's anything in workfront, so am moving your question over to fusion. Initially I can suggest that if you go to your Fusion "Templates" section and do a quick filter for the word "sequential" I see a setup scenario that adds a custom form and fields to your instance, and then a scenario to sequentially number programs, projects, and so on. I'll leave it to the experts to suggest other things.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded