Thursday, February 6, 2014

Generation of custom Project IDs without programming

Some people love numeric IDs. It is easier to reference things using short tags like “Project 15” instead of long descriptive names.

However, Project Server uses GUIDs instead of numeric IDs to identify entities. Surely, it is done for good reasons, but GUIDs are rarely useful for human beings. We really prefer simple and short numbers.

Assigning a unique ID to project is easy – just create a custom field for it and track it manually, ensuring proper formatting and uniqueness of the number. Sounds easy, but… We are not in the Stone Age, right? There must be a better way doing that.

There is a way to do it. With our product - FluentPro Formulas for Project Server 2013 (version for Project Server 2010 is available too) it is just as easy as writing the following function on the Edit Custom Field screen:


Done! All new projects will receive a sequential number upon creation. Existing projects will get the number on the next update.

But what if just sequential is not enough? Let’s say we need to make it look something like PR_1, PR_2 and so on?  In this case, expression can look like this:

                ‘PR_’ + NewID()

What if we don’t want to start numbering from 1 and need to start from 1000? Here is what we can do:


Need to increment by 10 instead of 1?

                NewID(1000, 10)

But what if we don’t want to use the same sequence for all projects and prefer to have different sequences for different EPTs?

                NewID(1, 1, [Enterprise Project Type ID])

Of course, there is no restriction to use EPT in this context – it can be any custom or native field.

Last but not least: if you have not more than two fields with FluentPro Formula – the tool is free.

You can learn more about FluentPro Formulas on our website - 

Solution Starters for Project Server 2013

Our team migrated Solution Starters for Project Server 2010 to the Microsoft Project Server 2013 platform. We are distributing Solution Starters for Project Server 2013, free of charge, available for download with source code and with wps, ready for deployment. Please note - solution starters are available as-is, free of charge and FluentPro Software Inc, FluentPro Software Corporation are not responsible for any direct and indirect damage. Please try / install solution starters at your own risk.

Available Solution Starters for Project Server 2013:

  • Bulk Edit Tool
  • Excel Project Cost Capture
  • Programs
  • Project Workspace List Viewer
  • Report Builder Tool
  • Workspace Project Custom Field Web Part

We are happy to provide commercial support for Solution Starters. We can help you with all your needs in regards to the Solution Starters:

  • Deployment of Solution Starters to your servers
  • Troubleshooting of Solution Starters deployment
  • Customization of Solution Starters
  • Adding new features to the Solution Starters functionality

You can download solution starters from our website - .

Enjoy!