Christoph,
Table fields are just a view of the data stored in a form. So your first part is correct. The left side table would show results of the Character field of Form 1. Why are you processing this as a table when a menu would do? You can select menu items and have then concatenated into a single character field on the ticket form. You can select an entry in the menu SET the entry into a character field on your Ticket Form. Then select a new entry and add the selection to the character field. This will take a little more processing in an active link. You must determine if the character field is empty, if it is just use a set fields to put the first value in. If not you need to use a SET fields with $Character_Field$+”, “+$Menu_Field$ to overwrite the field with the existing value and a comma and then the new value. This will keep going until you run out of space in the Character Field. There is more that can be done to count the remaining characters and check for duplicate selections but that would take too long. If the two table method is required and you want to display the multiple selections in a table on the Ticket Form then these values are children of the Ticket Form. Now you are creating new records in a separate form. So the action changes to a PUSH and during the PUSH you grab the Request_ID or better yet generate a GUID on the Ticket Form for each record so you have a value before it gets submitted. You are not actually pushing the value to the second Table Field on your form you are pushing it to the child form and then refreshing the table field to display what you selected and saved. I sure hope this didn’t confuse things even more. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst 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:arslist@ARSLIST.ORG] On Behalf Of Wagner, Christoph Sent: Monday, October 24, 2011 5:15 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: AW: kind of selection ** Dear listers, first of all thanks a lot for your answers but I still haven’t got it. I still have problems in understanding tables in remedy. If I want a table with one column und about 20 rows I need a new form [Form 1] with one character field [Char Field] and in that form 20 requests with different Char Field contents? I connect this form and the character field with the table. Then I have a table with fixed values. This would be ok for my left table. But how do I handle with the right table? My problem is that I want this kind of selection for my ticket-form. That means of course for each ticket different results in the right table. But I don’t know how to link the table with the request-ID of my ticket form. For that I need a three dimensional table, not only a two-one…I think it must be easier but I don’t how to do it. Please, can you help me? Thanks a lot! Regards Christoph Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Remedy Gesendet: Montag, 24. Oktober 2011 15:54 An: arslist@ARSLIST.ORG Betreff: Re: kind of selection ** >From the help files in developer studio, they have a step by step write up on >how move data back and forth between two tables. I found it while searching >for details on how to add rows to a table. Sent from my iPhone, so typo's or funky words can and do happen! On Oct 23, 2011, at 9:24 PM, Shafqat Ayaz <shafq...@yahoo.com> wrote: ** Hi Christoph you can achieve this with a simple flag on the form, say for example a field Show, which has two values, Show 1 and Show 2. The first table shows all entries with the flag set to 1, when you move the items from table one to two, just set the flag to Show 2 and reverse it back when the opposite happens. Set the qualification for the tables appropriately. That would be the simplest method, I am sure there are many more ways to do this. Shafqat Ayaz _____ From: "Wagner, Christoph" <christoph.wag...@ard-stern.de> To: arslist@ARSLIST.ORG Sent: Sunday, October 23, 2011 12:55 PM Subject: kind of selection ** Dear listers, is there any way to build a view as you can see in the screenshot (2 fields with add und remove button to push values from one table into another)? What is the real name of this kind of selection? I already tried this with two tables (list view) but for that kind of selection I have to build 2 new forms whereas I have to push the values from one to the other. But this is not what I want because the values are static. Any ideas? Thanks a lot. Regards Christoph Remedy Version 7.1 <image001.png> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature