Hi Ron,
Yes I did mean the later, but we would have settled for an attachment if need be. Thank you for the instructions. I'll try this out in our development environment this week and let you know my results. Thanks again, Lou ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares Sent: Tuesday, March 18, 2008 12:29 PM To: [email protected] Subject: Re: Include Related Items on Approval Email Notifications ** Are you looking to ad the related items as attachments or just the details of the related items, such as request id, desc, etc? Assuming you meant the later, this is one way to do it: - Create a hidden character field on parent form. For this example, z-DetailsCapture - Create a Filter with one Set Field action that reads the rows you want from the 'Related Item' table and ADDs them to the character field. You can add the label of each row, followed by the value. Like this, z-DetailsCapture = z-DetailsCapture + (" Request ID: " + $Col_RequestID$). This filter should have no 'Execute On' settings. Also, ad a carriage return at the end of the set-field string so that multiple items will each show on it's own line. - Create Filter Guide that fires the Filter above. Be sure to check off 'Table Loop'. - Modify your existing filter which sends out the notification as follows: 1) Call the guide above before initiating the Notify action. 2) Ad 'z-DetailsCapture' field into your Notify action. On 3/18/08, Louis Cobuccio <[EMAIL PROTECTED]> wrote: AR v 7.0.01 Patch 006 Windows Server 2003 MS SQL 2005 Good Morning Gang, I have a request to include related items on the approval email message that is generated requesting an approval. Is this possible since all of the related item details are on a form other than CHG:Infrastructure Change? Any thoughts would be helpful. Thank you, Lou ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
