• sandeep sankhla
  • PRO
  • 2707 Points
  • Member since 2015
  • Enterprise Solution Specialist
  • UST Global


  • Chatter
    Feed
  • 81
    Best Answers
  • 1
    Likes Received
  • 3
    Likes Given
  • 6
    Questions
  • 955
    Replies
I want to know  the difference between a dependent lookup, required lookup filter and optional lookup filter, i found them in many salesforce tests and i don't know the difference between them.

Thank you
I have custom object that needs to be linked to Opportunities, for pre-sales, and to Accounts, for post sales.

I would like to be able to add the count of this custom object into the header of the Opportunity or Account. I see that a roll-up summary field is only available if I have a Master-Detail relationship between Opportunities and my custom object.

Are there any ideas out there or has anyone done that before with success?

I’m trying to create a lookup between two custom objects were there is a matching account number field. I would like to create a trigger on ObjectA that says: Whenever ObjectA is created or edited, search ObjectB and see if a record with the same account number exists. If a record exists, take the ID from ObjectB and insert it into the matching ObjectA record as a lookup field. I have been at this for a while and am at a loss. I am very new to APEX and any assistance in pointing me in the right direction would be greatly appreciated.
Hello,

I create a free salesforce account. 
Salesforce give me a dev environment.

For unlimited duration:
1) Will i be able to create public websites from that ?
2) Or will i be able to give acess to 100 people to a small CRM application ?
3) In regard to above question, can i be able to give Salesforce1 acess to same people ?

Thank you
 
  • September 01, 2015
  • Like
  • 0
How can i achive the following req:

i have Account and Plan objects with mamy to many relationship and Accountplan as a Junction Object

and  Account obj with status field Active and inactive
and Plan obj with status field Active and inactive

If Account Status field is inactive then change all Account related plans status to inactive only if plan related all accounts are inActive.

.......... Could you Please help me out in this req.

Could you please give me a snopshot of code here...


Thanks in Advance....................
Is it possible to change Month Key field value to month year format?

ex.
201503 => March 2015
201401 => January 2014

I need it for REPORTS (x-axis) because 201401 format doesn't look good but I don't know if it can be changed and how to do it?
THX...
Hello All,

There are no classes and triggers on the production org and am moving the apex code for the first time. The deployment is constantly failing even if the code coverage is 79% in the sandbox. The reason is shown as code coverage in production is 66 %

I checked my classes and i haven't mentioned see all dtaa tru anywhere in the test class
Can anyone please help me solve this issue?
Hi,

I have a requirement for  insert trigger i need help on it


1) I have a custom object called as Suppressed Domain__c , where there are 2 fields like" Isactive" and "Domain"


2) I want to write a trigger for the below condition which i need help on it


a) If  "IsActive" is true then query contacts and leads with the same email domain

if records found(Yes)

there is another custyom object called as blacklist which i need to the following custom filds

set suppressed domain = true,
optout = true and
opt in = no opt in


if no records found , then set


set suppressed domain = true,
optout = true and
opt in = no opt in
email :temp dummy @dmain.com



kindly let me know how to achieve this with the code pls


Thanks in Advance
 
IF( Cancelled__c ,'Cancelled', 
 IF(Amount_Due__c = 0, 'Paid', 
  IF (OR((Amount_Due_Remaining__c <= 0),(Open_Balance__c + Amount_Due_Remaining__c) <= 0), 'Paid', 
    IF(Amount_Paid__c > 0,IF( Amount_Due_Remaining__c >0, 'Paid Partial','Paid'),'Open'))))
As we know, there is a limited number of custom field per object, even with Unlimited Edition as metioned here: https://help.salesforce.com/apex/HTViewHelpDoc?id=limits_general.htm&language=en_US
So, i would like to know if there is a way to have unlimited additional values per object? Could we consider to create a custom object that has something like a list of addtional attributes?
Any idea is highly appreciated.
Hi Developers,

I have product object and custom object(Designations__c). We have look up relationship between product and designation__c(Parent: Product, Child: Designation__c)
Fields:
On Product Object: Total Amount (Data Type:Currency)
On Designations Object: Amount(Data Type: Currency)

Now, The sum of amount of related designation records should not exceed 100 for an product record.

I want to applicable the functionality for Insert, Update and Delete operations.

Please help me out with the code.

Thanks,
Rocks

Hello,

        I am a novice in writing SOQL statements concerning Master Detail relationships. I would like to know how I need to write a SELECT SOQL statement on these:

Master object: Opportunity
Detail object: Quote
Child Relationship Name: Quotes
Field Name: Opportunity

Basically, I want to extract the Id from Opportunity and add it to the other fields of the Quote object in a single SELECT SOQL statement. How do I proceed? 

Regards, 
Vijay.

Is it possible to give someone transfer rights to a specific group of user's accounts/contacts/leads without using the role hierarchy?  
Just like Contacts is the name for the relationship between Contact and Account Object.
I need to perform a query which would fetch results from ObjectPermissions, PermissionSet and Profile
Hello,

I have a custom field TEXT__C   Date.
I set some date. its ok untill now.

From the backed i want to reset the date.
TEXT__C  =null; //no error but numm is displyed
 TEXT__C  =' '; //error saying string value cannot be set to date.

i want to set blank value to the date
Hi 
I  have requirement that we need to update a field on user object from custom object .Here we dunable to create lookup field to custom object from user object .


for example 

we have Qulification  field in custom object and also  there in User object

I want to update the Qulification  field value on  user object 


Please share your code if you have 


Thanks
 
I am not sure how to write a OnClick JavaScript custom close button on case object.

When the user clicks on this custom button, the following fields need to be updated with the given values.

Fields on case object:
Product Family = Unknown        
Product Model = Unknown
Problem Code = Non-Technical
Resolution Code = Spam
Status = Closed
Resolution Description = Spam
Account Name (lookup field) =  Unclassified Customer – Minnetonka 

Also need to associate the contact to the account; Unclassified Customer – Minnetonka


I appreciate the help!

Beth
Hi i just need to disable a buitton in a page and also know the difference between rendered and rerender attribute. Please give a clear answer with simple example. becouse i am new to salesforce.
Hi,

I have vf page and apex class where i am tracking the ols sub status value and new substatus in vf page

when i open my vf page i am getting the below error

Attempt to de-reference a null object
An unexpected error has occurred. Your development organization has been notified.


MY VF PAGE :
<apex:page standardController="Team_Form__c"  extensions="CycleTimeSubstatusCalulation" tabStyle="Team_Form__c" sidebar="false" showHeader="false">
    <apex:form >
        <apex:pageblock title="EMEA SaSu Cycle-Time"  mode="inlineEdit" >
          
           <apex:repeat value="{!gpsTeamForm}" var="gps" >
            <apex:outputText title="Initial sub-status :" value="{!gps.OldValue}"/>
            <apex:outputText title="New sub-status :" value="{!gps.NewValue}"/>
            <apex:outputText title="Cycle Time :" />
            </apex:repeat>
        </apex:pageblock>
    </apex:form>
</apex:page>

MY Apex class :

public class CycleTimeSubstatusCalulation{

    public  List<Team_Form__History>  gpsTeamForm {get;set;}
    public CycleTimeSubstatusCalulation(ApexPages.StandardController controller) {
        Team_Form__c tf = (Team_Form__c) controller.getRecord();
        list<Team_Form__History > tempList = [SELECT Id, CreatedDate, Field, NewValue, OldValue, ParentId
                                                FROM Team_Form__History
        
                                       WHERE ParentId = :tf.Id
                                                 AND Field = 'SubStatus__c'];
        if(tempList .size()>0)
        for(integer i=0; i<tempList.size(); i++ )
        {
         gpsTeamForm.add(tempList[i]);
        }
        
            //gpsTeamForm = tempList[0];
        else
            gpsTeamForm = new Team_Form__History();
    }
}

Hellp me what i am doing wrong here

Thanks in Advance
 
Hi All,

How to get rid of this error :
Incomplete or No Cache-control and Pragma HTTP Header Set

I am getting this error while scanning my lightning component from Zap tool..
Hi All,

Rich Text Area field null check

I have one custom field type of (Rich Text Area) , I have binded this on my VF page with input field..Now on click of one button , I want to validate if it is null or not..
How to check if it is null or not..I want page side validation..


 
Hi Guys, I am not much familiar with Lightning...

Can someone tell me if Lightning can help me to get the SF1 look and feel for datepicker , date, multipicklist...etc
Can someone help me in overriding the Salesforce1 date picker in my VF page ??

I am trying to get the salesforce1 datepicker look and feel in my VF page, which I am using as overriden page for Account..I want to get the same look and feel for date picker and date time picker...
I am facing the below issue while fetching the layout for account using SOAP tool. Kindly let me know how to solve this error. I have succesfully login via SOAP tool got the session id but while describing the layout I am getting the below error:

 
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:enterprise.soap.sforce.com">
   <soapenv:Header>
     
      <urn:SessionHeader>
         <urn:sessionId>Gau7XKaiaOertNGQf6UAkJiLTzNWDaW9TjrL6vq56kHRXC4yQpRj8_LLq3DZih2</urn:sessionId>
      </urn:SessionHeader>
   </soapenv:Header>
   <soapenv:Body>
      <urn:describeLayout>
         <urn:sObjectType>Account</urn:sObjectType>
         <urn:layoutName>Account Layout</urn:layoutName>
         </urn:describeLayout>
   </soapenv:Body>
</soapenv:Envelope>
*************************************************************************
Error:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <soapenv:Fault>
         <faultcode>UNKNOWN_EXCEPTION</faultcode>
         <faultstring>UNKNOWN_EXCEPTION: Destination URL not reset. The URL returned from login must be set in the SforceService</faultstring>
         <detail>
            <sf:UnexpectedErrorFault xsi:type="sf:UnexpectedErrorFault">
               <sf:exceptionCode>UNKNOWN_EXCEPTION</sf:exceptionCode>
               <sf:exceptionMessage>Destination URL not reset. The URL returned from login must be set in the SforceService</sf:exceptionMessage>
            </sf:UnexpectedErrorFault>
         </detail>
      </soapenv:Fault>
   </soapenv:Body>
</soapenv:Envelope>

Please reply in case you have solution .
Can someone help me in overriding the Salesforce1 date picker in my VF page ??

I am trying to get the salesforce1 datepicker look and feel in my VF page, which I am using as overriden page for Account..I want to get the same look and feel for date picker and date time picker...
Hi Everyone,

I have a query related to REST API url. 

I have exposed a REST API via Force.com sites, which will create record once the API is hit. I want to pass all parameters in URL. But, doing this i encounter following error:

[{"errorCode":"UNSUPPORTED_MEDIA_TYPE","message":"Content-Type header specified in HTTP request is not supported: application/x-www-form-urlencoded"}]

To resolve this how can i pass the required content type value in url or what's the alternate way to resolve this.


Regards
Nitesh

 
Hi All,

I need some clarification on when to go for standardcontroller and when to go for custom controller exactly in a vf page.I have a lot of confusion on this.Before designing a vf page how can we know that which controller to use?Can anyone explain me with examples?

Thanks in advance
Hi
I admit I am a novice to eclipse. I just installed eclipse and I created salesforce project plus given username, security token etc.

I want to perform the following:
a) create  apex class, trigger , visual force page
b) how to test the apex class in debugger
c) how to execute and see the result

pls guide me...

Thanks
pooja
Hi
How to integrate facebook with salesforce.please provide installation links for install facebook.
Thanks
The following is my trigger code i written test class for this, i coverd upto 80% i wand to make it 100% can you help me to fulfill this.

trigger createaccount on Contact (before insert, before update) {
string sp =' ';

if(trigger.isinsert && trigger.isbefore ){
    
    
//add error messages to select only accountid or checkbox
        for(contact con : trigger.new){
            if(con.accountid != null && con.Create_New_Account__c ==true){
            
                con.addError('Enter only account name or create account checkbox true');
                
            }
            if(con.firstname == null)
                con.adderror('FirstName is madatory');
                 
        }
        
}

    if(Trigger.isInsert && Trigger.isBefore ){    
        set<id> stid = new set<id>();
        list<contact>con=trigger.new;
        for(contact cn : con)
        {
            if(string.isnotblank(cn.Staging_ID__c) && cn.FirstName!= null && cn.LastName!=null)
            {
                stid.add(cn.Staging_ID__c);
                cn.firstname=cn.FirstName.subString(0 ,1).ToUpperCase()+cn.FirstName.subString(1);
               cn.lastname=cn.LastName.subString(0 ,1).ToUpperCase()+cn.LastName.subString(1);
               }
        }
        
        list<ProfileStaging__c> pslist = [select id , Profile_Created__c from ProfileStaging__c where id in : stid];
        for(ProfileStaging__c ps : pslist)
        {
         
            ps.Profile_Created__c = true;
            
        }update pslist;
    }
   
 
    if(Trigger.isInsert && Trigger.isBefore ){    
       
        
        List<Account> acclist = new List<Account>();
      
        Map<String,Account > accountMap = new Map<String,Account >();
        for(Contact c:Trigger.New){
         if(c.FirstName!= null && c.LastName!=null)
         {
        if(c.Create_New_Account__c == True){
       
        Account acc = new Account();
       // c.idmaping__c=c.id;
        
        acc.name =c.FirstName.subString(0 ,1).ToUpperCase()+c.FirstName.subString(1)+sp+ c.LastName.subString(0 ,1).ToUpperCase()+c.LastName.subString(1)+sp+ 'Family';
        
        acclist.add(acc);
        }
        
        }
        if(!acclist.isEmpty())
        insert acclist;
       
        }
        for(Account acc : acclist) {
            System.debug('accName===>'+acc.name);
            accountMap.put(acc.name,acc);
        }
        for(Contact c:Trigger.New){
            if(c.Source_temp__c != null)
            {
                c.Source__c= c.Source_temp__c;
            }
            if(c.Create_New_Account__c == True) {
                 if(c.FirstName!= null && c.LastName!=null)
                {
               c.AccountId = accountMap.get(c.FirstName.subString(0 ,1).ToUpperCase()+c.FirstName.subString(1)+sp+ c.LastName.subString(0 ,1).ToUpperCase()+c.LastName.subString(1)+sp+ 'Family').id;
                c.Create_New_Account__c = False;
               }
            }
        }
    }
   
}
************************************************************* my test class is*******************************************
@istest
public class triggerAccCreatedwtihFamilyTest{
    static testmethod void unittestmethod(){
Test.startTest();
           
        contact c = new contact();
        c.lastname='test';
        c.firstname = 'testfirtname';
        c.Potential_Non_Potential__c ='p';
        c.Personal_Email__c ='raji@gmail.com';
        c.Create_New_Account__c=true;
        c.Pincode__c= '500045';
         insert c;
        
   Test.stopTest();
           
        }
    
}
How to pass parameter from apex repeat component to controller through action function.
My scenario is to display all the dashboard in the homepage. For this i wrote visualforce page and then i added to home page component. It showing all the dashboard in the homepage when we click the dashboard its not redirecting to dashboard page. Can any one help me out to solve this issue. Thanks in advance.
 
<apex:page showheader="false" sidebar="false">
<apex:outputPanel id="SalesfunnelDashboard" >
     <script>
     window.location.href="https://cs51.salesforce.com/01Z4B0000000FwO?isdtp=vw";
   
       
     </script>
     </apex:outputPanel>
</apex:page>

 
I want to delete the record after inserting. Can anyone help to solve this?

trigger LeadUpdateTrigger on Lead (after insert) {
   List<String> ld = new List<String>();
   List<Lead> oldld = new List<Lead>();
   
   for(Lead l : Trigger.new){
       ld.add(l.Phone);
       ld.add(l.Email);
   }
   
   List<Lead> lds = [SELECT Email,LeadSource,Phone FROM Lead where Phone in :ld AND Email in : ld];
  
   if(lds.size()>0){
       for(Lead l1 : lds){
           for(Lead l2 : Trigger.New){
               l1.LeadSource = l2.LeadSource;
               oldld.add(l1);   
           }
       }
       update oldld;
   } 
}

I want to delete "l2" which is new record after oldld is updated
I am not sure how to write a OnClick JavaScript custom close button on case object.

When the user clicks on this custom button, the following fields need to be updated with the given values.

Fields on case object:
Product Family = Unknown        
Product Model = Unknown
Problem Code = Non-Technical
Resolution Code = Spam
Status = Closed
Resolution Description = Spam
Account Name (lookup field) =  Unclassified Customer – Minnetonka 

Also need to associate the contact to the account; Unclassified Customer – Minnetonka


I appreciate the help!

Beth
Hi All,
How can I update a field value for a particular sObject in a List of sObjects? I'm trying to update the status of a task to 'Completed' if the corresponding opportunity status is set to 'Closed Won' by the user.
Thanks much!