Re: Adding Clear to a Menu
Rick, A lot of my smaller menu's work fine as a drop down list. This is a larger menu and it is off a drop down list, but no clear. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, August 26, 2008 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Adding Clear to a Menu ** You can have that happen automatically by changing the display type of the menu-attached character field to Drop-down. That makes the field un-editable (i.e. looks like a legitimate drop-down field; i.e. Status), and adds the Clear selection at the bottom of the list. Rick On Tue, Aug 26, 2008 at 7:01 AM, T. Dee [EMAIL PROTECTED] wrote: What we did is in the Menu we added Field 1 to Label fields, but we set Value Field to Field 2. The Form that contained our Data we had data as follows: Field 1: Blue Field 2: Blue Field 1: Orange Field 2: Orange Field 1: Green Field 2: Green Field 1: (Clear) Field 2: So when the user clicked on the pull down they would see: Blue Orange Green (Clear) And because my Menu was set to use the Value FIeld of Field 2 - if they selected (Clear) they got a blank set. If they choose any other colour they got the colour they selected. Clear as mud? Hope this helps - let me know if you need more details. On Tue, Aug 26, 2008 at 9:50 AM, Timothy Rondeau [EMAIL PROTECTED] wrote: ** Hi All, How to I have a clear option on a Menu? I know I can add a menu item clear and have workflow, but I have a menu that pulls fields from another form and I do not have the clear option. This is 7.0.1 patch 2 Thanks Tim __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding Clear to a Menu
What we did is in the Menu we added Field 1 to Label fields, but we set Value Field to Field 2. The Form that contained our Data we had data as follows: Field 1: Blue Field 2: Blue Field 1: Orange Field 2: Orange Field 1: Green Field 2: Green Field 1: (Clear) Field 2: So when the user clicked on the pull down they would see: Blue Orange Green (Clear) And because my Menu was set to use the Value FIeld of Field 2 - if they selected (Clear) they got a blank set. If they choose any other colour they got the colour they selected. Clear as mud? Hope this helps - let me know if you need more details. On Tue, Aug 26, 2008 at 9:50 AM, Timothy Rondeau [EMAIL PROTECTED] wrote: ** Hi All, How to I have a clear option on a Menu? I know I can add a menu item clear and have workflow, but I have a menu that pulls fields from another form and I do not have the clear option. This is 7.0.1 patch 2 Thanks Tim __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding Clear to a Menu
You can have that happen automatically by changing the display type of the menu-attached character field to Drop-down. That makes the field un-editable (i.e. looks like a legitimate drop-down field; i.e. Status), and adds the Clear selection at the bottom of the list. Rick On Tue, Aug 26, 2008 at 7:01 AM, T. Dee [EMAIL PROTECTED] wrote: What we did is in the Menu we added Field 1 to Label fields, but we set Value Field to Field 2. The Form that contained our Data we had data as follows: Field 1: Blue Field 2: Blue Field 1: Orange Field 2: Orange Field 1: Green Field 2: Green Field 1: (Clear) Field 2: So when the user clicked on the pull down they would see: Blue Orange Green (Clear) And because my Menu was set to use the Value FIeld of Field 2 - if they selected (Clear) they got a blank set. If they choose any other colour they got the colour they selected. Clear as mud? Hope this helps - let me know if you need more details. On Tue, Aug 26, 2008 at 9:50 AM, Timothy Rondeau [EMAIL PROTECTED] wrote: ** Hi All, How to I have a clear option on a Menu? I know I can add a menu item clear and have workflow, but I have a menu that pulls fields from another form and I do not have the clear option. This is 7.0.1 patch 2 Thanks Tim __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Adding Clear to a Menu
You could use an SQL menu with a union clause. Example MSSQL syntax. Select ,value. From ,form. Where qual Union Select '(CLEAR)' Order by 1 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Rondeau Sent: 26 August 2008 14:51 To: arslist@ARSLIST.ORG Subject: Adding Clear to a Menu Importance: High Hi All, How to I have a clear option on a Menu? I know I can add a menu item clear and have workflow, but I have a menu that pulls fields from another form and I do not have the clear option. This is 7.0.1 patch 2 Thanks Tim __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are