+ Start a Discussion
Shane QuiringShane Quiring 

How to Auto Count the number of times a case has been submitted?


Currently we are using cases for submitting a Pricing Request to our Pricing Team. They, the Pricing Team, would like to know how many times that the Pricing Request has been submitted.

My thought would be to use WF Rule to accomplish this, for example if the owner is a Queue then a WF Rule would Check Mark a box, which is where the initial submission of the Case goes to.

Here is my question/s: Would I need to use a check mark box for part of the formula to update the count or could I get away with not using the check mark box?  Of course the Check Mark Box would be updated by another WF Rule when the Case was submitted/assigned. Here is the formula that I was thinking of using:

if( Submitted_to_Pricing = True, Number_of_Submissions__c+1,0)

Or am I totaled off base and would need to use an APEX Trigger to do the counting?

Any help or advice would be greatly appreciated, thank-you.
Shashikant SharmaShashikant Sharma
Hi Shane,

As you have explained it appears to me you would require a Trigger.

You could get started on Trigger from this : http://forceschool.blogspot.in/2011/05/writing-apex-trigger-issues-and.html and post your questions if you face issue.