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
Rung41Rung41 

Hyperlink Formula + URL Hack

Is it possible to use a URL hack in a hyperlink formula? I am trying create a custome link that only certain profiles can see but I am running into syntax issues. 
IF(CONTAINS($Profile.Name,"System Administrator"),
HYPERLINK("/006/e?="
&accid=Account.Id
&RecordType=012a0000001ZSiy
&ent=Opportunity
&opp3=New Sale
&opp11=New
&opp9=TODAY()+30
&retURL="&Account.Id
, "Create New Opp" )," ")
SahebSamantaSahebSamanta
Hi,

This can be done. there are some syntax error in above formula. use the formula in following way 

IF(CONTAINS($Profile.Name,"System Administrator"),
HYPERLINK("/006/e?=&accid="+Account.Id+"&RecordType=012a0000001ZSiy&ent=Opportunity&opp3=New Sale&opp11=New&opp9="+TEXT(MONTH(TODAY()+30))+"/" +TEXT(DAY(TODAY()+30))+"/" +TEXT(YEAR(TODAY()+30))+"&retURL="+Account.Id, "Create New Opp" ),
" ")

Also try not hardcode the RecordType Id and specify some returl.