I have a formula field where I create a link using HYPERLINK. I want one of the parameters in the url to be encoded. So I tried to use URLENCODE. But I get an error that URLENCODE is not allowed in a formula field.

My formula (field type is Formula (Text)):

HYPERLINK('http://foo.com?bar=' + URLENCODE(Bar__c))

Error:

Function URLENCODE may not be used in this type of formula (Related field: Formula)

It seems like a perfect fit to use URLENCODE to encode parameters for use in HYPERLINK. Am I missing something?

I can use SUBSTITUTE and do the encoding myself, but I am trying to see if there is a better way.

Thanks,

VV

I have a formula field where I create a link using HYPERLINK. I want one of the parameters in the url to be encoded. So I tried to use URLENCODE. But I get an error that URLENCODE is not allowed in a formula field.

My formula (field type is Formula (Text)):

HYPERLINK('http://foo.com?bar=' + URLENCODE(Bar__c))

Error:

Function URLENCODE may not be used in this type of formula (Related field: Formula)

It seems like a perfect fit to use URLENCODE to encode parameters for use in HYPERLINK. Am I missing something?

I can use SUBSTITUTE and do the encoding myself, but I am trying to see if there is a better way.

Thanks,

VV