Re: Appending Values to Char field from a List
Dave, That makes sense, especially if your Active Link Set Fields action is to use the first matching request. You could add a zTmp_Item and attach the menu to it with append check box Unchecked. Use the same active link to set the concatenated Items into the Item field while you are setting the concatenated Services into the Servcie Affected field. One for each selection from the display only filed with the menu. If it is critical to have this dynamic listing you may want to consider a child form and Table Field. Use the Item menu to select the pair and push them to the child form with a GUID ( or request ID) Then refresh the table to show the values. Hope this helps, --- John J. Reiser Senior 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:arsl...@arslist.org] On Behalf Of Boylan, David Sent: Wednesday, June 17, 2009 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Appending Values to Char field from a List If its a drop down character field, click the Append option. Joe Joe, This is what I did for the Item field but the problem is with the field that is being set - Services Affected. It will only set one value. I can append (and do) the Item. But one such problem is when I select more than one, say bc-bh-r; cw-cit-r ;dd-davol1-r it I only get the first Service in the Services Affected field which is just a plain character field with no menu. I need it to be in the Item field $Item$; $Item$: etc and the Services Affected field $Services$; $Services$; etc. Thanks, Dave _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Appending Values to Char field from a List
I have a request to append values from a pull down to a character field. I have a field called Item with a Search menu attached. When an Item is selected it sets a character field called Services Affected with the corresponding Service from the form that is called from the Search menu ( Network Devices). My users want to be able to select multiple Items, have them show in the Item field and append (list) the corresponding Services (from the Network Devices form) in the Services Affected character field. Is this possible? Has anyone done this? Right now I'm using an AL which works fine for the first Item selected. SQL Server 2005 ARS 7.0.1 Thanks, Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Appending Values to Char field from a List
You could code it to append value to the holding field in the AL. AL Set Field Pseudo Code: $Services Selected$ = $Services Selected$ + ; + $Item$ Thanks, Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Boylan, David Sent: Wednesday, June 17, 2009 10:16 AM To: arslist@ARSLIST.ORG Subject: Appending Values to Char field from a List ** I have a request to append values from a pull down to a character field. I have a field called Item with a Search menu attached. When an Item is selected it sets a character field called Services Affected with the corresponding Service from the form that is called from the Search menu ( Network Devices). My users want to be able to select multiple Items, have them show in the Item field and append (list) the corresponding Services (from the Network Devices form) in the Services Affected character field. Is this possible? Has anyone done this? Right now I'm using an AL which works fine for the first Item selected. SQL Server 2005 ARS 7.0.1 Thanks, Dave _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Appending Values to Char field from a List
If its a drop down character field, click the Append option. Joe From: Mark Lev mark@rightstarsystems.com To: arslist@ARSLIST.ORG Sent: Wednesday, June 17, 2009 10:22:56 AM Subject: Re: Appending Values to Char field from a List ** You could code it to append value to the holding field in the AL. AL Set Field Pseudo Code: $Services Selected$ = $Services Selected$ + “; ” + $Item$ Thanks, Mark From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Boylan, David Sent: Wednesday, June 17, 2009 10:16 AM To: arslist@ARSLIST.ORG Subject: Appending Values to Char field from a List ** I have a request to append values from a pull down to a character field. I have a field called “Item” with a Search menu attached. When an Item is selected it sets a character field called Services Affected with the corresponding “Service” from the form that is called from the Search menu ( Network Devices). My users want to be able to select multiple Items, have them show in the Item field and append (list) the corresponding Services (from the Network Devices form) in the Services Affected character field. Is this possible? Has anyone done this? Right now I’m using an AL which works fine for the first Item selected. SQL Server 2005 ARS 7.0.1 Thanks, Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Appending Values to Char field from a List
If its a drop down character field, click the Append option. Joe Joe, This is what I did for the Item field but the problem is with the field that is being set - Services Affected. It will only set one value. I can append (and do) the Item. But one such problem is when I select more than one, say bc-bh-r; cw-cit-r ;dd-davol1-r it I only get the first Service in the Services Affected field which is just a plain character field with no menu. I need it to be in the Item field $Item$; $Item$: etc and the Services Affected field $Services$; $Services$; etc. Thanks, Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are