You need to sign in to do that
Don't have an account?
JaxBeach
Workflow trigger from case created date based on not receiving an email?
Hi,
I need to send out time triggered email alerts on cases that haven't received an email response. Does anyone know how I would code that - I would base it on createdDate but I don't know how to create a formula for email received equals zero.
thanks.
I need to send out time triggered email alerts on cases that haven't received an email response. Does anyone know how I would code that - I would base it on createdDate but I don't know how to create a formula for email received equals zero.
thanks.
{
Set<Id> caseIds = new Set<Id>();
for (Task t : Trigger.New)
{
if (String.valueof(t.WhatId).StartsWith('500'))
caseIds.add(t.whatId);
}
if (caseIds.size() > 0) {
List<Case> caseList = [select id, Activity_Count__c from Case where Id in :caseIds];
if (caseList.size() > 0) {
for (Case c : caseList)
{
if (c.Activity_Count__c == null)
c.Activity_Count__c = 0;
c.Activity_Count__c++;
}
update caseList;
}
}
}
Let me know if this works.
Thanks,
Venkat
All Answers
{
Set<Id> caseIds = new Set<Id>();
for (Task t : Trigger.New)
{
if (String.valueof(t.WhatId).StartsWith('500'))
caseIds.add(t.whatId);
}
if (caseIds.size() > 0) {
List<Case> caseList = [select id, Activity_Count__c from Case where Id in :caseIds];
if (caseList.size() > 0) {
for (Case c : caseList)
{
if (c.Activity_Count__c == null)
c.Activity_Count__c = 0;
c.Activity_Count__c++;
}
update caseList;
}
}
}
Let me know if this works.
Thanks,
Venkat