1 try Active Link after submit. Also create an escalation the looks for the optional field null and then do a set fields.
-----Original Message----- From: Andrew Hicox <[EMAIL PROTECTED]> To: [email protected] Sent: Tue, 26 Aug 2008 4:34 pm 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"? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
