Thank you for the responses. I can see there are several ways to skin this cat.
With the luck I've been having lately, I think I'll try the bullet proof method. Thanks All. Andy L. Mayfield Sr. SCADA Operation Center Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rabi Tripathi Sent: Wednesday, March 16, 2011 12:54 PM To: [email protected] Subject: Re: Require Worklog Change Andy, Most people would write it like you have, but you will find many people on the ARSLIST including me, who prefer something like this: Assigned Group != DB.Assigned Group AND TR.Worklog = $NULL$ Reliance on TR value assumes the update came from a manual save from Windows or Browser client using the built-in Save button/menu choice (as opposed to from a record displayed on a dialog window and an Active Link push field action; or from an API program or Push Field filter action triggered from another record/transaction). True most of the time for most setups, so you might get away with it. But it can cause trouble, so write it the above way, if you want it "bullet proof". I do not wish to start a long thread on this topic. It has been talked to death in the past, but I can elaborate it for you, if you wish. Note that I left the TR alone for WorkLog field, because it, I am assuming, is a "diary" type of field that is treated differently by active links and filters. I think TR prefix should work for this field. --- On Wed, 3/16/11, Mayfield, Andy L. <[email protected]> wrote: > From: Mayfield, Andy L. <[email protected]> > Subject: Require Worklog Change > To: [email protected] > Date: Wednesday, March 16, 2011, 9:30 AM > I would like to force a worklog entry > on a form anytime the assigned group changes. > > I wanted to get opinions on the best way to accomplish > this. > > I was thinking you would use a filter with a "Run If" > like: TR.Assigned Group != > $NULL$ AND TR.Worklog = $NULL$ > > But I wasn't sure if this would be the best way. I thought > I remember seeing this on the list before, but I didn't have > any luck searching for it. > > Andy L. Mayfield > Sr. SCADA Operation Center Technician > Alabama Power Company > Office: 205-226-1805 > Cell: 205-288-9140 > SoLinc: 10*19140 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers > Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
