I am trying to pass parameters in hyperlink url of formula field, but I am getting field names instead of it's values.

HYPERLINK("https://testwebsite.com/v2/search/{!Case__r.Product__c}?jt=1&jv={!CustomObject__r.C_ID__c}", "Website Link")

Please let me know how to pass Case__r.Product__c and CustomObject__r.C_ID__c.

1 Answer 1


Try using something like this:

HYPERLINK("https://testwebsite.com/v2/search/" & variable1 & "?jt=1&jv=" & variable2, "Website Link")

The & character is used to concatenate String. You can replace variable1 and variable2 with your variables. You don't need to write their values by hand, you can use the Advanced Formula and click the Insert Field. From there you can browse your custom object's fields and it's related object's fields.

  • 1
    Thanks Charis. It worked great.
    Commented Apr 4, 2019 at 14:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .