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
Peter Russell 9Peter Russell 9 

What formula should I put to populate a custom URL in a URL field which pulls values from other fields?

Hi, I need to populate a field on an opportunity automatically with a web address that pulls values from other fields in the opportunity into the string

Here is the URL I need to replicate, what should I put in the formula to update the url field??

http://www.reviews.co.uk/store/landing_new_review?store=immigrationa-dvice-service&user={!Contact.FirstName}&order_id={!Opportunity.Case_Reference__c}&email={!Contact.Email}&products={!Opportunity.Service_sold__c}&type=combined&rating=5"

thanks in advance
Tanmaya kumaer samalTanmaya kumaer samal
Hi Peter,

Create a formula field with dataType as Text.
Paste the below in formula editor, 
HYPERLINK(“http://www.reviews.co.uk/store/landing_new_review?store=immigrationa-dvice-service& user={!Contact.FirstName}}&order_id={!Opportunity.Case_Reference__c}& email={!Contact.Email}&products={!Opportunity.Service_sold__c}&type=”combined”&rating=5")

Please update the field with respect to proper relationship.

Best Regards.