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"
