They aren't copied into the table. You setup the table to point to the form and setup a qualification.
E.g., the Work info table in ITSM points to the TMS:WorkInfo form with a qualification of 'TaskOrTaskGroupInstanceId' = $InstanceId$ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali Sent: Friday, January 25, 2013 8:17 AM To: arslist@ARSLIST.ORG Subject: Re: count record in form ** Thank you Anusha, Direct SQL seems to be good solution I will try that, Christie, it is a good idea to have a hidden table, but how wil records in form be copied in the table ? Regards Naoufal El Hilali On Fri, Jan 25, 2013 at 4:14 PM, Pargeter, Christie :CO IS <cparg...@lhs.org> wrote: ** Another option is to put a hidden table on the form and then refresh the table and do a COLCOUNT($Field$) to get the count too. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali Sent: Friday, January 25, 2013 8:06 AM To: arslist@ARSLIST.ORG Subject: Re: count record in form ** Hi Kiran, Thank you for your answer, I dont have database access (login and password), can use a run SQL in set field ? if yes, how ? Thank you a lot Naoufal El Hilali On Fri, Jan 25, 2013 at 4:02 PM, Hullule, Kiran <kiran_hull...@bmc.com> wrote: ** If you have database access, then it's quite straight forward. Select count (*) from Tx à x is a schemaid of a desire form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Naoufal El Hilali Sent: Friday, January 25, 2013 9:22 PM To: arslist@ARSLIST.ORG Subject: count record in form ** Hi All, I need your help in counting records in a form I have an EIE instance that pushes some records to a form, and I wanted to count the records received by EIE. I have created a display only integer field "count" created a filter that is executed in submit and sets the value of count to 0 and calls a filter guide upon its execution the filter guide calls a filter that increment the count field. This development did not work for me, and I see nothing executed in filter logs Thank you all in advance. Naoufal El Hilali _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
