Neel ,
We've got some of these- I built a form with 4 fields- Menu Name, Menu
Label, Menu Value, Status. Basically, for each blank we want, we choose the
Search Menu that it is to be added to, set the Status to Active, then save
without a Label or Value. All the menus using this form are set to
Could you use an sql menu?
Then maybe an sql statement along the lines of (for Oracle) the following
will give you what you need:
select value,value from form union select 'Clear', 'a' from dual
order by 2
_
From: Action Request System discussion list(ARSList)
Hello listers,
I've a character menu that does a look-up on some other form to grab a
list of available values. I would like to add a blank value on top of
the menu item. Any ideas as to how this can be done?
Thanks in advance.
Neel Gautam
This message is for the designated
Add a blank record to the form you're pulling from. Sorry to provide
the obvious solution that you've probably already ruled out!
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Neel Guatam
Sent: Friday, June 15,
I'm assuming that the value of the field in question is so that the user can
add some sort of supporting data for a subsequent ticket/record submission.
My question is: If blank, NULL, nothing (pick your word) is an acceptable
value, then can't they just not select anything and skip the field?
Hi Norm,
I can't add that as this form from which I'm pulling values from, pulls
values in turn from another form and stuff like that and they are like
the required values and I can't even have a record saved on that form
with a blank value :-( btw I'm using 7.0.01
Neel Gautam
Tim, in general, this would be required if you had decided to display a
character field menu as text or as a drop-down field. In those instances,
once a value is selected, there's no way to unselect a value without
selecting another value. The Clear selection satisfies the requirement
without
What is the need in this? Like someone already suggested, just have them
skip this field. Are you needing to trigger workflow fired on Menu
Choice? If so, add a button by the field that says Blank and have them
push that button, which then fires the workflow (FYI: This is not a very
streamlined
I would just add a record that has a value of something like CLEAR
so it shows up at the top of the list, and when a user selects that
value in the menu, you kick off an Active Link on Menu Choice that sets
the field to $NULL$. This prevents you from adding a Clear button to
the form and taking
Sometimes I can't see the forest for the trees
:-)
Ok point noted, and I've had that requirement, and the customer didn't like
a blank entry. It wasn't naturally intuitive and was inconsistent with the
verbiage of Drop Down fields, which has the (clear) option. In that case we
added a
So the field (on the form the user is interfacing) is a required field that
must have a value? Or just required on the back end storage form?
Tim
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Neel Guatam
Sent: Friday, June 15, 2007 3:39
Basically the need is that if there's a value in the drop-down then all
other fields should be populated accordingly and when a user selects a
value that's when active link will fire so everything works fine EXCEPT
when a page loads, there's first value selected in the drop-down by
default but it
Rick,
Is it possible to select (clear) by default and have no value in the
character menu drop-down (display type is drop-down)? (using ARS 7.0.01
patch 001)
Neel Gautam
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On
If I recall correctly, there is no default value (i.e. the field is NULL)
for that type of field. The problem only occurs when a value is selected,
perhaps by mistake. At that point, the only way to clear that value without
clearing the form is to have a (clear) value added to the list.
Rick
Can't add that 'cos like I said the menu grabs records from another form
and that form can not have a blank or a clear record 'cos even that form
grabs values from another form which is actually a Unique Identifier :-(
Neel Gautam
From: Action Request
I think he's saying to add a record that is CLEAR, not a NULL record, IE
you have a record with a number that has the word clear in it, and when
that record is called have work flow set the fields to NULL.
From: Action Request System discussion list(ARSList)
16 matches
Mail list logo