Hi,

I have created a before insert trigger on a custom object Object1__c which will create records for another custom object Object2__c. There is a before insert trigger in Object2__c that will create records for the 3rd custom object Object3__c. Earlier I used to get governor limit errors on SOQL queries as they were inside a loop. Now I keep getting error on List size being above 1000. Could I catch and exception and show it as an error in the visualforce page. How do I caluclate for the limit.

Thanks

Krishnadas

www.steadfastglobal.com 

Hope someone can help me.

I need to create a validation rule for this scenario:

User "A" creates a record in custom object and leaves Compromise Proposal Date field blank. This field is Date type.

User "B" enters the record and types a valid date in Compromise Proposal Date field.

Once user "B" enters a date, no one must be able to modify it.

Thanks 

Hello,

I have a user that wants a formula field that figures a person's age at the time of the opportunity create date. I have a formula in place to determine the person's current age, however, that will change from year to year. I am not seeing an option to subtract their birth year from the Opp. Created year (2009 - 1944 = 65) without adding additional fields, which he does not want. Any help would be appreciated.

Thanks!

Below is my Apex class and test method. when i run my test i am receiving the error

System.QueryException: List has no rows for assignment to SObject (and this is for the line where i am quering sales_office custom object)

Can some one please guide me how to write test methos for the code below?

Thanks very much in advance for the help

public class Accountdelete { Id AcctId = ApexPages.currentPage().getparameters().get('id'); public Account getAccountName() { return [Select Name from Account where id=:AcctId]; } public PageReference Reassign() { Account acct=[Select Named_Account__c,RegionName__c,ownerid from Account where id=:AcctId]; Sales_Office__c salesoffice=[Select sales_Administrator__c from sales_Office__c where name=:acct.RegionName__c]; String res=''; Integer count=(acct.product_type__c).indexOf('QAC'); if(count>-1) { res=(acct.product_type__c).replace('QAC',''); } acct.product_type__c=res; acct.ownerid=salesoffice.Sales_Administrator__c; update acct; return null; } public static testMethod void results() { Id id; Account testAccount =new Account(Name='Sample2',RecordTypeid='0123000000002GvAAI',NumberOfEmployees=10,BillingStreet='71 Maple st, BillingCity='Doral', BillingState='FL', BillingPostalCode='33172', BillingCountry='US',phone='1111111111',RegionName__c='Miami'); insert testAccount ; Sales_Office__c Salesoffice=new Sales_Office__c(SALES_ADMINISTRATOR__C='00530000000f5H6AAI',NAME=testAccount.RegionName__c); insert Salesoffice; ApexPages.currentPage().getParameters().put('id', testAccount.id ); id = ApexPages.CurrentPage().getParameters().get('id'); Accountdelete test=new Accountdelete(); test.getAccountDetails(); test.Reassign(); } }

I've tried a couple solutions found on the boards but I always seem to get CANNOT_INSERT_UPDATE.. error when I try to update a field on a parent object from a ''after update'' or ''after insert'' trigger on the child (''before update'' or ''before insert'' doesn't work).

I've put an quick example of how I've made my trigger:

trigger opp_update on Child_Object__c (after update, after insert) {

for( Child_Object__c child: Trigger.new){
 ID parent_ID= child.Opportunity__c;
 

Opportunity opp_to_update= [select field_to_update__c from Opportunity where id =: parent_ID];
 opp_to_update.field_to_update__c = 7777;
 

update opp_to_update;
 }
 
}

Does someone have a quick tip to help me solve this?

Hi. I'm a newbie, so this may be a simple question to answer.

I have 2 custom objects: an Application (e.g. for a mortgage), and Client, connected by a lookup relationship. An application can have 1 or more Clients, and the Client includes fields First_Name & Surname (Text, External ID) and ApplicationLUP (Lookup(Application)).

When I click on my Applications tab and search for an Application in the search field (left hand bar), I'd like to be able to search by name of the child Client, first name or surname,as well as Application ID. So searching for "Smith" will return me all Applications with a Client named Smith. How is this done?

Many thanks!

Richard

I'm really new in this and would appreciate any pointers. I read through examples but still not sure how to proceed. TIA.

/*** Controller ***/
public class MyControllerExtension {

    private final Opportunity oppor;
   

    public myControllerExtension (ApexPages.StandardController stdController) {
        Id id = ApexPages.currentPage().getParameters().get('Id');
       
        oppor = (id == null) ? new Opportunity() :
                [
                 SELECT Id, StageName, Account_Region__c                

                 FROM Opportunity
                 WHERE Id = :id
                ];
    }

    public Opportunity getOpportunity() {

        return oppor;

    }

   
    public String getButtonState() {
 
        if(oppor.Account_Region__c == 'UK') {
            if(oppor.StageName == 'Closed Won') {
               return 'False';
            } else {
              return 'True';
            }
        } else {
            return 'True';
        }
    }   

}

/*** TEST ***/

@isTest
private class TestMyControllerExtension {
  
    static testMethod void TestMyControllerExtension() {
       
        ApexPages.StandardController stdController;
        MyControllerExtension mce = new MyControllerExtension(stdController);
       
        Opportunity oppor = mce.getOpportunity();
 
        oppor.StageName = 'Closed Won';
        oppor.Account.Region__c = 'UK';
         
    
        System.assertEquals(mce.getButtonState(),'False');

    }

}

I got two objects 'Promotion' and 'Feedback'. Promotion has got a field called "isChanged" and Feedback has got a field called "Feedback body" which is of text area. The two objects are related by Id (Promotion Field) and promotion Id (Feedback Field)

I would like to write a trigger in such a way that whenever users changes the status of promotion to "Closed", there must be a predefined feedback text generated in the Feedback Body field.

The code which I have written is below. But this is not helping though am not getting any errors.

trigger StatusChange on Promotion (after update) 
 {
  for(Promotion i : Trigger.new)
  
  {
   if(i.isChanged == true)
    {
     String str = i.Id;
      Feedback ic = [Select FeedbackBody from Feedback where PromotionId = :str];
       ic.FeedbackBody = 'Staus has been changed';

    }
  }
 }