Coincidently error start after we cancelled our premier customers account..
I tied differents tools available: Data Loader, DataLoader IO, DataLoader Cliq
' make sure id list has no blanks
Dim i%: For i = 0 To UBound(idlist)
Debug.Assert idlist(i) <> "" ' bad things ...
Set Retrieve = sfApi.Retrieve(sels, entityType, idlist, False)
' NOTE, the query result may be more than 2000 long, in which case
' we probably would miss something, ouch...
' TODO find out if this is happening ?
Public Function ProcessQueryResults(ByVal qr As QueryResultSet3) As Object
I installed this App successfully in my dev org, but when I repeat the process in my client's Production Org, clicking the 'Find Nearby Accounts' link opens the VF window, but then I get an empty dialog box, and no results.
The batch Geocode Accounts function works fine.
I have de-installed, repeated the setup process, but same results.
How would you create a Formula field to calculate amount of days in the next month. So for example the calculation/value of this formula field should equal "31" since next month has 31 days (August).
Any help would be great.
I'm new to sfdc and this community, but we are loving what we've seen so far.
I have what I suspect is a pretty easy report to generate, I just can't figure it out for myself.
We would like to see a report that figures the percentages on our Mass E-mails.
- % of X Mass E-mail that were opened
- % of X Mass E-mail opened more than 3 times
Is this simple?
Thanks in advance!
for the life of me I cannot get this to work. I have a custom formua field call SIGNAL. Based on the YES or NO value in another field called Past_Due_Check_c I want the SIGNAL field to display a RED or GREEN image. I continue to get syntax errors in the code as show below. Driving me crazy. can anyone help?
Is it possible to search on more than just the "Standard" field in a custom object when relating an email to that object. If you set the object name field (Service name in the illustrated example, attached) to an Auto Number then end users need to know that number to relate email to it. This is problematic as they may not have that number readily available or even have SF open. The alternative is to use "Text " as the type for the object name which requires them to name each record in that object. The look up in Outlook Connect may be a bit simpler as they can search on text that they probably are more familiar. This becomes a problem as many of these objects are added and it becomes hard to distinguish between them.
Neither solution seems to work well (unless there is a way to search on multiple fields from within Connect)
IF(AND((5 - (CASE(MOD( Start_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 5, 2, 5, 3, 4, 4, 3, 5, 2, 6, 1, 0)) < (CASE(MOD( End_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 0, 2, 1, 3, 2, 4, 3, 5, 4, 6, 5, 0)) ),
((( End_Date__c - Start_Date__c ) + 1) < 7)),
((CASE(MOD( End_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 0, 2, 1, 3, 2, 4, 3, 5, 4, 6, 5, 0)) - (5 - (CASE(MOD( Start_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 5, 2, 5, 3, 4, 4, 3, 5, 2, 6, 1, 0)))),
(((FLOOR((( End_Date__c - Start_Date__c ) - (CASE(MOD( Start_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 6, 2, 5, 3, 4, 4, 3, 5, 2, 6, 1, 0))) / 7)) * 5) +
(CASE(MOD( Start_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 5, 2, 5, 3, 4, 4, 3, 5, 2, 6, 1, 0)) +
(CASE(MOD( End_Date__c - DATE(1900, 1, 6), 7), 0, 0, 1, 0, 2, 1, 3, 2, 4, 3, 5, 4, 6, 5, 0))))
The Start Date and End Date fields are custom in the above example and can be replaced as required. If use of a DateTime field is required then the DATEVALUE function will be required.
I also recommend a simple field validation rule is added to check that the End Date is after the Start Date.
HELP!!!!!!!!!!!!!!!! Very novice technology user just about to throw laptop out the window:-)
Have downloaded and installed the above App (it is listed in my 'Packages Installed from the App Exchange' list), but no 'Map Nearby Accounts' button is showing up on the Accounts Page. Any ideas what I need to do?
sorry if this has already been posted.
I am working on the Customer Service part of Salesforce.
When logging Cases, the system should calculate a due date based on the SLA and on the Customer Service Center Calendar (meaning, without holidays, bank holidays, week-ends, etc.).
Since there are no standard feature to enable this feature, I have been told this is feasible through Apex.
I'm pretty new in the Apex world: I've done some developments, but nothing too fancy, so if you could help me out on this one, I would really appreciate.
Not mentioning I'm sure it's the kind of issue Customers face all the time...
Thanks in advance,
Opportunity Name Percent Field Amount Services
TOTALS: 124% $111,000.00 $23,000.00
Opportunity A 16% $75,000.00 $12,000.00
Opportunity B 76% $11,000.00 $5,000.00
Opportunity C 32% $25,000.00 $6,000.00
Is there a way to have an actual percentage total on a custom report rather than a sum? Average doesn't really do the trick either. At the top where it says 124%, it should really say 20%. 23,000/111,000=20%
All the percentages are doing here is adding 16+76+32 to equal 124 which makes no sense when you are talking about percentages.
This problem seems easy to fix. Am I missing something?
But after that whenever I am trying to configure the Salesforce Mobile application, I am getting struck in the screen showing: "Device info has been sent to salesforce.com and is awating registration".
It is not proceeding any further. Any help?