+ Start a Discussion
Kiru535Kiru535 

Populating Lead object custom field based on Compaign History Status and date time stamp

I have a requirement like this. Please reply to me ASAP.

In Lead standard object I have created one custom field called Compaign Name. I want to populate this field based on compaign history field called Status and Start date fields. Based on below criteria it would have populate...

If compaign history contains morethan one record then  based on most recent Date (Consider Start Date, Time Stamp field) record compaign Name should populate on Lead object custom field. I have already tried with  trigger and its working fine but businees said do not use trigger because each lead getting compaigns morethan 3000 per day so, it could be a performance issue when we use trigger. Please suggest me any other solution by using Reports or other solution. I am struggling with this requirement ...please help me.

Regards,
kk

Note : 
Eli Flores, SFDC DevEli Flores, SFDC Dev
could you do it as a scheduled apex like once a day during non-business hours?