https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object Gravity Support Forums Topic: Getting a single entry as an object en-US Mon, 20 Apr 2026 01:04:35 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object#post-14346 Mon, 13 Dec 2010 18:53:20 +0000 michaelbyrd123 14346@https://legacy.forums.gravityhelp.com/ <p>Woohoo worked like a charm. Thanks for the quick response. So glad I bought dev license so far ;] </p> https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object#post-14344 Mon, 13 Dec 2010 18:46:57 +0000 Alex Cancado 14344@https://legacy.forums.gravityhelp.com/ <p>Yes, the field label is stored as a serialized string, so you won't be able to get them all at once. You will need to get them one by one, using the following PHP code:</p> <pre><code>//Replace 10 with your form ID $form_meta = RGFormsModel::get_form_meta(10); $field1 = RGFormsModel::get_field($form_meta, 1); $label = $field1[&quot;label&quot;]; $field2 = RGFormsModel::get_field($form_meta, 2); $label2 = $field2[&quot;label&quot;];</code></pre> https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object#post-14334 Mon, 13 Dec 2010 18:21:26 +0000 michaelbyrd123 14334@https://legacy.forums.gravityhelp.com/ <p>Okay, so this has been working good but now I need to take it a step further and am getting a bit stumped. I now want to convert all of the field_numbers into their appropriate title. For example in a simple form they might be 1, 2.1, 2.2, 2.3, 2.4, 3. </p> <p>How would I go about converting these to their respective titles? The info I need seems to be stored in an enormous string in wp_rg_form_meta. Is there a built in function I can use to get the headings given the string? </p> https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object#post-14180 Fri, 10 Dec 2010 12:15:28 +0000 Alex Cancado 14180@https://legacy.forums.gravityhelp.com/ <p>You got it! This is the way to do it. </p> https://legacy.forums.gravityhelp.com/topic/getting-a-single-entry-as-an-object#post-14135 Thu, 09 Dec 2010 13:57:00 +0000 michaelbyrd123 14135@https://legacy.forums.gravityhelp.com/ <p>So I'm trying to figure out a mysql statement that will get a complete gravity form entry, given the lead id, as an object. Can anyone help? The reason I want to pull directly from the gravity form database is that I want the administrator changes through the entries tabs to be reflected, instead of creating my own database table when forms are submitted. So far i've got-</p> <p> SELECT wp_rg_lead_detail.value, wp_rg_lead_detail_long.value AS long_value<br /> FROM <code>wp_rg_lead_detail</code><br /> LEFT JOIN <code>wp_rg_lead_detail_long</code> ON id=lead_detail_id<br /> WHERE lead_id=$id ORDER BY field_number;</p> <p>This works okay, and gets the complete lead, with it's field number sorted. I guess I sort of answered my own question ^^. I can then get the field value by using an if statement, getting the detail value if the long value is empty (actually youd probably want to include the field_number in your sql statement as well)</p> <p>Let me know if anyone has a better approach than this. </p>