Chad, This worked out GREAT and really was so simple. I did the html formatting right in the 'answer' filter and the email looks wonderful.
I made a mountain out of mole hill, but you brought it into perspective. Thank you so much !!! Susan On Jan 14, 2008 2:59 PM, Hall Chad - chahal <[EMAIL PROTECTED]> wrote: > ** > > If you don't care about formatting, create 6 filters (one for each > question) to add the negative responses (and their questions) to a single > character field. Then include that character field in your notification. > > > > If you need the questions formatted for HTML or something, I don't know. > I'm sure there's a way, but having not dealt with HTML templates I can't > really speak to that. > > > > *Chad Hall* > (501) 342-2650 > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Susan Palmer > *Sent:* Monday, January 14, 2008 2:53 PM > *To:* [email protected] > *Subject:* Automated email with many permutations > > > > ** > > Hi Everyone, > > > > Since we installed the v7.x email engine last summer we've put in place > numerous emails successfully. Some require manual intervention to select > the recipient and some are automated. Most of these emails go to external > customers so great care is taken to insure they work right and they look > very professional. All that said ... > > > > We do tech visits for installations at external customer locations. When > the tech initially arrives they call for a check in number and that kicks > off an automated email letting the designated customer contact know there is > a tech on site. Works great. > > > > When the tech is done (check-out) we want to do one saying the > Installation is complete. That one is easy. The one that is causing me a > little heartburn is when the installation is NOT complete. > > > > We have a NOT complete checklist with 6 questions, yes/no answers. We > want to include the responses to those questions in the email. BUT we only > want to show prepared responses for the ones with negative issues, not the > whole list of questions. When I initially looked at this request I didn't > think much about it. > > > > BUT, now that I'm to the point of including those negative answers in the > email I realize the number of permutations that can exist between six > questions. The questions are Yes/No answers, see below: > > > > 1. Was the Tech properly prepared for the installation? Y/*N* > > If *N*o, how was he/she not prepared to complete the task? > (character field) > > 2. Did the store staff impact tech's ability to complete the install on > time? *Y*/N > > 3. Did the tech run out of time prior to completing the installation > task? *Y*/N > > 4. Was the install impacted by network or connectivity issues? *Y*/N > > 5. Was the right or enough (or any) ST equipment on site for Installation > Tech? Y/*N* > > 6. Will this site most likely require a revisit? *Y*/N > > Briefly explain any other details as to why this site was not > completed. (character field) > > If Q1 = N the email should say: Tech was not properly prepared for the > installation. Tech was missing (whatever is listed in the if No, ..... > character field) > > If Q2 = Y the email would say: Store staff asked that t he technician > stop working. > > If Q3 = Y: Store was opening and the tech could not finish the work in > time. > > etc. > > > > So it could be that we have to show > > Q1, Q1ifNo, Q3 or > > Q2 or > > Q3, Q4 or > > Q5, Q6 or > > Q2, Q4, Q5 etc etc etc > > > > I wanted just to include all 6 Q&A's but they thought it would be too > confusing for customers, they only want to show the negative answer ones. > > > > I hope one of you has a good idea for me. Of course the email has a > pretty header, some lead-in text with field values, then the Q's, then a > footer. > > > > Please help ..... thanks in advance, > > Susan > > > > *Susan Palmer* > > Enterprise Remedy Developer and Administrator > > *ShopperTrak RCT Corporation* > > 200 W Monroe St 11th Floor > > Chicago, IL 60606 > > Office 312-529-5325 > > Cell 312-502-7687 > > > > ARS v7.0.1P3 > > Oracle 10g > > Email v7.0.1P5 (P5 fixed P3 random duplicate emails) > > Server Windows 2003 > > Admin/Users v7.0.1P3 > > Use Notepad++ for html editing > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > *************************************************************************** > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be legally > privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank You. > **************************************************************************** > > __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"
