There is a way of jumping to a specified row in a table field - simply do a set fields action in an active link, choose the table field and set to an integer value. For example, setting a table field to 5 will select the 5th row.
The challenge in this case is to determine what number row is the one that meets the required values. One way to do this is to walk the table field with a guide- set the table field to a temporary integer field starting at 1, test the values in the first row, if not correct increment the integer field by one and loop the guide until the correct row is reached and exit the guide. Note that if there are a large number of records in the table field this sort of workflow can be very slow. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of gobsh1te Sent: 01 May 2006 11:17 To: [email protected] Subject: Re: Table Field - Going to a specific record in a table field Depending on how you'd like your application to work, you could: 1. User selects a value somewhere in your form. 2. This value sets a qualification for the table field in a hidden field. (The table field uses an EXTERNAL on this hidden field for its qualification.) 3. The table field is refreshed, displaying only that one relevant record. Of course this is only any good if you don't need the user to be able to see other table field entries other than the one with which they are currently concerned. But then again, once the user had done what they need to with the current record, you could have another piece of workflow which would reset the table field qualification to its original default value (which would show all records), and you're back to status quo. As far as I know, there isn't anything in ARS which lets you jump to a specific record in the table field. Perhaps reasonably so, the developers probably thought, "Why would you need to do that, since the table field can have a dynamic qualification [ie the EXTERNAL], so why display records which you're not interested in?". Just my opinion! Hope this helps, gs ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
