Q:

Dynamically construct field of type URL from fixed +  elements

I have a field defined as a url, however the URL is actually made up of a standard URL to our document managment system and the document number which is what the user enters.  How do I get the formula for this field to concatenate the standard URL part with the 6 character number field the user types in which represents the document nuber to be retrieved from our system?  So in the end the URL looks like 
'http://www.ourURL.com/applications/DMSRouter/3596560'  Where the number at the end is what the user types into the field.  I am trying to use the concatenate function but how do I reference the current value of the field (ie the numebr part)?

A:

Actually there is a way - using a workflow rule. The workflow rule can update the field that triggers it. So by using this formula in the update step of the workflow rule I get a close to deisred effect;
"http://www.ourURL.com/applications/DMSRouter/" & right(Trim(DMS_Number__c),7)
However the editing experience could be prone to typos as the edit window only shows the 1st 3rd of the field and the user has to navigate to the end of the line to change the number.

