Have you tried to change the criteria of your table to show what you want and then just do a colcount?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Fernandes Sent: Monday, April 23, 2007 9:29 AM To: [email protected] Subject: Table Looping in a filter Hi listers, I am trying to loop though a table in a filter. First, is this even possible? (I haven't done anything like this before) I am trying to count the number of times something shows up in a table, however, it is not working. This is how I have set it up 1) I have a filter that fires on submit/modify of the form that the table is on: a) sets up some counters (outboundmessagecount = 0, loopcount = 1). b) Calls a filter guide with a Table Loop on the table I want to loop though. 2) The Filter Guide calls one filter (below) 3) Filter that loops through the table: Loops though the table if columnName = "Outbound" AND loopcount < 3 (*I want to see if the first 2 rows of the table are "Outbound" messages* *- this is the end goal of doing this - I want an integer value with this number*). a) If Action - outboundmessagecount = outboundmessagecount + 1 loopcount = loopcount + 1 b) Else Action - loopcount = loopcount + 1 All I get is loopcount = 2 and outboundmessagecount = 0 , so the If Action never fires. Is this because the table has to be refreshed before it can "read" from the table? How do you do this from a filter? Help. Thanks, Derek -- Derek Fernandes Programmer Analyst U of C Information Technologies ES 1010, University of Calgary Calgary, Alberta T2N 1N4 403.210.9879 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
