function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mmccauleymmccauley 

Formula Hyperlink Question

Hello,

I have a link i'm trying to build and bring in two custom fields.

 

The link looks like this: http://intranet.msdsonline.com/Cambridge/Hanover/Orders/CSValet.aspx?Action=Edit&OID=155651&OIID=157856

 

OID= order_id__c

OIID= order_item_id__c

 

When i build out the link it looks like this HYPERLINK("http://intranet.msdsonline.com/Cambridge/Hanover/Orders/CSValet.aspx?Action=Edit&OID=" &Order_ID__c &OIID= Order_Item_ID__c,"View Order")

 

The above syntax says that OIID field is not found.  How can I get around this?

 

Thanks,

Mark

Best Answer chosen by Admin (Salesforce Developers) 
SporterSporter

OIID is not a literal part of your formula so salesforce is checking for a field value instead of just usnig the text for OIID, try:

 

 

HYPERLINK("http://intranet.msdsonline.com/Cambridge/Hanover/Orders/CSValet.aspx?Action=Edit&OID=&" & Order_ID__c & "& OIID=&" &  Order_Item_ID__c,"View Order")

 

 

All Answers

SporterSporter

OIID is not a literal part of your formula so salesforce is checking for a field value instead of just usnig the text for OIID, try:

 

 

HYPERLINK("http://intranet.msdsonline.com/Cambridge/Hanover/Orders/CSValet.aspx?Action=Edit&OID=&" & Order_ID__c & "& OIID=&" &  Order_Item_ID__c,"View Order")

 

 

This was selected as the best answer
mmccauleymmccauley

Thanks!  A little modification and I got it to work!  Thanks for your help!