https://legacy.forums.gravityhelp.com/topic/totaling-all-entries-from-a-specific-field-as-a-counter Gravity Support Forums Topic: Totaling all entries from a specific field as a counter en-US Mon, 20 Apr 2026 07:15:02 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/totaling-all-entries-from-a-specific-field-as-a-counter#post-41599 Fri, 18 Nov 2011 18:57:26 +0000 Carl Hancock 41599@https://legacy.forums.gravityhelp.com/ <p>Yes, i'm aware the example code used the total submissions of the form. It's just an example. You'll need to take that code and customize it to suit your needs. Or work with a WordPress consultant to create the customization for you if you aren't sure how to properly query the data. </p> https://legacy.forums.gravityhelp.com/topic/totaling-all-entries-from-a-specific-field-as-a-counter#post-41589 Fri, 18 Nov 2011 17:46:05 +0000 websitedesignercharlotte 41589@https://legacy.forums.gravityhelp.com/ <p>Thanks so much Carl for your timely reply and I will post only on this thread. Sorry about the duplicate. I read all forum posts including the one above referencing totaling poll submissions but never really found where to begin with actually totaling counts from one specific field. The code in the article above references the total submissions of the form but not the ability to sum as a better definition all entries from one field.<br /> Example:<br /> Entry one on dropdown field "Fish Caught" - 10<br /> Entry two on dropdown field "Fish Caught" - 20 </p> <p>Query should select all entries from form 1 field fish caught sum them and echo total (30) fish caught. See <a href="http://www.myfish.com/all-logged-fish/" rel="nofollow">http://www.myfish.com/all-logged-fish/</a> and view the sidebar for desired result. See <a href="http://www.myfish.com/enter-a-fishing-trip-log/" rel="nofollow">http://www.myfish.com/enter-a-fishing-trip-log/</a> for the form used. Thank you so much for your help. </p> https://legacy.forums.gravityhelp.com/topic/totaling-all-entries-from-a-specific-field-as-a-counter#post-41571 Fri, 18 Nov 2011 16:38:14 +0000 Carl Hancock 41571@https://legacy.forums.gravityhelp.com/ <p>This should be possible. The Gravity Forms entry data is stored in your WordPress database. So it can be queried and parsed just like any data. This wouldn't require Gravity Forms hooks/filters because you aren't actually changing Gravity Forms. You would be displaying data outside of Gravity Forms.</p> <p>Here is a post that discusses how to write custom code to get a count of the total number of entries for a form:</p> <p><a href="http://www.gravityhelp.com/forums/topic/display-entries-count-on-site" rel="nofollow">http://www.gravityhelp.com/forums/topic/display-entries-count-on-site</a></p> <p>You could start with that, then you would have to customize it so rather than getting an entry count you get a count of field selections. It's a bit more complex for sure.</p> <p>Give it a shot, and if you need further assistance after giving it a try... we can take a look and help you out with the code. </p> https://legacy.forums.gravityhelp.com/topic/totaling-all-entries-from-a-specific-field-as-a-counter#post-41547 Fri, 18 Nov 2011 15:36:40 +0000 websitedesignercharlotte 41547@https://legacy.forums.gravityhelp.com/ <p>I am working on a site called MyFish.com that is a fishing and biological data log. I have two dropdown fields on this form <a href="http://www.myfish.com/enter-a-fishing-trip-log/" rel="nofollow">http://www.myfish.com/enter-a-fishing-trip-log/</a> (user:demofisherman / pass:demo) that I want to total and display in a text widget as a counter in the sidebar. </p> <p>The fields are fish caught and fish released which are both numerical dropdowns.. Each form submission has a variable amount of fish caught and released.<br /> Example:<br /> fisherman 1: 15 fish caught | 10 released<br /> fisherman 2: 25 fish caught | 12 released<br /> I want to extract the meta for ALL entries for these specific fields on this one form and display a running total as users enter fish in the log. Is this possible using the current hooks, filters and a little php? I have a functioning "counter" working on the thank you page and in the sidebar by passing two variables in the url (fishcount and fishreleased) to the thank you page and running the following code in the post. The code updates a simple text document and uses similar code to echo it in the sidebar in a text widget.</p> <pre><code>Thank you for logging your &lt;?php $fishcount=$_GET[&quot;fishcount&quot;]; echo $fishcount; ?&gt; fish! Total fish logged on MYFish.com: &lt;?php $fishcount=$_GET[&quot;fishcount&quot;]; if (file_exists(&#39;count_file.txt&#39;)) { $fil = fopen(&#39;count_file.txt&#39;, r); $dat = fread($fil, filesize(&#39;count_file.txt&#39;)); echo $dat+$fishcount; fclose($fil); $fil = fopen(&#39;count_file.txt&#39;, w); fwrite($fil, $dat+$fishcount); } else { $fil = fopen(&#39;count_file.txt&#39;, w); fwrite($fil, 1); echo &#39;1&#39;; fclose($fil); } ?&gt; Total fish Released: &lt;?php $fishreleased=$_GET[&quot;fishreleased&quot;]; if (file_exists(&#39;count_released.txt&#39;)) { $fil = fopen(&#39;count_released.txt&#39;, r); $dat = fread($fil, filesize(&#39;count_file.txt&#39;)); echo $dat+$fishcount; fclose($fil); $fil = fopen(&#39;count_released.txt&#39;, w); fwrite($fil, $dat+$fishreleased); } else { $fil = fopen(&#39;count_released.txt&#39;, w); fwrite($fil, 1); echo &#39;1&#39;; fclose($fil); } ?&gt;</code></pre> <p>I know this method presents a lot of problems and querying the actual entries is the correct way. How do I do this? </p>