https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database Gravity Support Forums Topic: Getting values from the database en-US Mon, 20 Apr 2026 00:59:02 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-74030 Wed, 05 Sep 2012 14:28:12 +0000 drosales 74030@https://legacy.forums.gravityhelp.com/ <p>I would love to see what your insight is... Are you on Skype? drosales43 is my Skype handle </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-74027 Wed, 05 Sep 2012 14:08:28 +0000 vixvii 74027@https://legacy.forums.gravityhelp.com/ <p>David - sorry I only saw your comment now and I know it is most probably WAY too late. But just an update. Reporting wasn't "resolved" but once you know how the data is stored it isn't too difficult to write your own reporting. I am a php "hacker" and I have no real clue what I am doing, but I got pretty far in terms of reporting and putting Gravity Forms to good use. </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-42362 Mon, 28 Nov 2011 19:14:17 +0000 drosales 42362@https://legacy.forums.gravityhelp.com/ <p>was this ever resolved? I am also in need of having a reporting program... I have a membership site where people log in referrals, they need to be able to check the following in some form of a data string:</p> <p>Each referral forms has 4 spots we want pulled back into a report on a user basis... </p> <p>the person given the referral and giver of the referral, name of referral, date, dollar amount</p> <p>that is it! </p> <p>I really could use this resolved this week! </p> <p>David </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27589 Sat, 11 Jun 2011 05:02:41 +0000 vixvii 27589@https://legacy.forums.gravityhelp.com/ <p>Carl, thanks for the reply - just to clarify, the students won't be registered as wordpress users. I just need to capture all their details and this should be linked to the Team Leader (Actual Wordpress user)</p> <p>Reading some of the other posts on the forum I think you did suggest to someone that you are hoping to implement "sub-forms" in version 1.5.3? But in the mean time creating a field for every entry and using conditional logic is the way to go. This isn't a problem - I just want to do the right thing ;-)</p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27530 Fri, 10 Jun 2011 10:21:55 +0000 Carl Hancock 27530@https://legacy.forums.gravityhelp.com/ <p>@vixvii This isn't a feature of the User Registration Add-On. The User Registration Add-On only registers/creates one user at a time. If you wanted to do this, you'd have to write your own customization to handle the user registration of the additional students. </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27502 Fri, 10 Jun 2011 03:52:18 +0000 vixvii 27502@https://legacy.forums.gravityhelp.com/ <p>Dimitri thanks for this and I will definately have a look, for now I first need to capture the data to display :-)</p> <p>Please let me know if I need to create a new topic for this, but it is still part of my overall problem. I created the user registration form and it works great, but I need to register up to 11 students too. Is it possible to have a form within a form? I need to register the students the same time I do the user registration for the multisite.</p> <p> I want to have a dropdown to select the nr of students to register and it must bring up the student registration form X nr of times. My only other option (what I can see) is to have 11 student registration fields for name, age etc. And display the fields with a conditional argument... </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27493 Fri, 10 Jun 2011 00:15:14 +0000 dmitriy.son@inthefirm.com 27493@https://legacy.forums.gravityhelp.com/ <p>vixvii, i quess it could be useful <a href="http://www.geertdedeckere.be/shop/graphup" rel="nofollow">http://www.geertdedeckere.be/shop/graphup</a> </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27173 Tue, 07 Jun 2011 08:05:13 +0000 Alex Cancado 27173@https://legacy.forums.gravityhelp.com/ <p>I am glad i was able to help.<br /> Good luck!! </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27156 Tue, 07 Jun 2011 00:24:56 +0000 vixvii 27156@https://legacy.forums.gravityhelp.com/ <p>Thanks again Alex! This is definitely helping and putting me on the right track. I think I have combined several problems in one and that is why it is so "fuzzy" - but your answer is definitely spot on to my main problem. Basically...</p> <p>1) I have a multisite set up where teams can register<br /> 2) The Team Leader is the Wordpress User, so he will register<br /> 3) Upon registration he must also fill in his team members' details<br /> 4) The Team Leader must be able to edit his team members' details<br /> 5) As "Superadmin" I need to be able to draw a list of all the teams, pull reports on demographics etc.</p> <p>By being able to access data straight in the database, I can write my own functions to pull the required data for the reports. Your answer on the database says to me it is not as complicated as some of the other posts made it out to be, and using hooks I can even do a lot of the calculations as soon as a form is submitted.</p> <p>I will start my journey and take it one small step at a time :-) </p> https://legacy.forums.gravityhelp.com/topic/getting-values-from-the-database#post-27147 Mon, 06 Jun 2011 18:22:27 +0000 Alex Cancado 27147@https://legacy.forums.gravityhelp.com/ <p>I am still a little bit fuzzy on exactly what you need as far as getting the data, but here is some info on how the data is stored. There is a main entry table (wp_rg_lead). Every entry created by Gravity Forms will create a record in the wp_rg_lead table. This table, doesn't however keep the actual field values. Those are stored in the wp_rg_lead_detail table. This table has a lead_id column which is a foreign key to the wp_rg_lead table and also a field_number column that maps to the ID of the field.<br /> So, if you have a form with the fields (age, race and sex), and assuming the field Ids are age=1, race=2 and sex=3, the data related to a submission of that form would look like the following:<br /> <pre><code>wp_rg_lead id date_created .....other columns 1 6/5/2011 wp_rg_lead_detail id lead_id field_number value 1 1 1 20 2 1 2 white 3 1 3 hispanic</code></pre> <p>So, to read all values for the age field, you would query the wp_rg_lead_detail table WHERE field_number = 1</p> <p>As far as hooks that you will need to use to pull off your custom functionality, it looks like a good one to start looking is the gform_post_submission hook (<a href="http://www.gravityhelp.com/documentation/page/Gform_post_submission)" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_post_submission)</a>. It allows you to do any processing needed after a form is successfully submitted.</p> <p>Good Luck! </p>