https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id Gravity Support Forums Topic: Best way to get entry id en-US Thu, 30 Apr 2026 04:00:51 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-67471 Sun, 22 Jul 2012 21:46:27 +0000 italianbird 67471@https://legacy.forums.gravityhelp.com/ <p>I've created an additional form field called 'Internal Pro Nbr'. I'd like that field to be populated by the entry number that is already assigned to each new form submission or record. These numbers start with 1 thru infinity and indicated on each new record. </p> <p>What we'd additionally like to do is throw in pre-leading characters such as CT00(entry id#). </p> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-67455 Sun, 22 Jul 2012 20:42:46 +0000 Chris Hajer 67455@https://legacy.forums.gravityhelp.com/ <p>@italianbird, can you explain your scenario in a little more detail so we can help you with detailed instructions? Thank you. </p> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-67443 Sun, 22 Jul 2012 18:06:10 +0000 italianbird 67443@https://legacy.forums.gravityhelp.com/ <p>I need to reference the entry id in a newly created form field when a new entry is created. Perhaps pre-lead the entry id with the letters "CT". How can I make this happen? I'm not a programmer, but I follow instructions quite well. </p> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-58559 Thu, 10 May 2012 11:53:12 +0000 Alex Cancado 58559@https://legacy.forums.gravityhelp.com/ <p>I see what you are trying to do, but I think this method is not 100% reliable. If two entries get submitted around the same time, you might end up using the wrong entry id. The chances of that happening are probably not very high, but it could happen. If you decide to do it this way, I would change the query to<br /> <pre><code>SHOW TABLE STATUS WHERE name=&#39;wp_rg_lead&#39;</code></pre> <p>If you don't want to take that chance, use the gform_after_submission hook instead, where you have access to the entry id, then manually change the value of your hidden field using a sql statement:<br /> <pre><code>$wpdb-&gt;query(&quot;UPDATE wp_rg_lead_detail SET value=&#39;TRACKING_NUMBER&#39; WHERE lead_id=ENTRY_ID AND field_number=HIDDEN_FIELD_ID&quot;)</code></pre> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-58523 Thu, 10 May 2012 10:11:03 +0000 xehqter 58523@https://legacy.forums.gravityhelp.com/ <p>I need to attach a reference number (entry ID) to a UPS label which is generated on gform_pre_submission_filter (before entry ID is generated) so that I can save the tracking number to a hidden field. </p> <p>The method in my initial post works, I just wanted to see if there was an official GF API call that did the same thing. </p> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-58520 Thu, 10 May 2012 10:06:05 +0000 Alex Cancado 58520@https://legacy.forums.gravityhelp.com/ <p>I don't know a good way to get the auto generated IDs before the record is created. The safe way to do this is to first create the record and then use $wpdb-&gt;insert_id to read the ID that was created.<br /> If you describe a little more what exactly you are trying to do, I may be able to help you with some alternatives. </p> https://legacy.forums.gravityhelp.com/topic/best-way-to-get-entry-id#post-58267 Wed, 09 May 2012 03:10:47 +0000 xehqter 58267@https://legacy.forums.gravityhelp.com/ <p>I'm using:<br /> <pre><code>global $wpdb; $result = $wpdb-&gt;get_results(&quot;SHOW TABLE STATUS LIKE &#39;wp_rg_lead&#39;;&quot;); $entryId = $result[0]-&gt;Auto_increment;</code></pre> <p>Is there a better way to get the entry ID before its generated? </p>