https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number Gravity Support Forums Topic: Limit entries showing wrong remaining number en-US Tue, 21 Apr 2026 23:26:21 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-191885 Sun, 31 Mar 2013 17:09:35 +0000 Chris Hajer 191885@https://legacy.forums.gravityhelp.com/ <p>You're welcome. I'm glad that's working for you. </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-186804 Wed, 27 Mar 2013 14:17:03 +0000 asmiles 186804@https://legacy.forums.gravityhelp.com/ <p>Thank you so much for your help (especially the last piece Chris to not count trash items). My forms are now complete after many hours of development and work great</p> <p>Regards</p> <p>Al </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-93262 Mon, 19 Nov 2012 23:17:23 +0000 Chris Hajer 93262@https://legacy.forums.gravityhelp.com/ <p>In the code of your first post, change line 6 to this to exclude trashed entries.</p> <pre><code>[php] // parameters for reference: // get_lead_count($form_id, $search, $star=null, $read=null, $start_date=null, $end_date=null, $status=null, $payment_status = null) $entry_count = RGFormsModel::get_lead_count($form[&#39;id&#39;], &#39;&#39;, null, null, null, null, &#39;active&#39;, null);</code></pre> <p>The addition of "active" as the 7th parameter there should exclude entries which are in the trash. </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-93182 Mon, 19 Nov 2012 20:19:03 +0000 asmiles 93182@https://legacy.forums.gravityhelp.com/ <p>"or modify the code to account for entries which might have a status of "trash". </p> <p>Don't suppose you could help a wordpress/php newb with that could you please? </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-89377 Fri, 09 Nov 2012 17:44:58 +0000 Chris Hajer 89377@https://legacy.forums.gravityhelp.com/ <p>When the entry is trashed, it remains in the rg_leads table with a status of "trash". In those previous code examples, if you have an entry in the trash, it would still be counted as a submitted entry. You could modify the code to account for trash status, and not count those, or just delete your test entries permanently from the trash.</p> <p>Once you click "delete permanently" (while viewing a trashed entry) it's deleted from the database permanently. If that is not happening for you, it's possible you had caching turned on at some point? Or you may have a theme or plugin conflict.</p> <p>To summarize: a trashed entry is still in the rg_leads table, with a status of trashed, so those code examples probably still counted it as a lead. Delete the entry from the trash, and the code will be fine, or modify the code to account for entries which might have a status of "trash". </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-89293 Fri, 09 Nov 2012 13:54:11 +0000 David Peralty 89293@https://legacy.forums.gravityhelp.com/ <p>I will send a note to the development team about this to make sure it is on the list or if for some reason it is working that way on purpose, to leave a reason why. All my best! </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-89291 Fri, 09 Nov 2012 13:52:30 +0000 asmiles 89291@https://legacy.forums.gravityhelp.com/ <p>will future releases avoid the data being left in the _rg_leads file when deleted? </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-89166 Fri, 09 Nov 2012 06:34:21 +0000 Chris Hajer 89166@https://legacy.forums.gravityhelp.com/ <p>I'm not sure I understand your last question. Can you please rephrase it. Thank you. </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-88972 Thu, 08 Nov 2012 20:18:33 +0000 asmiles 88972@https://legacy.forums.gravityhelp.com/ <p>YIPPERS! I learned something new today. I cleaned out the _rg_leads table and it worked! </p> <p>Is there a fix other than you've mentioned planned for this?</p> <p>Awesome thanks.......... </p> https://legacy.forums.gravityhelp.com/topic/limit-entries-showing-wrong-remaining-number#post-88596 Wed, 07 Nov 2012 23:07:05 +0000 Chris Hajer 88596@https://legacy.forums.gravityhelp.com/ <p>I would echo $form['limitEntriesCount'] and $entry_count to see what they contain.</p> <p>Also, are the entries still in the trash? I think that code snippet was written before the trash functionality existed and maybe those entries are still being counted.</p> <p>If you have database access, can you check to be sure there are no leads for this form in the _rg_leads table?</p> <p>David Smith has also written a couple of articles on other ways of accomplishing the same thing:<br /> <a href="http://gravitywiz.com/2012/09/19/shortcode-display-number-of-entries-left/" rel="nofollow">http://gravitywiz.com/2012/09/19/shortcode-display-number-of-entries-left/</a></p> <p>Maybe one of his approaches will work better for you. </p>