Change it to 1 set fields action: Name Value
ztmpConsol5 $ztmpConsol5$ + ";") + $Col1$ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, June 02, 2009 4:28 PM To: [email protected] Subject: Re: 911: Walking a Table ** Interesting - I created two Active Links as suggested, and had the 2nd AL call the guide. Now Field A is being set with the second number only (PO4523 us being set in the fields) - when I really need both values from the Purchase Number column to be set into the field. Scenario: I have two entries in Table "New" Purchase Number PO4453..... PO4523 When the user selects the two entries within the Table "New" - I want to push both of the numbers into Field A. Before, the first value was being pushed into Field A. Now the code is pushing the second value only into Field A. I feel like I am so close - something is missing... I have 2 set fields actions: Name Value ztmpConsol1 $Col1$ ztmpConsol5 $ztmpConsol1$ + ";") + $Col1$ I am trying to get the system to know two items are selected, and to push both values into field A. In a message dated 6/2/2009 3:16:38 P.M. Central Daylight Time, [email protected] writes: ** I think your only problem is you are setting Field A with TableFieldValue when it should be set to Field A + “;” + TableFieldValue (You can use anything you want as a delimiter between the values) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, June 02, 2009 2:37 PM To: [email protected] Subject: 911: Walking a Table Hi All, I have been working on this code a long time now... and from reading the technical guide, Remedy can walk a table using AL Guides. My objective: I have a table. Based upon the rows that the user selects, I want to push the row values into a field. My understanding is that I can do this by creating workflow that walks a table. I looked at the Technical Guide and some of it is confusing to me. Am I supposed to build separate active links for each one of these steps? Walk Table Field Call Guide Walk Table Field End Row Walk Table Field Exit Guide Walk Table Field Find Next Row Walk Table Field Modify Row Walk Table Field Set Current Row Walk Table Field Verify Row Scenario: I have two entries in Table "New" Purchase Number PO4453..... PO4523 When the user selects the two entries within the Table "New" - I want to push both of the numbers into Field A. I built an Active Link that triggers workflow when a button is pressed - the AL calls an AL Guide, that performs a table loop, on TABLE "New", and I have 'Table Loop Selected Rows Only' field checked. Then this same active link sets Field A with the value of the row selected within the Table "New." The problem is that the Field A is being set with ONLY the value from the first entry selected in the table. It does no read the second item the user selected. I read about '!, and '$ characters. I will try this next, but I want to make sure this is technically possible. I read in the technical guide, that work flow can be triggered after the user selects a row within the table. The user can select multiple rows correct? The AL guide has a checkbox for it - not sure why it is not working. Can someone tell me, what step am I missing? Someone mentioned setting a label, and then a go to label action. I tried this and nothing happened. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________ An Excellent Credit Score is 750. See Yours in Just 2 Easy Steps! <http://pr.atwola.com/promoclk/100126575x1222585042x1201462767/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=JuneExcfooterNO62> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
