Created this formula on the Activities object to show what object the activity relates to but getting issues.
IF(LEFT(WhatId,3) = "","",
IF(LEFT(WhatId,3) = "001", "ACCOUNT",
IF(LEFT(WhatId,3) = "002", "NOTE",
IF(LEFT(WhatId,3) = "003", "CONTACT",
IF(LEFT(WhatId,3) = "006", "OPPORTUNITY",
IF(LEFT(WhatId,3) = "007", "ACTIVITY",
IF(LEFT(WhatId,3) = "00K", "OPPORTUNITY CONTACT ROLE",
IF(LEFT(WhatId,3) = "00P", "ATTACHMENT",
IF(LEFT(WhatId,3) = "00Q", "LEAD",
IF(LEFT(WhatId,3) = "00T", "TASK",
IF(LEFT(WhatId,3) = "00U", "EVENT",
IF(LEFT(WhatId,3) = "010", "CASE SOLUTION",
IF(LEFT(WhatId,3) = "015", "DOCUMENT",
IF(LEFT(WhatId,3) = "02Z", "ACCOUNT CONTACT ROLE",
IF(LEFT(WhatId,3) = "500", "CASES",
IF(LEFT(WhatId,3) = "501", "SOLUTION",
IF(LEFT(WhatId,3) = "701", "CAMPAIGN",
"OTHER")
))))))))))))))))
After i assign it to the relevant profiles and page layouts i get an error saying:
Unable to Access Page
The value of a parameter contains a character that is not allowed or the value exceeds the maximum allowed length. Remove the character from the parameter value or reduce the value length and resubmit. If the error still persists, report it to our Customer Support team. Provide the URL of the page you were requesting as well as any other related
information.
Any ideas on how to resolve this or what this means?
That's wierd. I haven't seen anything like that. Anyways you can optimize the Formula like as Vinay mentioned but with a small fix -
CASE(
LEFT(WhatId, 3),
"001", "ACCOUNT",
"002", "NOTE",
"003", "CONTACT",
"006", "OPPORTUNITY",
"007", "ACTIVITY",
"00K", "OPPORTUNITY CONTACT ROLE",
"00P", "ATTACHMENT",
"00Q", "LEAD",
"00T", "TASK",
"00U", "EVENT",
"010", "CASE SOLUTION",
"015", "DOCUMENT",
"02Z", "ACCOUNT CONTACT ROLE",
"500", "CASES",
"501", "SOLUTION",
"701", "CAMPAIGN",
"OTHER"
)
I really doubt if that would fix it but worth a shot.
If that doesn't work I would suggest you to get in touch with the Support ASAP.
