URL in Enterprise Custom Text Field Formula

[Dan Keen]

Our company has a legacy system that is used to track IT requests. Each
request has a unique ID, which I currently track in Project Server in an
Enterprise Project Number field. To make it easier for users to get to the
details of the request, I'm trying to create an Enterprise Project Text field
that concatenates the number field with some static text that contains most
of the URL information. I then want to display the URL in a Project view in
PWA so users can just click on the link to bring up the details.

Seems simple enough, but the field shows "#ERROR" when I try to view it in
the Project Information dialog in MSP. I've tried both of the following
formulas for the Enterprise Project Text Field:

"http://<static URL info>" & CStr([Enterprise Project Number1])

"http://<static URL info>" & Str([Enterprise Project Number1])

I was able to do something similar in a custom field in Issues, and was
hoping I could do it within Project as well.

Any suggestions?

We're using Project Pro 2003 SP1 & Project Server 2003 SP1.

 

[Dan Keen]

Some additional info....

The static URL info has the form:
"http://<servernameortnumber>/im/viewissue?mode=detail&selection=".
Appending the ID number from the enterprise number field should complete the
URL. Is is possible that the ampersand in the static portion is being
interpreted as a concatenation, even though it's enclosed in double quotes?