function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Yuvraj .Yuvraj . 

Need a trigger ??

After Update the Account record Active Status from "No" to "Yes" , Create a contact record. 


 
Best Answer chosen by Yuvraj .
CharuDuttCharuDutt
Hii Yuvraj
Try Below Trigger 
trigger SendEmailtoContact on Account (after update) {
    list<Contact> lstCon=new list<Contact>();
    
    If(Trigger.IsAfter && Trigger.IsUpdate){
        For(Account Acc : trigger.new){
           //
            If(Acc.Active__c == 'Yes' && Trigger.oldMap.get(Acc.Id).Active__c != Acc.Active__c){
                Contact Con = new Contact();
                Con.LastName=Acc.Name;
                Con.AccountId= Acc.id;
                lstCon.add(Con);
               
            }
        }
    }
    If(lstCon.size()>0){
        insert lstCon;
    }
}
Please Mark It As Best Answer If It Helps
Thank You! 
 

All Answers

CharuDuttCharuDutt
Hii Yuvraj
Try Below Trigger 
trigger SendEmailtoContact on Account (after update) {
    list<Contact> lstCon=new list<Contact>();
    
    If(Trigger.IsAfter && Trigger.IsUpdate){
        For(Account Acc : trigger.new){
           //
            If(Acc.Active__c == 'Yes' && Trigger.oldMap.get(Acc.Id).Active__c != Acc.Active__c){
                Contact Con = new Contact();
                Con.LastName=Acc.Name;
                Con.AccountId= Acc.id;
                lstCon.add(Con);
               
            }
        }
    }
    If(lstCon.size()>0){
        insert lstCon;
    }
}
Please Mark It As Best Answer If It Helps
Thank You! 
 
This was selected as the best answer
Suraj Tripathi 47Suraj Tripathi 47

Hi,

Please find the solution.

trigger CreateContact on Account (After Update) {
    List<Contact> contactList=new List<Contact>();
    
    If(Trigger.IsAfter && Trigger.IsUpdate){
        For(Account Ac : trigger.new){
            If(Ac.Active__c == 'Yes' && Trigger.oldMap.get(Ac.Id).Active__c != Ac.Active__c){
                Contact Con = new Contact();
                Con.LastName='Test';
                Con.AccountId= Ac.id;
                contactList.add(Con);
               
            }
        }
    }
    If(contactList.size()>0){
        insert contactList;
    }
}