https://legacy.forums.gravityhelp.com/topic/getting-form-object-outside-of-standard-hooks Gravity Support Forums Topic: Getting Form Object outside of standard hooks en-US Sun, 19 Apr 2026 20:24:56 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/getting-form-object-outside-of-standard-hooks#post-105677 Sat, 22 Dec 2012 00:47:25 +0000 Chris Hajer 105677@https://legacy.forums.gravityhelp.com/ <p>Since you are going direct to the database, you can use the form ID to query the wp_rg_form_meta table.</p> <pre><code>SELECT display_meta FROM wp_rg_form_meta WHERE form_id = $_GET[&quot;formid&quot;];</code></pre> <p>That will return a serialized array of all the form metadata. You can then use the php unserialize function to convert the data:</p> <pre><code>[php] $form_meta = unserialize($data); // debug? // print_r($form_meta); // retrieve the form title from the // serialized form_meta array $form_title = $form_meta[&#39;title&#39;];</code></pre> <p>Does that get you the information you need? </p> https://legacy.forums.gravityhelp.com/topic/getting-form-object-outside-of-standard-hooks#post-105044 Thu, 20 Dec 2012 15:20:17 +0000 zerotofive 105044@https://legacy.forums.gravityhelp.com/ <p>This is a somewhat uncommon request, but I have a client that wants to provide a custom HTML formatted email once a month to users. The users should only receive product notices based on their choices in their sign up form that they initially signed up with.</p> <p>I am using a Cron Job to process the PHP code. It will loop through all the users and return the relevant lead ID from the database (already working). My question now is - I know the form ID, I know the lead ID - but how do I get the form OBJECT so I can start to manipulate it and pull data from it?</p> <p>Below is the code I have in the for each user loop - please help!</p> <pre><code>global $wpdb; //Figuring out if user has submitted form before $sql = &quot;SELECT filtered.sort, l.*, d.field_number, d.value FROM wp_rg_lead l INNER JOIN wp_rg_lead_detail d ON d.lead_id = l.id INNER JOIN ( SELECT @rownum:=@rownum + 1 as sort, id FROM ( SELECT distinct l.id FROM wp_rg_lead l INNER JOIN wp_rg_lead_detail d ON d.lead_id = l.id WHERE l.form_id=&quot;. $_GET[&quot;formid&quot;] .&quot; AND created_by=&quot;. $iUserID .&quot; AND status=&#39;active&#39; ORDER BY date_created DESC LIMIT 1 ) page ) filtered ON filtered.id = l.id ORDER BY filtered.sort&quot;; //initializing rownum $wpdb-&gt;query(&quot;select @rownum:=0&quot;); //getting results $results = $wpdb-&gt;get_results($sql); $resultArray = array(); foreach( $results as $result ){ $leadID = $result-&gt;id; } echo $leadID;</code></pre> <p>The code above does return the correct leadID, but for some reason in the for each results it does loop multiple times when it should only loop once for one result. I am not concerned with that near as much as getting the form object so I can get the relevant checkbox data though.</p> <p>Thanks for any help. </p>