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"
Re: how to read the whole content of a drop-down menu
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"
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"
Re: how to read the whole content of a drop-down menu
You put $MENU$ in the PATTERN property of the field with the menu in question attached to it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Tuesday, September 04, 2007 10:34 AM To: arslist@ARSLIST.ORG 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
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)" 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.*** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: how to read the whole content of a drop-down menu
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)" 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"
Re: how to read the whole content of a drop-down menu
well this is what I did now. On first try I just putthe $MENU$ in the AL I created. So now I proceed as you are mentioning. But then excuse me but what next ? Actually I don't really see how that should change the situation ? Could you give more tips on that please ? Thanks Serouche Kaiser Norm E CIV USAF 96 CS/SCCE wrote: You put $MENU$ in the PATTERN property of the field with the menu in question attached to it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Tuesday, September 04, 2007 10:34 AM To: arslist@ARSLIST.ORG 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" ___ 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"
Re: how to read the whole content of a drop-down menu
the run process won't work as my concern is on the web. I shall try your first idea. Thanks Serouche Thad K Esser wrote: ** 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)" 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"
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)" 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"
Re: how to read the whole content of a drop-down menu
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)" > > > 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, includin
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)" 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
Re: how to read the whole content of a drop-down menu
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)" >> >> >> 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
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)" 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,
Re: how to read the whole content of a drop-down menu
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 pu
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
Re: how to read the whole content of a drop-down menu
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: 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 &
Re: how to read the whole content of a drop-down menu
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 cont
Re: how to read the whole content of a drop-down menu
no. $CC list$ is about logins. One per line. $Field B$ is exactly what Kaiser Norm described. i.e one string per entry Opela, Gary L Contr OC-ALC/ITMA wrote: 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: 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
Re: how to read the whole content of a drop-down menu
The wildcard(s) in a LIKE statement are on the right side of the LIKE. Since you have to deal with multiple values in the CC field, what you will have to do is to loop thru the $CC list$ field and parse the values into a temp Display Only field and compare the temp field with the mailing list field. Something like ... 1. Set TempField1 = $CC list$ 2. if TempField1 contains a Return (line feed) grab the value up to the Carriage Return and put it in TempField2 remove TempField2 (including the Carriage Return) data from TempField1 else set TempField2 = TempField1 set TempField1 = $NULL$ 3. compare $Field B$ to TempField2 ( $Field B$ LIKE (("%" + $TempField2$) + "%") ) do what you need to if the data is in Temp B 4. if TempField1 != $NULL$ ( more values to check) goto 2 Fred -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
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
Re: how to read the whole content of a drop-down menu
You could always do this in Filters (when they hit the Save). -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:[
Re: how to read the whole content of a drop-down menu
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 hi
Re: how to read the whole content of a drop-down menu
Serouche, I think your original question may have lead all of us down a path that works but is becoming increasingly difficult. One of your recent statements has made me rethink your original question. If I understand correctly, you want folks to be able to populate a field from a menu but you don't want them to be able to type in to the field. Have you tried setting the Display Type on the field to Drop-Down List? This sets up the menu in a manner that prevents individuals from typing directly in the field. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Wednesday, September 05, 2007 11: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... >
Re: how to read the whole content of a drop-down menu
Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like (("%" + $CC list) + "%") LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE (("%" + $CC list) + "%") ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: Serouche, I think your original question may have lead all of us down a path that works but is becoming increasingly difficult. One of your recent statements has made me rethink your original question. If I understand correctly, you want folks to be able to populate a field from a menu but you don't want them to be able to type in to the field. Have you tried setting the Display Type on the field to Drop-Down List? This sets up the menu in a manner that prevents individuals from typing directly in the field. Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: how to read the whole content of a drop-down menu
I would suggest using the Drop-Down List on the CC List field for the menu. This will stop folks from manually typing values. I would then have an Active Link that fires on menu choice to set another field with the corresponding mailing list. The Active Link would be set up to append to this field. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Thursday, September 06, 2007 3:26 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like (("%" + $CC list) + "%") LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE (("%" + $CC list) + "%") ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: > Serouche, > > I think your original question may have lead all of us down a path that > works but is becoming increasingly difficult. One of your recent > statements has made me rethink your original question. If I understand > correctly, you want folks to be able to populate a field from a menu but > you don't want them to be able to type in to the field. > > Have you tried setting the Display Type on the field to Drop-Down List? > This sets up the menu in a manner that prevents individuals from typing > directly in the field. > > Dave > > ___ 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"
Re: how to read the whole content of a drop-down menu
many thanks to the people who added comments to this issue. FYI, at the end, I did something pretty similar to the solution presented here by Fred. At the same time I wrote my first Filter Guide so I got to know how goood the Remedy is ! What I do is: 1- if CC list != $NULL$ then tempfield-1 = CC List 2- tempfield-2 = first line of tempfield-1 3- check if mailing-list exist for this tempfield-2 4- if not, clean first line of tempfield-1 and tempfield-2 5- if next line exist in tempfield-1 go to 2 and loop :-) ... now I have something more difficult to do. So I'll probably get back to you later on the to-be-followed ;-) Cheers Serouche Grooms, Frederick W wrote: The wildcard(s) in a LIKE statement are on the right side of the LIKE. Since you have to deal with multiple values in the CC field, what you will have to do is to loop thru the $CC list$ field and parse the values into a temp Display Only field and compare the temp field with the mailing list field. Something like ... 1. Set TempField1 = $CC list$ 2. if TempField1 contains a Return (line feed) grab the value up to the Carriage Return and put it in TempField2 remove TempField2 (including the Carriage Return) data from TempField1 else set TempField2 = TempField1 set TempField1 = $NULL$ 3. compare $Field B$ to TempField2 ( $Field B$ LIKE (("%" + $TempField2$) + "%") ) do what you need to if the data is in Temp B 4. if TempField1 != $NULL$ ( more values to check) goto 2 Fred ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: how to read the whole content of a drop-down menu
Serouche, I would use a regular form to hold each of the banned email addresses, as suggested by Norm. Besides making it easier to search using a regular form allows for easy updating. You could also delegate the responsibility for maintaining the content of this form to someone else. In a set of active links loop through each email address the user entered in the $CC List$ field. Use a Set Fields command to search the new BannedEmailAddress form to see if the address is found. If found, then display a message to the user. To loop through each email address in the $CC List$ field test for the separator (space, comma, semi-colon, etc.) in the Run If qualification. Use a Set Fields with the LEFT() and STRSTR() functions to extract out a single email address to a temp field. For example, AL1 - Execution Order 1 Run If: blank If Action 1: Set Fields the value of $CC List$ to $zTmp Char1$ AL2 - Execution Order 2 Run If: 'zTmp Char 1' LIKE "%,%" If Action 1: Set Fields the value of RTRIM(LTRIM(LEFT($zTmp Char 1$, STRSTR($zTmp Char 1$, "," to $zTmp Char 2$ If Action 2: Set Fields the value of RTRIM(LTRIM(SUBSTR($zTmp Char 1$, STRSTR($zTmp Char 1$, ",") + 1))) to $zTmp Char 1$ Else Action 1: Set Fields the value of RTRIM(LTRIM($zTmp Char 1$)) to $zTmp Char 2$ Else Action 2: Set Fields the value of $NULL$ to $zTmp Char 1$ AL3 - Execution Order 3 Run If: 'zTmp Char 2' > "" If Action 1: Set Fields from the BannedEmailAddress form with 'Email Address' = $zTmp Char 2$ ...the Request ID of the matching BannedEmailAddress record is stored in $zTmp Char 3$ AL4 - Execution Order 4 Run If: 'zTmp Char 2' > "" AND 'zTmp Char 3' != $NULL$ If Action 1: Message of Address $zTmp Char 2$ is banned. If Action 2: Goto 1000 AL5 - Execution Order 5 Run If: 'zTmp Char 1' != $NULL$ If Action 1: Goto 2 The above example uses the comma as the separator. You could use the REPLACE() function in AL1 to change spaces, semi-colons, etc into commas. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Thursday, September 06, 2007 3:26 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like (("%" + $CC list) + "%") LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE (("%" + $CC list) + "%") ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: > Serouche, > > I think your original question may have lead all of us down a path that > works but is becoming increasingly difficult. One of your recent > statements has made me rethink your original question. If I understand > correctly, you want folks to be able to populate a field from a menu but > you don't want them to be able to type in to the field. > > Have you tried setting the Display Type on the field to Drop-Down List? > This sets up the menu in a manner that prevents individuals from typing > directly in the field. > > Dave > > ___ 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"
Re: how to read the whole content of a drop-down menu
While this will certainly work, I still think it's more complicated than it needs to be. Using a LIKE statement can be used to find a match with a "banned" record. Set a hidden display only field with that value. Do that with AL1. With AL2, if the hidden field is not null, throw error. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, September 06, 2007 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Serouche, I would use a regular form to hold each of the banned email addresses, as suggested by Norm. Besides making it easier to search using a regular form allows for easy updating. You could also delegate the responsibility for maintaining the content of this form to someone else. In a set of active links loop through each email address the user entered in the $CC List$ field. Use a Set Fields command to search the new BannedEmailAddress form to see if the address is found. If found, then display a message to the user. To loop through each email address in the $CC List$ field test for the separator (space, comma, semi-colon, etc.) in the Run If qualification. Use a Set Fields with the LEFT() and STRSTR() functions to extract out a single email address to a temp field. For example, AL1 - Execution Order 1 Run If: blank If Action 1: Set Fields the value of $CC List$ to $zTmp Char1$ AL2 - Execution Order 2 Run If: 'zTmp Char 1' LIKE "%,%" If Action 1: Set Fields the value of RTRIM(LTRIM(LEFT($zTmp Char 1$, STRSTR($zTmp Char 1$, "," to $zTmp Char 2$ If Action 2: Set Fields the value of RTRIM(LTRIM(SUBSTR($zTmp Char 1$, STRSTR($zTmp Char 1$, ",") + 1))) to $zTmp Char 1$ Else Action 1: Set Fields the value of RTRIM(LTRIM($zTmp Char 1$)) to $zTmp Char 2$ Else Action 2: Set Fields the value of $NULL$ to $zTmp Char 1$ AL3 - Execution Order 3 Run If: 'zTmp Char 2' > "" If Action 1: Set Fields from the BannedEmailAddress form with 'Email Address' = $zTmp Char 2$ ...the Request ID of the matching BannedEmailAddress record is stored in $zTmp Char 3$ AL4 - Execution Order 4 Run If: 'zTmp Char 2' > "" AND 'zTmp Char 3' != $NULL$ If Action 1: Message of Address $zTmp Char 2$ is banned. If Action 2: Goto 1000 AL5 - Execution Order 5 Run If: 'zTmp Char 1' != $NULL$ If Action 1: Goto 2 The above example uses the comma as the separator. You could use the REPLACE() function in AL1 to change spaces, semi-colons, etc into commas. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Thursday, September 06, 2007 3:26 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like (("%" + $CC list) + "%") LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE (("%" + $CC list) + "%") ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: > Serouche, > > I think your original question may have lead all of us down a path that > works but is becoming increasingly difficult. One of your recent > statements has made me rethink your original question. If I understand > correctly, you want folks to be able to populate a field from a menu but > you don't want them to be able to type in to the field. > > Have you tried setting the Display Type on the field to Drop-Down List? > This sets up the menu in a manner that prevents individuals from typing > directly in the field. > > Dave > > ___
Re: how to read the whole content of a drop-down menu
again many thanks to you guys for your ideas and guidelines. But this problem has been resolved. Cheers Serouche Kaiser Norm E CIV USAF 96 CS/SCCE wrote: While this will certainly work, I still think it's more complicated than it needs to be. Using a LIKE statement can be used to find a match with a "banned" record. Set a hidden display only field with that value. Do that with AL1. With AL2, if the hidden field is not null, throw error. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, September 06, 2007 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Serouche, I would use a regular form to hold each of the banned email addresses, as suggested by Norm. Besides making it easier to search using a regular form allows for easy updating. You could also delegate the responsibility for maintaining the content of this form to someone else. In a set of active links loop through each email address the user entered in the $CC List$ field. Use a Set Fields command to search the new BannedEmailAddress form to see if the address is found. If found, then display a message to the user. To loop through each email address in the $CC List$ field test for the separator (space, comma, semi-colon, etc.) in the Run If qualification. Use a Set Fields with the LEFT() and STRSTR() functions to extract out a single email address to a temp field. For example, AL1 - Execution Order 1 Run If: blank If Action 1: Set Fields the value of $CC List$ to $zTmp Char1$ AL2 - Execution Order 2 Run If: 'zTmp Char 1' LIKE "%,%" If Action 1: Set Fields the value of RTRIM(LTRIM(LEFT($zTmp Char 1$, STRSTR($zTmp Char 1$, "," to $zTmp Char 2$ If Action 2: Set Fields the value of RTRIM(LTRIM(SUBSTR($zTmp Char 1$, STRSTR($zTmp Char 1$, ",") + 1))) to $zTmp Char 1$ Else Action 1: Set Fields the value of RTRIM(LTRIM($zTmp Char 1$)) to $zTmp Char 2$ Else Action 2: Set Fields the value of $NULL$ to $zTmp Char 1$ AL3 - Execution Order 3 Run If: 'zTmp Char 2' > "" If Action 1: Set Fields from the BannedEmailAddress form with 'Email Address' = $zTmp Char 2$ ...the Request ID of the matching BannedEmailAddress record is stored in $zTmp Char 3$ AL4 - Execution Order 4 Run If: 'zTmp Char 2' > "" AND 'zTmp Char 3' != $NULL$ If Action 1: Message of Address $zTmp Char 2$ is banned. If Action 2: Goto 1000 AL5 - Execution Order 5 Run If: 'zTmp Char 1' != $NULL$ If Action 1: Goto 2 The above example uses the comma as the separator. You could use the REPLACE() function in AL1 to change spaces, semi-colons, etc into commas. HTH Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"