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