I would suggest trying an Active Link with an 'Execute On' of "After Submit"
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Hicox Sent: Tuesday, August 26, 2008 4:35 PM To: [email protected] Subject: how to copy 'request id' to other field on submit Hello everyone: I have a seemingly simple thing I'd like to do. I have a form, and an optional field on that form. If the optional field is $NULL$ upon submit, I'd like to copy the 'request id' (i.e. "ticket number", fieldid = 1) into this field. Filters do not seem to catch this, as they execute before commit. Things I have tried. Filter on Submit where 'optional field' = $NULL$ and 'request id' != 'DB.request id' Filter on Modify with same qualification Filter on Modify & Submit with same qualification All of the above at execution order 0 and the absurdly high value of 999 setting $LASTID$ as the default value of 'optional field' works, but again because it is BEFORE the commit, it gets the previous 'request id' value, not the one that will belong to the record I'm in. SO ... is there a proper way to do this (other than leaving 'optional field' null and having an escalation come along and fix it for me?) thanks everyone, -Andy ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions expressed are those of the author. This message is intended for the addressee(s) only and its contents and any attached files are strictly confidential. If you have received it in error, please contact the sender on the number above. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
