Thanks Phil for the valuable suggestion!! Regards, Shashi
On Mon, Apr 14, 2014 at 5:06 PM, Murnane, Phil <[email protected]>wrote: > Shashi: > > Your task can be done with two filters, the first on the profile form and > the second on the approvers form. > > The first filter (on the profile form) fires when profile.Status changes > to offline and does a push fields to approver.zTemp1 with the ID to be > removed and to approver.zTemp2 with the ID to replace the removed ID. The > filter is set to modify all approver records where approver.ApproverList > contains ";[the ID to be removed];" -- this filter accomplishes your > desired loop-like function. > > The second filter (on the approver form) runs on Modify when zTemp1 and > zTemp2 are not NULL and uses the REPLACE function to change ";[the ID to be > removed];" to ";[the ID to replace with];". > > This solution assumes that zTemp1 and zTemp2 are not used in any other > filter processing on the approver form. It also assumes that the > ApproverList always has leading and trailing semicolons. > > HTH, > --Phil > > > > ________________________________________ > From: Action Request System discussion list(ARSList) [[email protected]] > On Behalf Of shashidhar M S [[email protected]] > Sent: Monday, April 14, 2014 02:42 > To: [email protected] > Subject: Scenario based query > > Dear Experts, > > Seeking your valuable assistance on the below scenario. > > There is a customized approval form where a character field holds the > Approvers Id (Remedy Login Ids). If there are multiple approvers, the Ids > are separated by a semi colon (;) . Now the expectation is, when a people > profile is set to Offline, If that user is an approver in the customized > approval form, His ID has to be replaced by his managers ID (From the > people form). > > Since there might be many records present on the approval form for an user > ID which is going to be offline, I am stuck up here. Can someone help me > with an approach to handle this please? > > I tried using the below > > #. Created two temp fields on People form ZTemp1 , zTemp2 > > #. On setting the profile offlne, used a set field action to set the > contents of the approver ID field on Approval form to the zTemp1 on people > form. > > #. Used another set field to zTemp2 with Replace function - > REPLACE($zTemp1$,$Remedy Login ID$,$Manager ID$). which finds the Current > ID and replaces the same with manager ID. > > #. A push field from zTemp2 to the Approver ID field on Approval form. > > This worked for the first record on the list, But I am confused on how to > traverse the next set of entries to perform the same operation. I am afraid > to use a table loop. > > Thanks in Advance!! > > Regards, > Shashi > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
