Hi Guys,
I'm new to developing

,


Can anybody help me in writing triggers

Subject: I would like to convert Email to case related to recent opportunity ( i have written the code email to case related to opportunity but I would like to assign recent opportunity)

For your reference, i have attached the code

Drawback: My cases assigned to  All related opportunities 

Code:
trigger CasetoAccountInsert on Case (before insert) {

    for(Case record: Trigger.new)
    {
        List<Opportunity> OpportunityList = [SELECT AccountId, Name FROM Opportunity WHERE Contact_Email__c = :record.SuppliedEmail] ;
        if (OpportunityList.size() > 0)
        {
            record.AccountId  = OpportunityList[0].AccountId;                            
        }
    } 
    
}



Thanks in Advance
AnuSh

Hi Guys,

Need some help !!

I'm new to Apex Developing. I'm trying to create the opportunities count in the Product object. 
Note: Account object is not Master Details (A read-only field that displays the sum, minimum, or maximum value of a field in a related list or the record count of all records listed in a related list.)

So guide me in other way to create opportunity count in product object field.

Subject: I would like to convert Email to case related to recent opportunity ( i have written the code email to case related to opportunity but I would like to assign recent opportunity)

For your reference, i have attached the code

Drawback: My cases assigned to  All related opportunities 

Code:
trigger CasetoAccountInsert on Case (before insert) {

    for(Case record: Trigger.new)
    {
        List<Opportunity> OpportunityList = [SELECT AccountId, Name FROM Opportunity WHERE Contact_Email__c = :record.SuppliedEmail] ;
        if (OpportunityList.size() > 0)
        {
            record.AccountId  = OpportunityList[0].AccountId;                            
        }
    } 
    
}



Thanks in Advance
AnuSh

Hi Guys,

Need some help !!

I'm new to Apex Developing. I'm trying to create the opportunities count in the Product object. 
Note: Account object is not Master Details (A read-only field that displays the sum, minimum, or maximum value of a field in a related list or the record count of all records listed in a related list.)

So guide me in other way to create opportunity count in product object field.