Raj, The same can be done using the sql count as suggested earlier..
select count(*) from HPD_Worklog where comment = 'particular value' If that particular value is embedded in the text in the comment field, then you might want to use a like search select count(*) from HPD_Worklog where comment like '%particular value%' Run this in a Set field using an SQL and return the $1$ to that field whenever you want lets say window open, using a active link, and set the count to your integer field. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:59 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: need to design a counter Hi Joe, Thank you for the reply. Form 1: HPD:HelpDesk, Integer Field on HPD:HelpDesk form. Form2: HPD:Worklog So, whenever there is a submit to HPD:Worklog through webservice, comments are added to the HPD:Worklog, so only for a particular comment , which would be my RUN IF( 'Comment'="Particular Value") qualification for designing the filter on submit on HPD:Worklog, I need to increment the count through that integer field (which would be a hidden integer field), which is on HPD:HelpDesk form. Thanks, Raj On Apr 15, 5:14 pm, Joe D'Souza <jdso...@shyle.net> wrote: > Raj, > > What is the reason you need that counter? Just to have a total count of > tickets in form 1?? Or is there another reason? > > If you just want a count, I wouldn't create a form. I would have a hidden > field that did a select count(*) from whatever view name that table has in > the underlying database.. > > Cheers > > Joe > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org]on Behalf Of Raj > Sent: Thursday, April 15, 2010 8:04 PM > To: arsl...@arslist.org > Subject: need to design a counter > > Hello all, > There is an integer field on form1. > need to design a counter which increments the count by one for every > submit on form2. > So, need to write a filter on submit of form 2 which increments the > integer field on form 1 by 1 for every submit on form 2.please advise. > thanks, > Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"