• Dhairya
  • NEWBIE
  • 60 Points
  • Member since 2010

  • Chatter
    Feed
  • 2
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 24
    Questions
  • 35
    Replies

Hi All,

 

I am trying to generate a report based on the value of a checkbox. It is a tabular report that has to count total number of records where the check box value is true. In my system, there are about 40 records with the check box value "true". However, when I run the report I can see only one record. Is it because of the security? I can see all the records in the object. I created new record with the checkbox value as "true", but it is not displaying that record in the results. Could any one please let me know what I need to verify to get all the records ? Your help is greatly appreciated.

Just venting, but I discovered that the csv files generated by the Salesforce.com Data Export do not include Formula fields, they are left out entirely.  But if I use the Data Loader or Informatica, the formula fields are exported.  I'm trying to work with the Data Export csv files and it is frustrating to have to keep two sets of copybooks, one with formulas and one without. 

Hi,

 

  In our application we are populationg one custom object  from the webstore using api. Hence, all inserted records have same record owner but for the reporting purpose i need Account Owner name as the custome object owner name. We have two common fields. 

 

  How to resolve the issue?

 

   Appreciate your help.

 

Thanks,

Dhairya

     Hi,

 

    We need below report format 

 

AccountName      state        License Key         Date                               check           see           total

-------------------       -------         --------------           ------                                ---------          ------         --------

Accc                          ca             xxxxxx                  10-1-2010                       20                 12             32

                                                                                 11-13-2010                    14                 14             28

                                                                                 1-3-2011                        10                  5              15

 

                                                                                Total                                44                   31             75

 

 

I tried summary report but failed to figure it out how to add date values.

 

Appreciate your response.

 

d   

Hi,

 

   Here i would likek to update test1__c value with related objects fields. But it didn't work at all.

 

 

 

trigger budTotalTrigger on Budget__c (after insert) {
   list <projects__c> projects = [select id,name,test1__C from Projects__C];
   
   for(budget__C bud : trigger.new)
   {
     for(projects__c pro : projects) 
     {
       if(pro.id == bud.PMO_Project__r.id)
       {
        pro.test1__c = pro.test1__C + bud.value__c;
      
       }
      database.update(pro);
    
     }
     
        
  
   }
}

 

 

 

Hi,
    {!addMore} is a coomand button action (VF) and blow code is a part of exdtension. I am getting current record  in variable named budget1 of type Budget__C. 
    I would like to calculate total budget value at project level on field test1__c on Project__C object.
    Question is creation of budget record working fine but budger related project field (test1__c) is not populated.
//Budget Record Save
     public PageReference addMore()
     {
                       
          
          database.Insert(budget1);
         if(budget1.value__c!=Null && budget1.PMO_Project__r.test1__c!=null )
           { 
               budget1.PMO_Project__r.test1__c = 'test';
              
              projects__c project = [select 
              
                                     name from projects__c where projects__c.id=:budget1.PMO_Project__r.Id] ;
                
               
               
              update(project) 
                          
           }       
          
          ApexPages.StandardController budgetController = new ApexPages.StandardController(budget1);
          return budgetController.save();
          //return page.budgetDetail;
     }

 

 

Appreciate Your Help,

 

Dhairya

Hi, 

 

    A scenario is i am receiving values like below in text field at opp. line level for 7 products

 

      Qty 7 (2010-11-14)   or Qty 5 (2010-11-14)  Qty 2 (2010-11-14)  or Qty 4 (2010-11-14) Qty 2 (2010-11-14) Qty 1(2010-11-14)

 

   [ number of receiving date are vary so i am not sure that we can use workflow or not ]

 

 So, i wrote a trigger for that :

 

 

 

trigger OppotunityProductFulfillmentDateTrigger on OpportunityLineItem (before update) {
  
    // list<opportunityLineItem> lineItems = Trigger.new;
     
     user  u = [select username from user where lastname = 'view'];
     
     
    for (opportunityLineItem line : trigger.new)
    {
         if (line.Delivery_Details__c != NULL && (trigger.oldmap.get(line.id).Delivery_Details__c!= line.Delivery_Details__c))
         {
       
         Integer len = line.Delivery_Details__c.length();
        
         string s = line.Delivery_Details__c;
        
            String[] s1 = s.split('\\(');
            
            for(Integer i=1;i<=s1.size();i=i+2)
         {    
         s1[i]=s1[i].replace('\\)','');         
         task t= new task();
         t.subject='Training Required';
         t.ownerid= u.id;
         t.status='In Progress';
         t.priority='high';
         t.ActivityDate = date.valueof(s1[i].substring(0,10));
         t.whatid=line.OpportunityID;
          //  t.description+=s1[i].substring(0,10);
         insert t;
        
         }
    
         }
    }
    
    
It work fine when text field has one date say Qty 5  (2010-11-14). But it the value is  Qty2(2010-12-11) Qty3(2010-12-14)
it throw following error
OppotunityProductFulfillmentDateTrigger: execution of BeforeUpdate

caused by: System.ListException: List index out of bounds: 3

Trigger.OppotunityProductFulfillmentDateTrigger: line 21, column 14
I am not sure abt. this error.
Appreciate your response.
Dhairya

 

Hi,

 

    The scenario is we are capturing fulfillment date at Opp. product level. [which is coming from ERP]

 

    i.e. Qty 1(05-DEC-2010) Qty 4(08-DEC-2010)      this is a text field (fulfillment_date__c)  in SFDC

 

   Now, based on this field value i want to fire task on  12/05/2010 and 12/08/2010 to a specific user.

 

 

Appreciate your help.

 

Dhairya

 

Hi,

 

    The scenario is we are capturing fulfillment date at Opp. product level. [which is coming from ERP]

 

    i.e. Qty 1(05-DEC-2010) Qty 4(08-DEC-2010)      this is a text field (fulfillment_date__c)  in SFDC

 

   Now, based on this field date workflow rule fire on that date and assign a task.

 

    Appreciate your help.

 

Dhairya

 

 

 

 

Hi,

 

   I am trying to deploy new custom object  named Complaint_Management from Sand Box to Production.

 

   Facing Error : 

 

 

# Deploy Results:
   File Name:    objects/Complaint_Management__c.object
   Full Name:  Complaint_Management__c
   Action:  NO ACTION
   Result:  FAILED
   Problem: The sharing model cannot be updated through the API.

 

 

 

Appreciate your response.

 

Thanks,

Dhairya

Hi,

 

    I have one workflow rule set up in sandbox and that cause VF page email alert to user.

 

    (1) Succesfuly delpoy VF page under communication tempalate

 

     (2) Create new Force.com project which only consist that WFR component

 

      (3) When Deploying that WFR in production using deploy to server ask for test trigger coverage and code coverage etc.

 

 

      While i am just deploying simple WFR.

 

       This is my first deployment experience. Appreciate your response.

 

Thanks

I have a question, with Data Loader can we map custom fields to standard fields?

I am trying to install IDE (force.com-ide-installer-win32.exe). First I had some trouble with the proxy settings in pulse explorer. I manage to overcome this. Then the installer stops with an error in forceide.exe:

JVM terminated. Exit code=-1

-Dfile.encoding=UTF-8

-Xms256m

-Xmx1024m

-XX:PermSize=128M

-XX:MaxPermSize=512M

-Djava.class.path=C:\Programme\salesforce.com\Force.com IDE\../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar

-os win32

-ws win32

-arch x86

-showsplash

-launcher C:\Programme\salesforce.com\Force.com IDE\forceide.exe

-name Forceide

--launcher.library C:\Programme\salesforce.com\Force.com

IDE\../Common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519\eclipse_1206.dll

-startup C:\Programme\salesforce.com\Force.com IDE\../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar

-install C:\Programme\salesforce.com\Force.com IDE

-configuration C:\Programme\salesforce.com\Force.com IDE\configuration

-clean

-vm C:/Programme/Java/jre6/bin\client\jvm.dll

-vmargs

-Dfile.encoding=UTF-8

-Xms256m

-Xmx1024m

-XX:PermSize=128M

-XX:MaxPermSize=512M

-Djava.class.path=C:\Programme\salesforce.com\Force.com IDE\../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar

 

Any idea how to fix it?

 

Thanks in advance.

Hi,

 

     The scenario is :

 

     (1) Case contains few custom field, and if that field value is not present as an account name then create account using that name.

 

    They do not want to go with lookup idea. They want trigger.

 

The Code i tried to write is  :

 

 

trigger EndUserAccountTrigger on Case (after insert) {
 list<account> accname = [select name from account where type='End User']; 
 list<account> tempaccname = new list<account>();
 for(case c: trigger.new)
 {
   for(account acc: accname)
 {
 if(acc.name != c.system__c)
 {
 tempaccname.add(new account(name=c.System__c));
 }
   
 }
 }
 database.insert(tempaccname);
}

 

 

 

 

 

 

 

 

 

 

 

 

But it throw an error.

 

     Appreciate your response.

 

Thanks,

Dhairya