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)?

Attribution to: George Piumatti

Possible Suggestion/Solution #1

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.

Attribution to: George Piumatti

Possible Suggestion/Solution #2

ok. In case of saved record you can use any field from the same object in formula. E.g.

'http://www.ourURL.com/applications/DMSRouter/3596560' & 'Doc_number__c' in formula text.

This should give you the required link.

Attribution to: AtulRajguru9

Possible Suggestion/Solution #3

Assuming that "3596560" is the dynamic document ID, and that you want a clickable link rather than just text of a URL, your formula would be:

HYPERLINK("DMS Link","http://www.ourURL.com/applications/DMSRouter/" & Doc_number__c)

Attribution to: Thomas Taylor
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/34340