You need to sign in to do that
Don't have an account?
Lloyd Ruz
Custom Links (using Contact Fields) in a Formula (Text) HYPERLINK () field
Is it possible to pull through a merge field to the HPYERLINK formula in a Formula (Text) field?
The link works in as a custom link/button eg. www.website.com/form?pa0={Contact.Email} - however this same link does not pull through the field, but treats the field merge it as text when used in a Formal (Text) fields as: HPYERLINK (www.website.com/form?pa0={Contact.Email}).
Any help ont his would be much appreciated.
The link works in as a custom link/button eg. www.website.com/form?pa0={Contact.Email} - however this same link does not pull through the field, but treats the field merge it as text when used in a Formal (Text) fields as: HPYERLINK (www.website.com/form?pa0={Contact.Email}).
Any help ont his would be much appreciated.
HYPERLINK( "www.website.com/form?pa0=" & Email, 'ImHyper')
above Email is field from where you want to fetch the value,
'ImHyper' is just friendly name you want to show instead of whole url