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"
