You need to sign in to do that
Don't have an account?
Formula Hyperlink with Case() function?? Is it possible?
So, im working on a fun new formula, I need to pass the case owner queue to a field for tracking the previous queue (so eventually I can assign the case back to the previous queue).
here i my code, anyone know if you can even use the CASE() function and imbed it into a formula hyperlink? My assumption is no... because it all works fine until I add the case function towards the end.
I'm 3 IF statements deep, and 3 hyperlinks down...
=-)
help?
--------------------------
IF(
AND(
$RecordType.Id = "01270000000UIP9",
TEXT(Status) = "New"
),
HYPERLINK(
"/" & Id & "/e" &
"?save=1&cas7=In+Progress" &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&00N70000002mRCJ=1" &
"&00N70000002nL0N=Demand+Support" &
"&CF00N70000002nFlU_lkid=" & $User.Id &
"&CF00N70000002nFlU=" &
$User.FirstName &
"+" &
$User.LastName &
"&retURL=%2F" & Id ,
"Audit Complete", "_top"
),
IF(
AND(
$RecordType.Id = "01270000000UIP9",
TEXT(Status) = "Verification Sent"
),
HYPERLINK(
"/" & Id & "/e" &
"?save=1&cas7=Verification+Approved" &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&00N70000002mSII=1" &
"&00N70000002nL0N=Finance" &
"&CF00N70000002nFlU_lkid=" &
Assigned_To__c &
"&CF00N70000002nFlU=" &
Assigned_To__r.FirstName &
"+"& Assigned_To__r.LastName &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&retURL=%2F" & Id ,
"Verification Complete", "_top"
),
IF(
AND(
$RecordType.Id = "01270000000UIdz",
TEXT(Status) = "New"
),
HYPERLINK(
"/" & Id & "/e" &
"?save=1&cas7=In+Progress" &
"&00N70000002nL0N=AQ+Team" &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&CF00N70000002nFlU_lkid=" & $User.Id &
"&CF00N70000002nFlU=" &
$User.FirstName &
"+" &
$User.LastName &
"&retURL=%2F" & Id ,
"Assign AQ", "_top"
) & " | " &
HYPERLINK(
"/" & Id & "/e" &
"?save=1&cas7=In+Progress" &
"&00N70000002nL0N=Demand+Support" &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&CF00N70000002nFlU_lkid=" & $User.Id &
"&CF00N70000002nFlU=" &
$User.FirstName &
"+" &
$User.LastName &
"&retURL=%2F" & Id ,
"Assign DS", "_top"
) & " | " &
HYPERLINK(
"/" & Id & "/e" &
"?save=1&cas7=In+Progress" &
"&00N70000002nL0N=PubCare" &
"&CF00N70000002nFlK_lkid=" &
"&CF00N70000002nFlK=" &
"&CF00N70000002nFlU_lkid=" & $User.Id &
"&CF00N70000002nFlU=" &
$User.FirstName &
"+" &
$User.LastName &
"&00N70000002nR4X=" &
CASE(
OwnerId,
00G70000001gZs6, "AQ+Team",
00G70000001gXEd, "Demand+Support",
00G70000001gNNJ, "PubCare",
00G70000001gaX4, "Finance",
00G70000000yVZx, "Ad+Network+Signups",
00G70000001Knit, "Ad+Ops",
00G70000001hHzo, "Demand+Support+%2D+EU",
00G70000001gYpk, "Demand+YM",
00G70000001hIPS, "EOM+Audit",
00G70000000yVZL, "Event+Signups",
00G70000000yIqu, "Info+Signups",
00G70000001gpkT, "MyAds+Unassigned",
00G70000001KjAt, "New+Leads",
00G70000000yVZs, "Publisher+Signups",
00G70000000zweK, "Self+Service+Support",
00G70000001gPDr, "Stats+Team",
00G70000001Kmjk, "Unassigned",
"") &
"&retURL=%2F" & Id ,
"Assign Pub", "_top"
),
"")
))
nevermind my issue was the case values were not all covered in quotes... stupid mistake.
hi!
can you tell me wats wrong whith dhis syntax:
{!CASE( monnaie ,Euro, 'euro' , 'NOT-Euro') }
i geting: syntax erorr
Than'x.