Works like a charm !! Thanks guys, Susan
On 10/18/07, Susan Palmer <[EMAIL PROTECTED]> wrote: > > Dylan and Joe ... > > Thanks! So obvious now that you mention it. > > My appreciation, > Susan > > > On 10/18/07, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > > > ** Susan, > > > > If I understood you right, you need to pick an email address from a > > single record, or n number of email addresses from n records that match a > > company??? > > > > If that is the case, have you tried running an AL guide to loop through > > your contact form to find all records that match the company and set the > > email addresses accordingly? That should be doable.. > > > > You can loop either by creating a hidden table field to match your > > criteria to pull out those records, or build your own loop that will perform > > n searches for n records that meet the criteria. > > > > Hope this helps.. > > ** > > *Joe D'Souza* > > > > -----Original Message----- > > *From:* Action Request System discussion list(ARSList) > > [mailto:[email protected] > > ]*On Behalf Of *Susan Palmer > > *Sent:* Thursday, October 18, 2007 12:59 PM > > *To:* [email protected] > > *Subject:* Active Link Set Fields - need multiples to append > > > > ** Hi Everyone, > > > > Sometimes I get all caught up in 'the Remedy can do anything' > > scenario and agree to do things that may have limitations. This one seemed > > harmless, but alas I've been caught in the typical 'sales' syndrome. > > > > I need to populate email addresses that are of a certain type (Install > > Contact) into a field on the Task form (finding them is no problem). > > Created a field on the form with plenty of space since there could be 2-3 > > email addresses to set in that field. Went to create the Active Link on > > Display to set the email addresses on the Task when it is opened so that the > > automated email that may be initiated if certain criteria is met will use > > those email addresses. > > > > The issue I am having is setting more than one email address to that > > field. The criteria for finding the email addresses is that all these > > people are related to one company (specified on the Task via field > > contents). The A/L really wants me to choose one or none or give an error > > message. I need it to take however many are found and put a comma between > > them and put them all in the field. I thought I'd be able to append or > > something like that. > > > > I suspect I may be able to do this via sql but I'm not sure what the > > statement would be. But all suggestions are welcome ! > > > > Thanks for your help in advance, > > Susan > > > > Susan Palmer > > ShopperTrak > > > > Server ARS 7.0.1P2 on Windows 2003 > > Oracle 10g > > Admin/User 7.0.1P3 > > > > __20060125_______________________This posting was submitted with HTML in > > it___ > > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
