Apex Code Development You need to sign in to do that
Don't have an account?
Apex Code Help on Custom Date Field on Account
I created a custom date field on the Account called Account_Last_Activity__c and I want to update it based on the last activity by specific Users. I then want to run a report based on the Last Activtiy and by whom. I got this far on my apex code and received an "unexpected toke" error. I have not been able to include the specific User IDs in the code either. Any help would be appreciated. Thank you!
rigger UpdateAccountLastActivityAccount on Task (after insert, after update) {
Set<String> whatIds = new Set<String>();
for (Task t : Trigger.new) {
whatIds.add(t.WhatId);
}
List<Account> acct = [SELECT Id, Account_Last_Activity__c FROM Account WHERE Id =: whatIds];
Map<String, Task> taskMap = new Map<String, Task>();
}
}
}
for (Account a : acct) {
if (taskMap.containsKey(a.Id)) {
a.Account_Last_Activity__c = taskMap.get(a.Id).ActivityDate;
}
}
update acct;
}
rigger UpdateAccountLastActivityAccount on Task (after insert, after update) {
Set<String> whatIds = new Set<String>();
for (Task t : Trigger.new) {
whatIds.add(t.WhatId);
}
List<Account> acct = [SELECT Id, Account_Last_Activity__c FROM Account WHERE Id =: whatIds];
Map<String, Task> taskMap = new Map<String, Task>();
}
}
}
for (Account a : acct) {
if (taskMap.containsKey(a.Id)) {
a.Account_Last_Activity__c = taskMap.get(a.Id).ActivityDate;
}
}
update acct;
}
Trigger UpdateAccountLastActivityAccount on Task (after insert, after update) { Set<ID> whatIds = new Set<ID>(); for (Task t : Trigger.new) { whatIds.add(t.WhatId); } List<Account> acct = [SELECT Id, Account_Last_Activity__c FROM Account WHERE Id in :whatIds]; if( !acct.isEmpty() ){ Map<ID, Task> taskMap = new Map<ID, Task>(); for( Task t : Trigger.new ){ taskMap.put( t.WhatId , t ); } for (Account a : acct) { if (taskMap.containsKey(a.Id)) { a.Account_Last_Activity__c = taskMap.get(a.Id).ActivityDate; } } update acct; } }Try Above code...