Ask Search:
Howard LubingerHoward Lubinger 

I want to create a button for certain opportunity record types that would create a new case with the specific ID of 012340000007mPs.

The Opportunity Record Types I would like this to impact are:

Also, if I could carry over a link to the Account Name, Opportunity Name and Opportunity Owner that would be great.

Any ideas?



Best Answer chosen by Howard Lubinger
Puneet MehtaPuneet Mehta
The code should be:

var opptyObj = new sforce.SObject("Opportunity"); 
var caseObj = new sforce.SObject("Case"); 

caseObj.Opportunity.AccountId = "{!Opportunity.AccountId}"; 
caseObj.Opportunity__c = "{!Opportunity.Id}"; 
caseObj.recordTypeid = '012340000007mPs';

var caseresult = sforce.connection.create([caseObj]); 

if (caseresult[0].success=='false') 

alert("Case creation failed: " + caseresult[0].errors.message); 


alert("A Case has been created and linked to this Opportunity."); 

and make sure that on the profile of the end user has API enabled checkbox is checked and the profile has permission to create Case.

Also check the API name og lookup field on Case that means 
caseObj.Opportunity__c = "{!Opportunity.Id}"; 
will change to
caseObj.API_NAME_OF_YOUR_FIELD_HERE = "{!Opportunity.Id}"; 
Lori AndersonLori Anderson 
I'm trying to query off of Last Modified Date and I've tried two different formats and got unsatisfactory results. I want to look at Tasks where the Last Modified Date was prior to August 1, 2009.

I tried putting the date in these two formats:
* 08/01/2009
* 2009-08-01

Neither one works as expected. I can't find documentation on the Data Loader to help me. Can anyone help?

Best Answer chosen by Moderator ( 
Carmen HymesCarmen Hymes
 I hope this response isn't coming too late, but I struggled with this as well.  The Apex data loader allows you SOQL statements to pull data - therefore you have to use date formats that SOQL statements will use.

here's a quick example, but there are so many options, you should really check out the guide.  I included a link under my example:

FormatFormat SyntaxExample
Date onlyYYYY-MM-DD1999-01-01
Date, time, and time zone offset
  • YYYY-MM-DDThh:mm:ss+hh:mm
  • YYYY-MM-DDThh:mm:ss-hh:mm
  • YYYY-MM-DDThh:mm:ssZ
  • 1999-01-01T23:01:01+01:00
  • 1999-01-01T23:01:01-08:00
  • 1999-01-01T23:01:01Z

here's a link to the guide:
Ashish kumarAshish kumar 

I have created a workflow below and it is only triggering when it meets all of the criteria, what do I need to change in the filter logic to meet this requirement below. 
  • Where Interest field is equal to Benchmarks or Certification AND employee count is less than 5000 AND revenue is less than $1B
  • Lead Source Details Equals “2016 Benchmark Report
  • All leads below 200 employees or Below $50 M in revenue
User-added image
Best Answer chosen by Ashish kumar
Mayank SrivastavaMayank Srivastava
Should it work when any of those bulleted statements are true? If that's the case, use this:
(1 AND 3 AND 4) OR 2 OR (5 OR 6)
Pat McAbeePat McAbee 
I need to create a report that will show all accounts that have not had any sales in the previous 12 months. Any help would be much appreciated.

Best Answer chosen by Miglena ( 
James GarfieldJames Garfield
Hey Pat,

If you are looking for a report to show accounts that havent had activity in the last 12 months you can just replicate the below screen shot. Just run the report based on accounts. When you say sales within the previous 12 months are you saying that there is an activity stored for this? 

Best of luck!
User-added image

I dont have any accounts w/ activities later than that date but if I did they would appear!

James SJames S 
Does anyone have any good practices for a SF database when it comes to risk management. For example if you have a very engaged or high profile customer and the risk of loosing them is high or a less engaged customer would mean the risk is low in loosing them. 

Does anyone do this? Just wanted to know what anyone does with this on SF in regards to risk. Best practices, how to set the SF database up to alert when a good customer is being lost etc. 
Best Answer chosen by James S
Nitish SinghalNitish Singhal
Hi James,

You may need to write a workflow rule with certain conditions which denotes your good customer being lost. Along with workflow, you can write an email alert to be sent out once workflow condition is true. 

If there are more complicated conditions, then you can also use Process Builder. 

Best Regards
Deanna AaronDeanna Aaron 
Hi. Currently, the Sales Path in the Lead Layout is not customized for our business. It says, DNC > Lead > Marketing Lead > Needs Vitals etc.. The VP of Sales wants it to say "Untouched > Pursuing > Qualified > Unqualified. How can I change the default labels?  

Thank you to those of you who take the time to respond! 
Best Answer chosen by Deanna Aaron
Mayank SrivastavaMayank Srivastava
Hello Deanna,

The Sales Path guidance labels on the top are deriving their names from the Lead Status picklist values on the Lead Object. As far as I know, the only way to change those labels would be to change the picklist value labels in the Lead Status field.

If the Untouched > Pursuing > Qualified > Unqualified stages represent the status of a Lead throughout its lifetime, then why not change the Lead status picklist items to reflect the same?
Gaby WangGaby Wang 

I need  to re-assign multiple leads from user A to user B, I know how to do this on the saleforce classic version but when I was trying to do the same thing on the Lightening version, I couldn't find any button related to "change owner". I only saw "change status" and "add to campiagn". Wondering what the problem is. Thanks!

Best Answer chosen by Gaby Wang
Pruthvi RajPruthvi Raj
@Gaby: Unfortunately, You "Change Owner" on List view is not available in Lightning as of now. Please upvote this Idea, Add "Change Owner button" to Lead List view in Lightning ( It is available on the record's detail page. But if you want to re-assign for multiple Leads in One go then it is not possible in Lightning.
Erik PetersonErik Peterson 
my VP of National Sales wants t obe able to see how his regional sales staff is interacting with the sales groups.  He wants to measure conference calls, emails, one on one training, etc.  I'm thinking that having the Regional Sales managers set tasks for all interactions with Sales would do the job, but wasn't sure if there's a better way.  the VP might also want to be able to see the sales person's specific activities.
any suggestions are appreciated.
Best Answer chosen by Erik Peterson
Steve MolisSteve Molis
I would start by casting the widest net possible, and that would probably be an Activity Report Type: Tasks and Events  
That will give you any Activity(Task/Event) record logged in SFDC no matter who or what it is related to.  
That will give you a sense of the landscape, and from there you can tighten things up with Filter Criteria, or a more Focused Activity Report Type.
Andrew DahlkemperAndrew Dahlkemper 
A few days ago our SFDC has started getting spammed with new leads. After trying a bunch of things we found that turning off Web-to-Lead solved our issue. The only issue is that we don't even have any forms created, and have never to my knowledge. Once I turned it off I get these emails ever couple minutes (70 and counting for just one day):


"Salesforce could not create this lead because of the reason listed below. For more information about this error or help with Web-to-Case-Lead, please contact Customer Support.

Reason: We could not create this lead because Web-to-Lead has been disabled for your organization.

Please have your administrator enable the Web-to-Lead
interface for your organization by going into My Setup at the top right
of any page.

    OID: <my org id>
    UID: 005G0000003qAoK
    Lead Capture Page: Not available.

Record Information:

    00NG0000009aj6X = Newsletter Requested on <my company>
    email =    "

I've tried going through the HTML in our website cntrl-f'ing for any hints at the web-to-lead code  (  <form action= "" method="POST"> )   but haven't been able to find anything.

Any ideas how this can be happening or how I can turn it off / change the 'code' being used to link whatever form to my org?
Best Answer chosen by Andrew Dahlkemper
Patrick SullivanPatrick Sullivan
It sounds like someone got the unique ids for your org to create the records via API. The easiest way to block them is a validation rule that rejects those leads, then use an email rule to just put those emails in some other box. 
Lakshmi KumarLakshmi Kumar 
Hello all,

I have a question regarding multi-select picklists and checkbox. I need to know the pros and cons of using either multi-select picklist and checkbox. My client does not recommend using multi-select picklist as they are worried of reporting. Hence they are sticking to checkboxes because of reporting. 

I recently heard that in Spring/Fall 2016 there were few updates that were implemented to multi-select picklist. I am not quite sure though. My client has asked me regarding the best practices either to implement multi-select picklists and checkbox. 

Can anybody suggest me based on the above scenario what must be implemented either the multi-select picklist or checkbox?

Thanks a lot !!!  
Best Answer chosen by Lakshmi Kumar
Mayank SrivastavaMayank Srivastava
Lakshmi, whatever updates were made to the MSP's wouldn't make them any better or qualify them for use. A few cons of using them:
  • ​MSP's suck for reporting
  • Pose challenges for merges
  • Pose challenges for automation like workflow rules, process builder
  • Pose challenges for formula writing
The checkbox approach would be much better because then you get proper reporting and flexibility with automation as well. You coud always use the following article to come up with a good case for not using the MSP's and going with checkboxes or a custom object instead:

Good luck!