Generating Unique ID while create a new Project in Project Server

Oct 22, 2013 at 1:30 PM
Hi All,

I want to create a custom field which will fetch data from SQL server from some table, instead of manually entering the data into lookup table and assign it to custom field. Instead of fetch data from either lookup table, or manual entry, I want to write the sql query and associate the result with project server custom field.

Also I want to create a custom field (task/resource/project type) which have Identity/ unique number generated with prefix/suffix to it whenever we create a new item. EPM1PS, EPM2PS...

It would be great if anybody can get some information on this.