Which form is holding the data that you imported from the file? Which form has the menu with the multi-row field?
What's the name of the field on the form holding the data? What's the name of the multi-row field? Let's get some names established so we can all be sure we're on the same sheet of music. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Wednesday, September 05, 2007 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu I can't exactly do that because I am firing the AL on the form which contains CC list Thus my AL will look like 'FIELD B' LIKE (("%" + $CC list$) + "%") So should I understand this has no chance to work ? Do I need to change the workflow to fire the check on the other form ? Then how my submission on form A will check the fire on form B ? I actually do not see how to run this on the web because the $PROCESS$ is not allowed on that platform. On the user tool ok fine I believe I can do it ... Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > I think you have the LIKE statement flipped. > > Create an Active Link and do a SET FIELDS. Set from your support form > that contains the records. I assume the field's name on that form is > 'CC List', correct? If so... > > SET FIELD IF: > > $FIELD B$ LIKE (("%" + 'CC List') + "%") > > -----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: arslist@ARSLIST.ORG > 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: arslist@ARSLIST.ORG >> 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: arslist@ARSLIST.ORG >>> 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: arslist@ARSLIST.ORG >>>> 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: arslist@ARSLIST.ORG >>>>> 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)" >>>>> <arslist@ARSLIST.ORG> >>>>> >>>>> 09/04/2007 08:33 AM >>>>> Please respond to >>>>> arslist@ARSLIST.ORG >>>>> >>>>> To >>>>> arslist@ARSLIST.ORG >>>>> 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: arslist@ARSLIST.ORG >>>>>> 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" > > ________________________________________________________________________ _______ 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"