function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
MelliottMelliott 

Help with Hyperlink Code

I need help with a hyperlink formula Here is the code that I have currently HYPERLINK("https://tapp0.salesforce.com/a0w/e?retURL=%2Fa0w%2Fo1N%2Fhome.jsp&00NT0000000mLaW= Group_Number__c ","Create Provider Carrier") Unfortunately, it pulls Group_Number__c into the field instead of the value from the list. This field is on a custom related list on a custom object.
MelliottMelliott
Okay, I figured out the first issue, now trying to add more fields and not having much luck...Fun Fun. 
MelliottMelliott
I have the syntex working; however, it doesn't pass the value from the picklist or the look up fields. It will only pass the text fields. Any idea on how to get it to pass the picklist and the look up fields. HYPERLINK("/a0w/e?retURL=%2Fa0w%2Fo1N%2Fhome.jsp&00NT0000000mLaW="&Group_Number__c&"&00NT0000000mLaA=Carrier__c"&"&00NT0000000mLa9=State__c"&"2F01IT000000006dg=Name" ,"Create Provider Carrier")
TehNrdTehNrd

First, this is forum is for Apex Code.

I'm not sure what you are trying to do is possible. With picklist you can only use the ispickval and case functions. See this idea: http://ideas.salesforce.com/article/show/43022/The_ability_to_retrieve_a_picklist_value_in_a_formula_field

You can't currently pull the values over. I think the same goes for lookups. I might be wrong so maybe someone else can confirm.

mtbclimbermtbclimber
I am moving this thread to the formulas discussion board on successforce.