I was using "CASE" fine (see below) until this additional criteria became necessary:
CASE( Fund__r.Name , "CCV", 1, "CCVet", 1, "DFE", 2, "DFF", 2, "DF", 2, "DR", 3, 99)
If it's a DR, it ALSO has to have a Appeal_Campaign__r.Name that starts with "Paws".
I have tried CASE and IF and am unsuccessful with both, getting this compound condition for "3"
Here's what I need (I'm doing this in a Workflow) (summarized a bit here)
IF FUND_Name = "DR" AND Appeal_Campaign__r.Name Starts with "PAWSTR" then the value should be 3
IF FUND_Name = "DF", then the value should be 2
IF FUND_Name = "DFF", then the value should be 2
the value should be 99.
And here's what I was trying to get started:
(AND(Fund__r.Name="DR", Appeal_Campaign__r.Name BEGINS("PawsitivelyStrong")),
I thought I'd build on that, but I get Error: Syntax error. Found 'Appeal_Campaign__r.Name'
I sure do hope someone can help!
Thank you -
I've been trying to use the Excel Connector for the last two weeks to manage the data in our organisation, but I'm having a problem where I get the following error in Excel which is preventing me from using this tool:
Error Generated by request::An internal server error has occured while processing your request. Url:https://www.salesforce.com/services/Soap/c/13.0 ExceptionCode : 5103
The first couple of times I tried to use Excel Connector it worked fine. However I then started seeing this error every time I tried to use it - the error appears after I put in my password in Excel Connector and click Login.
We are on Salesforce Professional. I have tried uninstalling and reinstalling the toolkit and connector, but it hasn't made a difference. I'm using Excel 2010 32-bit on Windows 7 64-bit.
I can log in to Salesforce in my browser on the same computer.
I've checked that IE is not in Offline Mode, and verified that Excel can actually connect to the internet (pinged a URL using VBA script).
I've tried disabling my antivirus (MSE) and windows firewall.
I've tried changing the server url as suggested by this thread (had to modify registry keys to do this as that field was not editable in the connector.
None of these resolutions worked.
Has anyone experienced and managed to resolve this, or can anyone suggest any other possible resolutions?