Forcing Enterprise Custom Field to be Unique

I

irish_archer68

Hello everyone, happy Monday!

Does anyone know of a way to force an Enterprise Custom Field to be
Unique? I.e. - if a custom field is a Project ID. Is there a way in
Project Server to Force the field to be unique. I think I know how to
in SQL Server but would like to enfore in proejct Server. Please
advise.
 
P

Paul Conroy

Create a new table in the project server database with a column that is
auto-incrementing.

Write a macro in the before-save sub which creates a new row in the above
table, then extract that value and populate the custom field.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project 2010: Predecessor Name Display 0
Enterprise Custome fields 3
2016 Project, adding a workday to custom field 0
Custom PWA fields show no data in PWA 4
Enterprise Custom Fields stored in Database? 6
After change Custom Enterprise Field not passing to Portfolio 0
Enterprise Custom Field overwriting Local 1
Enterprise Custom Fields 1

Top