Hey group. This my first question to the group and involves populating a custom form with the total count of open tickets per status.
I'm using an escalation with a push field action to set a tmp integer field with a value of 1 on a custom form. The Escalation has a create record condition; when a record doesn't exist with a matching assigned individual and the record's create date isn't within the last hour. (The most frequent that the Escalation would run.) A filter completes the desired outcome and is set to run on submit/modify on the custom form. It's has a set fields action which adds the ticket count integer field and tmp integer field (+1) together and then nulls out the tmp field. (Which may be redundant.) The resulting records are not as I expect. The escalation seems to both create one new record for each match and update the ones it just created in the same execution. If it did one other the other consistently I would be able to keep track of what is happening but as it stands I'm finding this a bit unpredictable. Can anyone explain this behavior? Also I would be open to other approaches to the generate the same report but the goal is to generate this without any user interaction and email it. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"