Thanks again Ryan, Makes sense. Susan
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan Sent: October-03-13 3:20 PM To: arslist@ARSLIST.ORG Subject: Re: Include fields from multiple Forms in filter Notification Message ** Hello again ☺ If you require all work info entries…then as far as I am aware you are limited to either creating a join on the 2 forms and pushing to the join form where ID = ID and send the notifications form the join……or Create the table field on the TMS:Task form and have a filter guide table loop to concatenate all of the work info records to a single temp field and use this field (in conjunction with any native task fields) to create the notify action. I am sure there are probably other ways to accomplish this…but…the table field loop would be the most effective way that I can think of ☺ Hope this helps Regards, Ryan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Champagne, Susan Sent: Thursday, October 03, 2013 3:14 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Include fields from multiple Forms in filter Notification Message ** Yes Ryan, I do hope to include all of the work info entries, not just the most recent. Your ideas are great; but, again, I wonder if there isn’t already a means of including fields from multiple forms into one filter, without having to create a new form or table or field on the primary form. Thanks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Downing, Ryan Sent: October-03-13 3:08 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Include fields from multiple Forms in filter Notification Message ** Hi Susan, There are a few ways to accomplish what you want to do…Tauf mentioned a good way….also…. Keep in mind that there is a one to many relationship between a task and work info records (many work info records per task record). Do you need all potential entries included? Or just the most recent? You could create a join form between TMS:Task and its Work Info form with all of the fields you need and either query the new join….or have notification workflow fire off of the join form (ensuring that any direct access URL is handled to point back to the real task form) You could add a table field to the TMS:Task form for the Work Info form to get any or all of the associated work info records to include in the filter notify…. Hope this helps, Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Champagne, Susan Sent: Thursday, October 03, 2013 3:00 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Include fields from multiple Forms in filter Notification Message ** Thanks Tauf; I will likely take this route, but…So, am I correct in assuming that there is no way to include fields from multiple forms in one filter? Susan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Tauf Chowdhury Sent: October-03-13 2:56 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Include fields from multiple Forms in filter Notification Message ** Susan, You could create workflow so that when the task is set to closed, you pull that data from the task work info form and append all the data you grab to the Notes field with some sort of delimiter. Then you can include the notes in your notification. If you don't want to use notes, you could create an additional field to hold this data. Sent from my iPhone On Oct 3, 2013, at 11:49 AM, "Champagne, Susan" <schampa...@hsnsudbury.ca<mailto:schampa...@hsnsudbury.ca>> wrote: ** Hi folks, I currently have a filter that sends a notification message to a task submitter, alerting him/her when a task status changes to “Closed”. I have been asked to add the Work Info fields, summary, notes, submitted by, and submitted date, to the notification message. I’m not finding anything in the guides that indicates how to pull fields into a filter notify action from multiple forms. Since the primary form is TMS:Task, I seem to be limited to using fields from this form only. Can anyone tell me if there is a way to include fields from another form? Tx Susan **************************************************************** The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ **************************************************************** The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ **************************************************************** The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ **************************************************************** The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
