Serouche, Is the $CC list$ the list of valid email address from the text file? Is the $Field B$ the field in which the user enters data. Might there be more than one email address entered in $Field B$?
Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Wednesday, September 05, 2007 9:19 AM To: [email protected] Subject: Re: how to read the whole content of a drop-down menu well if I try $CC list$ = $Field B$ that works but if try (("%" + $CC list$ ) + "%") LIKE $Field B$ that doesn't work. My guess is that $CC list$ contains one string per line. So my concern now is how to make this field be red as one string. The $PROCESS$ of course doesn't work on the web. Any help ? Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > Yes, it should work. If you format the LIKE statement correctly, it > should work. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour > Sent: Wednesday, September 05, 2007 8:16 AM > To: [email protected] > Subject: Re: how to read the whole content of a drop-down menu > > many thanks for this feedback. I believe it will most probably work this > > way. > How ever, I am working on something pretty close to this idea. And I am > encountering a problem which I believe I will also have when trying your > > solution. > It is the following: > in the field where users type in, they insert email addresses. They do > so by typing each email address on a new line. And at the moment what I > don't get the Remedy do is to compare correctly something like (("%" + > $CC list$) + "%") with the $mailing-list$ field. > That doesn't simply work. I am wondering whether this is my mistake > somewhere or this because of the every line on my original field ?!? > Will it work correctly with the solution you are giving ?? > ... > Serouche > > > > > Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > >> Does this have to stay as a file? If not, save a copy of the file as a >> CSV. Then create a new support form with one field on it. Call that >> field "Email" or whatever you want. Use the import tool to import the >> email addresses in the file (which is now a CSV) into the form. Now >> > you > >> have one Remedy record for every entry in the file. >> >> Now just automate what you want to do with workflow. Put a hidden >> > field > >> under your character field on form B, and on Submit (or whatever event >> you want), do a SET FIELDS. Set the hidden field if... >> >> Character Field on Form B = Record in New Form You Just Created >> >> Then have a second active link that throws an error if the hidden >> > field > >> is not null. >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour >> Sent: Wednesday, September 05, 2007 7:54 AM >> To: [email protected] >> Subject: Re: how to read the whole content of a drop-down menu >> >> what I mean is that Remedy users type in what they are by policy not >> allowed to type i.e mailing-lists >> these mailing-lists are in a file outside the Remedy >> so my problem is: how can I make the Remedy read the file, compare the >> > > >> content with what people type. And every time a user type in something >> > > >> which is found in that file, the Remedy should say "error guy !" >> The file is about 900 lines with one value per line. Of course I could >> > > >> change the format of the file (still being always on my Unix box). >> The field where people type in is a character field. >> Any help ? >> >> >> >> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >> >> >>> What do you mean by "...bounce people from adding mailing-lists into >>> the CC list field"? Do you mean you want to force people to use the >>> values as presented in the menu and prevent them from typing stuff >>> > in? > >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour >>> Sent: Wednesday, September 05, 2007 2:43 AM >>> To: [email protected] >>> Subject: Re: how to read the whole content of a drop-down menu >>> >>> maybe I shall give more details on my problem and the situation: >>> I have a file with a list of mailing-lists >>> I have created a form (A) with one character field which reads the >>> >>> >> file >> >> >>> and displays it as a menu >>> I have another form (B) with a character field where people add >>> > emails > >>> >>> >> >> >>> (CC list). >>> What I'd like to do is to bounce people from adding mailing-lists >>> > into > >>> >>> >> >> >>> the CC list field. :-) >>> ... >>> I can't get it :-( >>> ... >>> any help ? >>> Thanks >>> Serouche >>> >>> >>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >>> >>> >>> >>>> Or better yet, create a form specifically for the menu items and >>>> > then > >>>> importing the items from the file into the form? Then field >>>> >>>> >> validation >> >> >>>> is extremely easy...and you don't have nitnoid separate files to >>>> maintain. >>>> >>>> -----Original Message----- >>>> From: Action Request System discussion list(ARSList) >>>> [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser >>>> Sent: Tuesday, September 04, 2007 12:24 PM >>>> To: [email protected] >>>> Subject: Re: how to read the whole content of a drop-down menu >>>> >>>> ** >>>> Have you tried pulling the file that your menu reads from into an >>>> unlimited length, display only field and then using string functions >>>> (such as STRSTR) to find if the value entered is in the list? >>>> >>>> If that doesn't work maybe a run process utilizing grep or find? >>>> >>>> Thad Esser >>>> Remedy Developer >>>> "Argue for your limitations, and sure enough, they're yours."-- >>>> >>>> >>>> >>> Richard >>> >>> >>> >>>> Bach >>>> >>>> >>>> >>>> "Serouche Rahimpour" <[EMAIL PROTECTED]> >>>> Sent by: "Action Request System discussion list(ARSList)" >>>> <[email protected]> >>>> >>>> 09/04/2007 08:33 AM >>>> Please respond to >>>> [email protected] >>>> >>>> To >>>> [email protected] >>>> cc >>>> Subject >>>> Re: how to read the whole content of a drop-down menu >>>> >>>> >>>> >>>> >>>> >>>> >>>> I just tried with $MENU$ and the browser (because it has to be on >>>> > the > >>>> >>>> >> >> >>>> web) returns $MENU$ in the field. >>>> I checked afterwards in the Admin tool. It has corrected $MENU$ for >>>> "$MENU$" >>>> Another idea ? >>>> >>>> >>>> Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >>>> >>>> >>>> >>>> >>>>> I'm not sure if it works with menus built from external files, but >>>>> >>>>> >>>>> >>>>> >>>> have >>>> >>>> >>>> >>>> >>>>> you tried $MENU$? >>>>> >>>>> -----Original Message----- >>>>> From: Action Request System discussion list(ARSList) >>>>> [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour >>>>> Sent: Tuesday, September 04, 2007 10:19 AM >>>>> To: [email protected] >>>>> Subject: how to read the whole content of a drop-down menu >>>>> >>>>> hi, >>>>> >>>>> let say I have a drop-down menu which values come from a Menu which >>>>> > > >>>>> reads itself from a file. >>>>> Let say on another form I have a character field and I want to >>>>> > check > >>>>> >>>>> >>>>> >>>>> >>>> the >>>> >>>> >>>> >>>> >>>>> content of this field (what users type in) is or is not in the >>>>> >>>>> >>>>> >>>>> >>>> drop-down >>>> >>>> >>>> >>>> >>>>> menu. >>>>> I tried with different filters and AL but each time I am not able >>>>> > to > >>>>> >>>>> >> >> >>>>> read the whole list (about 900 entries in the drop-down list.) >>>>> Any idea/help/questions? >>>>> Many thanks. >>>>> Cheers >>>>> Serouche >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> > ________________________________________________________________________ > >> >> >>> >>> >>> >>>> >>>> >>>> >>>> >>>>> _______ >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> >>>>> >>>>> >>>>> >>>> ARSlist:"Where >>>> >>>> >>>> >>>> >>>>> the Answers Are" >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> > ________________________________________________________________________ > >> >> >>> >>> >>> >>>> _______ >>>> >>>> >>>> >>>> >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> >>>>> >>>>> >>>>> >>>> ARSlist:"Where the Answers Are" >>>> >>>> >>>> >>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> > ________________________________________________________________________ > >> >> >>> >>> >>> >>>> _______ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> >>>> >>>> >>> ARSlist:"Where >>> >>> >>> >>>> the Answers Are" >>>> >>>> >>>> >>>> >>>> ***IMPORTANT NOTICE: This communication, including any attachment, >>>> contains information that may be confidential or privileged, and is >>>> intended solely for the entity or individual to whom it is >>>> > addressed. > >>>> >>>> >>>> >>> If >>> >>> >>> >>>> you are not the intended recipient, you should delete this message >>>> >>>> >> and >> >> >>>> are hereby notified that any disclosure, copying, or distribution of >>>> this message is strictly prohibited. Nothing in this email, >>>> > including > >>>> any attachment, is intended to be a legally binding signature.*** >>>> >>>> >>>> __20060125_______________________This posting was submitted with >>>> > HTML > >>>> >>>> >>>> >>> in >>> >>> >>> >>>> it___ >>>> >>>> >>>> >>>> >>>> > ________________________________________________________________________ > >> >> >>> _______ >>> >>> >>> >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> >>>> >>>> >>> ARSlist:"Where the Answers Are" >>> >>> >>> >>>> >>>> >>>> >>>> >>> >>> > ________________________________________________________________________ > >> >> >>> _______ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> >>> >> ARSlist:"Where >> >> >>> the Answers Are" >>> >>> >>> >>> > ________________________________________________________________________ > >> _______ >> >> >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> >>> >> ARSlist:"Where the Answers Are" >> >> >>> >>> >>> >> > ________________________________________________________________________ > >> _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > ARSlist:"Where > >> the Answers Are" >> >> >> > ________________________________________________________________________ > _______ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > ARSlist:"Where the Answers Are" > >> >> > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
