<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Managed to get it working, here’s my terrible code (this goes in the custom condition box, all others empty):<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>my $ticket = $self->TicketObj;<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>my $cf_obj = RT::CustomField->new($RT::SystemUser);<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>my $cf_name = "Needs Approval";<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>my $cf_value = "Flag";<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>return 0 unless $self->TicketObj->FirstCustomFieldValue('65') eq 'Yes';<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>$cf_obj->LoadByName( Name => $cf_name );<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>$ticket->AddCustomFieldValue( Field=>$cf_obj, Value=>$cf_value, RecordTransaction=>0 );<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>return 1;<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>This will delete the value of the Needs Approval custom field (The ‘flag’) from Yes to blank, which works well for my needs. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>With this in place it triggers one approval request every time someone sets the “Needs Approval” dropdown box to “Yes”.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cheers,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Dion<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>From:</b> rt-users [mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Dion Gullotta<br><b>Sent:</b> Wednesday, 7 October 2015 3:53 PM<br><b>To:</b> rt-users@lists.bestpractical.com<br><b>Subject:</b> [rt-users] Need help with custom field to trigger approvals (RT 4.2)<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I would like to trigger an approval request with a custom field value.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We have set up approvals normally which work great, but we wanted to be able to set a custom field value to trigger the creation instead.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We have a custom field called “Needs Approval” and we have a scrip with the custom condition:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>my $Ticket = $self->TicketObj;<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>return 0 unless $self->TicketObj->FirstCustomFieldValue('65') eq 'Yes';<o:p></o:p></p><p class=MsoNormal> return 1;<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Prep code and Commit code are blank. Action is “Create tickets” and Template “Create Approval Request” as normal.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This all works fine initially but because the “Needs Approval” field remains set to “Yes” then every time the ticket is touched another approval gets created. So I am trying to unset “Needs Approval” from “Yes” to “No” after it’s been triggered.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have tried this in the Commit code (prep code blank):<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>$cf->LoadByName( Name => 'Needs Approval' );<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>$self->TicketObj->AddCustomFieldValue( Field => '$cf', Value => 'No' );<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But it doesn’t seem to work. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Any advice or help appreciated as always.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='mso-fareast-language:EN-AU'>Dion Gullotta<br>Far Edge Technology<br><br>p. 02 84251400<br><a href="http://www.faredge.com.au">http://www.faredge.com.au</a> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p> </o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>