#Inbound actions to record action (written on change_task, record_action , reply)
condtion : email.subject.indexOf("autoclose") >= 0 // checks email subject for autoclose keyword
Action script:
if (current.getTableName() == "change_task") {
if (validUser()) {
current.work_notes = "reply from: " + email.from + "\n\n" + email.body_text;
// if it's been cancelled, or completed already it won't update
var doit = true;
if (current.state == '3' || current.state == '4' || current.state == '5' || current.state == '6' || current.state == '7')
doit = false;
if (email.subject.indexOf("Closed Complete") >= 0) // checks email subject for closed complete keyword
{
current.close_notes = email.body_text;
current.state = '3';
}
if (email.subject.indexOf("Closed Incomplete") >= 0) // checks email subject for closed Incomplete keyword
{
current.close_notes = email.body_text;
current.state = '4';
}
if (email.subject.indexOf("Closed Cancelled") >= 0) // checks email subject for closed cancelled keyword
{
current.close_notes = email.body_text;
current.state = '5';
}
if (email.subject.indexOf("Closed Complete with Issues") >= 0) // checks email subject for closed complete with issues keyword
{
current.close_notes = email.body_text;
current.state = '6';
}
if (email.subject.indexOf("Closed and Failed") >= 0) // checks email subject for Closed and Failed keyword
{
current.close_notes = email.body_text;
current.state = '7';
}
if (doit) {
current.update();
} else {
gs.log("Update for Change Task ("+current.number + ") failed. Details: Invalid state. Task can only be updated if state is not already completed or cancelled");
}
} else {
gs.log("Update for Change Task ("+current.number + ") failed. Details: invalid user. Task can only be updated by the assignee, not " +email.from );
}
}
function validUser() {
var user = email.from_sys_id;
var ourUser = gs.getUser();
ourUser = ourUser.getUserByID(user);
ourUser.isMemberOf(current.assignment_group);
if(ourUser)
{
return true;
}
else if (current.assigned_to == email.from_sys_id)
{
return true;
}
}
Now go to templates under system notification and create records as below
Go to notification and link template
{$mailto:<template_name>} is the format to link template to notification
Change above data as per your convenience. Presently it is in change_task table. and do action based on email subject from user who is the member of the assignment group of change task.
Thank you,
Arkesh
I mean Source table of approval record.
To check go sysapproval_approver table. Open any record and right click > Configure > Form Design Add 'Source table' to the form.
Thank you,
Arkesh
Oh, its the sc_req_item
