Gravity Support Forums Topic: Creating a directory w/Gravity Form and categories

Gravity Support Forums Topic: Creating a directory w/Gravity Form and categories https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories Gravity Support Forums Topic: Creating a directory w/Gravity Form and categories en-US Sun, 19 Apr 2026 22:09:14 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php Alex Cancado on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-28488 Fri, 24 Jun 2011 12:10:52 +0000 Alex Cancado 28488@https://legacy.forums.gravityhelp.com/ Try the following. I am assuming your are using the default name field with First and Last names. <pre><code>//NOTE: replace 175 with your Form ID $entries = RGFormsModel::get_leads(175); echo "<table> <tr> <td>Name</td> <td>Post</td> </tr>"; foreach($entries as $entry){ $post = get_post($entry["post_id"]); if(!$post || $post->post_status == "trash") continue; $permalink = get_permalink($entry["post_id"]); //NOTE: replace 1 and 2 with your Field IDs echo "<tr> <td>{$entry["1.3"]} {$entry["1.6"]}</td> <td><a href='{$permalink}'>{$entry["2"]}</a></td> </tr>"; } echo "</table>";</code></pre> Anonymous on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-28486 Fri, 24 Jun 2011 11:53:36 +0000 Anonymous 28486@https://legacy.forums.gravityhelp.com/ THANKS! It totally worked. I have a few other things I would like to try now. Only post active posts (do not show anything that has been deleted) Make 1 of the fields (post title) a link to the post How to combine First & Last name from form to show as 1 field. Any suggestions? Alex Cancado on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-28484 Fri, 24 Jun 2011 11:40:40 +0000 Alex Cancado 28484@https://legacy.forums.gravityhelp.com/ Jen, Try the following. You will need add it to the template file you would like to display this information. Make sure to replace the Form ID and Field IDs to match yours. <pre><code><?php //NOTE: replace 167 with your Form ID $entries = RGFormsModel::get_leads(167); echo "<table> <tr> <td>Field 1</td> <td>Field 2</td> </tr>"; foreach($entries as $entry){ //NOTE: replace 1 and 2 with your Field IDs echo "<tr> <td>{$entry["1"]}</td> <td>{$entry["2"]}</td> </tr>"; } echo "</table>"; ?></code></pre> Anonymous on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-28422 Thu, 23 Jun 2011 15:05:40 +0000 Anonymous 28422@https://legacy.forums.gravityhelp.com/ Hi, I am pretty new to this, so I apologize in advance if I am making no sense. What i am trying to do is display 3 fields from our form on a page. I know the fom ID and the Field number(s). I just have no clue how to pull the data for those fields and display them. Thanks, Jen :) brianfidler on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23984 Fri, 22 Apr 2011 17:21:17 +0000 brianfidler 23984@https://legacy.forums.gravityhelp.com/ That's much better! Thanks David. David Smith on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23881 Thu, 21 Apr 2011 15:20:12 +0000 David Smith 23881@https://legacy.forums.gravityhelp.com/ Try using this function to output the form meta: <a href="http://pastie.org/1820138" rel="nofollow">http://pastie.org/1820138</a> You'll find that it is significantly more readable and gives you a better idea of hierarchy in the array. Use like so: <pre><code>[php] $form = RGFormsModel::get_form_meta($form); print_rr($form);</code></pre> brianfidler on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23874 Thu, 21 Apr 2011 14:51:46 +0000 brianfidler 23874@https://legacy.forums.gravityhelp.com/ Thanks David, When using the RGFormsModel::get_form_meta($form) is there a simple way to locate (or maybe display) the specific portion of the array I am interested in? For instance, I pasted the results of RGFormsModel::get_form_meta($form) into a text editor and slowly waded my way through it until I was able to identify the array data I was interested in ($form[fields][16][inputs][1][label]). But I'm guessing there is a simpler way? right? thanks brian David Smith on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23408 Fri, 15 Apr 2011 15:01:30 +0000 David Smith 23408@https://legacy.forums.gravityhelp.com/ Hi Brian, To answer your first question, when querying field numbers which are floats it is probably easiest to cast the field number as a decimal. MySQL will return inconsistent results when searching for a float data type (<a href="http://dev.mysql.com/doc/refman/4.1/en/problems-with-float.html" rel="nofollow">more info on this here</a>). Alternately, you can search by a range as you've posted above. Quick example of a query casting the field number as a decimal: <pre><code>[php] $removed = $wpdb->query("DELETE FROM $table WHERE lead_id = $entry_id AND form_id = $form_id AND CAST(field_number as DECIMAL(4,2)) = $field_id");</code></pre> For an easier way to retrieve the form meta, you can use this function: <pre><code>[php] $form = RGFormsModel::get_form_meta($form_id);</code></pre> Let me know if this does the trick for you if your requirements are more specific. brianfidler on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23123 Wed, 13 Apr 2011 02:17:08 +0000 brianfidler 23123@https://legacy.forums.gravityhelp.com/ In order to build my parent categories list I need to access wp_rg_form_meta.display_meta field. I tried unserializing the data in this field however it gives me this error: Warning: unserialize() expects parameter 1 to be string How can I get the parent categories (in my case it is putting all of my parent category choices into wp_rg_lead_detail.field_number=5) out of that field if I'm unable to unserialize it? brianfidler on "Creating a directory w/Gravity Form and categories" https://legacy.forums.gravityhelp.com/topic/creating-a-directory-wgravity-form-and-categories#post-23122 Wed, 13 Apr 2011 00:28:28 +0000 brianfidler 23122@https://legacy.forums.gravityhelp.com/ I've got two questions regarding the sql that David added to pastie.org. If I want to query an address (which in my form has a field_number=92.1 and a form_id=4, even though there area a number of records that have this field_number, the sql doesn't seem to work with any non-integer numbers. It will work if I use range, for instance > or < does work. So for example the sql below works and will return any records with a field_number between 92 and 93 (i.e. 92.5, 92.7, 92.8): <pre><code>SELECT * FROM wp_rg_lead_detail WHERE wp_rg_lead_detail.field_number>92 AND wp_rg_lead_detail.field_number < 93 AND wp_rg_lead_detail .form_id=4</code></pre> Why doesn't the query work if I try to get records where wp_rg_lead_detail.field_number=92.5?