Dan, Character menus are designed to show the Label and post the value. If this is an aesthetics issue then you need to change the menu type or use some trickery. Overlay the character menu with a character field, hide it and make it appear when you select the menu item. You will have to add an Active Link with an SQL set fields action to fill the new filed with the menu label. The Character Menu ID is stored in the char_menu table and the menu items are in the the char_menu_list table. psuedoSQL here. SELECT label from char_menu_list WHERE value = '$menufield$' and charMenuId = (select charNumId from char_menu WHERE name = '<name of your character menu>') You will have to play around with the syntax because your $menufield$ will equal things like 'Status' = "open" and the ticks and quotes need to be delimited. Once you get the select statement correct you set the new overlay field with the return value and show it with a change action. Sizing it correctly will make the transition seamless to the end user. HTH,
John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of ARS Dummie Sent: Wednesday, August 06, 2008 5:08 AM To: [email protected] Subject: Re: Displaying search menu's label after selecting it ** Hi John, thanks for the explanation. I am using a character menu. Means a menu which should only run hardcoded on that specific form. Sorry for the misunderstandings before. I just want to run this menu on that form and I would not like to use another form to fill in the data to that menu (as a search menu would do). For sure this is much nicer and flexible. But I was just wondering if there is no way to display the menu label instead of the menu value after selecting an entry from the menu. Dan On Tue, Aug 5, 2008 at 8:12 PM, Reiser, John J <[EMAIL PROTECTED]> wrote: ** Dan, Are you using a search menu? What Joe described is the way to do it with a Search menu. Basically you can set the Value Field in the search menu to same field for the label. Then use an Active Link on Menu / Row Choice to find the record in the Search menu's form and set qualification string to a zTmp_Field. Then use EXTERNAL(zTmp_Field). That is why I have a form for every application called XX:GenericForm (XX being the prefix for my application) Then I use it as a search menu source. If you set it up correctly you can even have one Search Menu called XX:GenericMenu that you can add to multiple fields on a form. The data stored in the XX:GenericForm handles which data goes with which field. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, August 05, 2008 1:37 PM To: [email protected] Subject: Re: Displaying search menu's label after selecting it ** Yes that is possible too except that you will need to create as many temporary fields as the number of qualifications that you may want which would also mean that it would not be dynamic.. Meaning 3 weeks later if you felt you missed out one or needed another one, you will need to create another temporary field to contain the qualification for that. The only possible way to make it dynamic would be a control form that contains all the qualifications for your various choices.. BTW I had done what you wanted by creating about 5 temporary fields as we knew we would not have any potential growth in the number of choices requirement. It wasn't my prefered method but time being a limitation on that project I did adopt what you want to do and hardcoded the required qualifications on 4 or 5 temporary fields and on opening the display only form set the defaults and took it from there.. Joe ----- Original Message ---- From: ARS Dummie <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, August 5, 2008 6:09:20 AM Subject: Re: Displaying search menu's label after selecting it ** Hi Joe, sounds like a good idea and very flexible to maintain. But on the other hand it is a bit oversized for my purpose. I thought there maybe is a way to do it with some active links and a temp field on the form where the character menu is placed on, so that I don't have to create a new form which contains the data. Cheers, Dan On Mon, Aug 4, 2008 at 7:12 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Dan, I think I understand what you are trying to do.. Why don't you store the external qualification that will be required for these options you are trying to build in another form, and then depending on your choices have your workflow to set the right quailification by querying that form.. This would be a flexible solution because down the line if you need to add more options you will just need to add entries to the other form with those additional qualifications, while you may not need to make any changes to your workflow if you design it to be dynamic.. What you could do is have numeric values for each menu options and use these same numeric values for searching the qualifications off the other form to get the right external qualification set.. Cheers Joe ----- Original Message ---- From: ARS Dummie <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, August 4, 2008 12:36:13 PM Subject: Displaying search menu's label after selecting it ** Hi listers, actually I think it should be easy... I have a search menu with different labels than values (I wanna use the values as an EXTERNAL qualification of a table field). How can I get the search menu's label displayed in the selection field after the user selected an entry from the menu? After selecting an entry there is always the value displayed. For example: I have a menu label ... All open tickets ... and a menu value ... 'Status' = "open" ..., and after selecting this value there is always the qualification displayed instead the label "All open tickets". Thanks for your help in advance. Dan __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
