Gravity Support Forums Topic: Display Data

Gravity Support Forums Topic: Display Data https://legacy.forums.gravityhelp.com/topic/display-data Gravity Support Forums Topic: Display Data en-US Mon, 20 Apr 2026 13:32:37 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php flameboyuk on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-6219 Wed, 09 Jun 2010 22:45:43 +0000 flameboyuk 6219@https://legacy.forums.gravityhelp.com/ Anyone? Does anyone have a snippet to output display the value for a specific Lead ID and Field No. in the database (without using custom fields)? flameboyuk on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-6025 Thu, 03 Jun 2010 06:42:31 +0000 flameboyuk 6025@https://legacy.forums.gravityhelp.com/ Is there any way using a similar method to output a number of specific submitted fields (as I don't want to use custom fields)? Alex Cancado on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-2493 Wed, 06 Jan 2010 18:20:27 +0000 Alex Cancado 2493@https://legacy.forums.gravityhelp.com/ Here we go, try the following code. You will need to replace $lead_id and $form_id with the right values. <pre><code>$form_id = 18; $entry_id = 190; $form_meta = RGFormsModel::get_form_meta($form_id); $entry = RGFormsModel::get_lead($entry_id); echo "<hr/>Form Title: " . $form_meta["title"] . " "; //displaying all submitted fields foreach($form_meta["fields"] as $field){ if(is_array($field["inputs"])){ //handling multi-input fields such as name and address foreach($field["inputs"] as $input){ $value = $entry[strval($input["id"])]; $label = RGFormsModel::get_label($field, $input["id"]); echo $label . ": " . $value . " "; } } else{ //handling single-input fields such as text and paragraph (textarea) $value = $entry[$field["id"]]; echo $field["label"] . ": " . $value . " "; } } echo "<hr/>";</code></pre> Alex Cancado on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-2463 Mon, 04 Jan 2010 13:32:55 +0000 Alex Cancado 2463@https://legacy.forums.gravityhelp.com/ bloomkey, I will come up with a code snippet and post it here when I have it. It might take me a couple of days, but I will get it done. Carl Hancock on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-2459 Mon, 04 Jan 2010 11:43:38 +0000 Carl Hancock 2459@https://legacy.forums.gravityhelp.com/ The support team member that can best answer this question is currently traveling. Once he is available he will respond back with information on how you can accomplish this. bloomkey on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-2452 Sun, 03 Jan 2010 23:42:35 +0000 bloomkey 2452@https://legacy.forums.gravityhelp.com/ I'm using this code with exec-php plugin to get an idea for how it might output but nothing appears on the page: <?php $leadid=2; global $wpdb; $results = $wpdb->get_results($wpdb->prepare(" SELECT l.*, field_number, value FROM wp_rg_lead l INNER JOIN wp_rg_lead_detail ld ON l.id = ld.lead_id WHERE l.id=%d ORDER BY l.id, field_number", $leadid)); foreach($results as $result){ echo "<hr />Entry Id: " . $result->id . " "; echo "Field Number: " . $result->field_number . " "; echo "Field Value: " . $result->value . " "; ?> bloomkey on "Display Data" https://legacy.forums.gravityhelp.com/topic/display-data#post-2448 Sun, 03 Jan 2010 17:47:57 +0000 bloomkey 2448@https://legacy.forums.gravityhelp.com/ I'm having trouble figuring out the best way to output display the data captured in the rg_lead_detail table. Do you have any tips or instructions for showing the data on a separate webpage? Combining the rg_form_meta with the data table is what I'm trying to accomplish so that I can display the labels and data side by side. Thanks