https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries Gravity Support Forums Topic: Get Total Price Submitted Across All Entries en-US Sun, 12 Apr 2026 08:15:09 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22599 Tue, 05 Apr 2011 23:07:46 +0000 blueprintds 22599@https://legacy.forums.gravityhelp.com/ <p>Except for when commas are thrown in the mix, am I right? It would work for anything less than $1,000, though.</p> <p>I think my simple work-around is to use a normal textbox and your initial get_pledge_total() function. I'll just add a note for users to not use commas, and maybe later I'll add some validation to actually prevent them from doing so.</p> <p>Thanks for the awesome work, guys!</p> <p>Grace and Peace,<br /> Brian Richards </p> https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22569 Tue, 05 Apr 2011 15:54:12 +0000 Alex Cancado 22569@https://legacy.forums.gravityhelp.com/ <p>Actually, the values are stored formatted as currency, so the function above won't work either.<br /> The one below will work for US dollars.<br /> <a href="http://pastie.org/pastes/1760191/text" rel="nofollow">http://pastie.org/pastes/1760191/text</a> </p> https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22563 Tue, 05 Apr 2011 14:58:44 +0000 Alex Cancado 22563@https://legacy.forums.gravityhelp.com/ <p>Brian,<br /> The payment_amount column will only be populated when PayPal is activate for that form. Here is the function to sum your donation field<br /> <a href="http://pastie.org/1759958" rel="nofollow">http://pastie.org/1759958</a></p> <p>You will need to pass the field ID as well (in your case, it is 7)<br /> <pre><code>get_pledge_total(3,7);</code></pre> https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22555 Tue, 05 Apr 2011 14:01:23 +0000 blueprintds 22555@https://legacy.forums.gravityhelp.com/ <p>Thanks, David! This is a super slick function. I had to mod the table name because this is a network install, but it does indeed work.</p> <p>I do face one problem, though, as part of the current value is calculated with via a pledge form (<a href="http://cyclethecampus.org/rider-info/pledges/" rel="nofollow">http://cyclethecampus.org/rider-info/pledges/</a>) that has a user-specified donate input and no paypal routing. I poked around the database for my submitted entry and saw no value passed for the payment_amount. Is there a similar way to grab the sum of this donate field across all entries?</p> <p>Thanks,<br /> -Brian </p> https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22541 Tue, 05 Apr 2011 12:58:58 +0000 David Smith 22541@https://legacy.forums.gravityhelp.com/ <p>Hi Blueprint,</p> <p>Paste <a href="http://pastie.org/1759512" rel="nofollow">this function</a> in your theme's functions.php and then you can call the function anywhere you want to display the total like so:</p> <pre><code>[php] echo get_payments_total(25);</code></pre> https://legacy.forums.gravityhelp.com/topic/get-total-price-submitted-across-all-entries#post-22512 Tue, 05 Apr 2011 11:22:58 +0000 blueprintds 22512@https://legacy.forums.gravityhelp.com/ <p>I recently launched a site, <a href="http://cyclethecampus.org" rel="nofollow">http://cyclethecampus.org</a>, that accepts pledges and donations for a fundraiser event. In the header is a thermometer indicating the total amount of all pledges submitted. Is there a way to grab this total dynamically?</p> <p>Our pledge form is here, <a href="http://cyclethecampus.org/rider-info/pledges/" rel="nofollow">http://cyclethecampus.org/rider-info/pledges/</a>, the amount field is a donation field.</p> <p>[BONUS]<br /> If we switch the thermometer to show actual donations received, is there a way to get the total of all entries, conditionally based on payment status. </p>