subject:"911\: Walking a Table"

911: Walking a Table

2009-06-02 Thread Oracle4Me

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.
**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&hmpgID=62&bcd=Jun
eExcfooterNO62)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: 911: Walking a Table

2009-06-02 Thread Frank Caruso

1. Create active link that calls guide. Choose the table to walk and then
check the box that says walk selected rows.
2. Within the guide you will have one active link. It will take the value
from the row and perform a set fields action to concatenate it to the field
on the form.


On Tue, Jun 2, 2009 at 10:36 PM,  wrote:

> ** 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.
>
> --
> *An Excellent Credit Score is 750. See Yours in Just 2 Easy 
> Steps!
> *
> _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: 911: Walking a Table

2009-06-02 Thread Grooms, Frederick W

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:arsl...@arslist.org] On Behalf Of oracle...@aol.com
Sent: Tuesday, June 02, 2009 2:37 PM
To: arslist@ARSLIST.ORG
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.

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: 911: Walking a Table

2009-06-02 Thread Oracle4Me

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,
frederick.w.gro...@xo.com 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:arsl...@arslist.org] On Behalf Of  oracle...@aol.com
Sent: Tuesday, June 02, 2009 2:37  PM
To:  arslist@ARSLIST.ORG
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: rmisoluti...@verizon.net 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&hmpgID=62&bcd=Jun
eExcfooterNO62)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: 911: Walking a Table

2009-06-02 Thread Grooms, Frederick W

Change it to 1 set fields action:

Name   Value

ztmpConsol5$ztmpConsol5$ + ";") + $Col1$

 

 

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of oracle...@aol.com
Sent: Tuesday, June 02, 2009 4:28 PM
To: arslist@ARSLIST.ORG
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, 
frederick.w.gro...@xo.com 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:arsl...@arslist.org] On Behalf Of oracle...@aol.com
Sent: Tuesday, June 02, 2009 2:37 PM
To: arslist@ARSLIST.ORG
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: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Re: 911: Walking a Table

2009-06-02 Thread Oracle4Me

Bingo! It worked.  The first table entry is in Field A twice, and the  2nd
table entry is only in Field A once.  But at least now there are two
entries pushing to Field A.

I know I am not all the way there yet -  I have to resolve this  redundancy
issue, but your help is much appreciated.


In a message dated 6/2/2009 4:43:26 P.M. Central Daylight Time,
frederick.w.gro...@xo.com writes:


Change  it to 1 set fields action:
Name  Value
ztmpConsol5   $ztmpConsol5$ + ";") + $Col1$

From: Action Request  System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of  oracle...@aol.com
Sent: Tuesday, June 02, 2009 4:28  PM
To:  arslist@ARSLIST.ORG
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,
frederick.w.gro...@xo.com  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:arsl...@arslist.org]  On Behalf Of  oracle...@aol.com
Sent: Tuesday, June 02, 2009 2:37  PM
To:  arslist@ARSLIST.ORG
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: rmisoluti...@verizon.net 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://ww
w.freecreditreport.com/pm/default.aspx?sc=668072&hmpgID=62&bcd=JuneExcfooter
NO62)
_Platinum Sponsor:  rmisoluti...@verizon.net 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&hmpgID=62&bcd=Jun
eExcfooterNO62)

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: 911: Walking a Table

2009-06-02 Thread jham36

Try setting that field to $NULL$ before calling the guide.  That way
any existing data in that field would be removed.  Then the values
from the selected rows should be the only pieces of data you see
there.

James

On Jun 2, 6:02 pm, oracle...@aol.com wrote:
> Bingo! It worked.  The first table entry is in Field A twice, and the  2nd
> table entry is only in Field A once.  But at least now there are two  
> entries pushing to Field A.
>
> I know I am not all the way there yet -  I have to resolve this  redundancy
> issue, but your help is much appreciated.  
>
> In a message dated 6/2/2009 4:43:26 P.M. Central Daylight Time,  
>
> frederick.w.gro...@xo.com writes:
>
> Change  it to 1 set fields action:
> Name                  Value
> ztmpConsol5           $ztmpConsol5$ + ";") + $Col1$
>
> From: Action Request  System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of  oracle...@aol.com
> Sent: Tuesday, June 02, 2009 4:28  PM
> To:  arsl...@arslist.org
> 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,
>
> frederick.w.gro...@xo.com  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:arsl...@arslist.org]  On Behalf Of  oracle...@aol.com
> Sent: Tuesday, June 02, 2009 2:37  PM
> To:  arsl...@arslist.org
> 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  Spo

911: Walking a Table

Re: 911: Walking a Table

Re: 911: Walking a Table

Re: 911: Walking a Table

Re: 911: Walking a Table

Re: 911: Walking a Table

Re: 911: Walking a Table

7 matches

Site Navigation

Mail list logo

Footer information