https://legacy.forums.gravityhelp.com/tags/sql Gravity Support Forums Tag: SQL - Recent Topics en-US Sun, 19 Apr 2026 18:17:19 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/questions-about-the-client-area-and-integrating-sql#post-328494 Mon, 17 Jun 2013 08:09:21 +0000 Luciano 328494@https://legacy.forums.gravityhelp.com/ <p>Hello, I'm looking at the Gravity Forms and I am very interested in buying the developer version, I can not speak very well English, I hope you understand me.</p> <p>My goal is to create a form for pizzas, but I need so that when the client makes a request to access the client area to see the requests made.<br /> is it possible?</p> <p>Also like to know when the client makes the request it be sent to a program done in sql server feeding the system with the data filled by the customer on site. It is also possible?</p> <p>thank you </p> https://legacy.forums.gravityhelp.com/topic/error-on-drop-table-during-upgrade#post-195377 Wed, 03 Apr 2013 09:36:05 +0000 mabel888 195377@https://legacy.forums.gravityhelp.com/ <p>I've just upgraded to 1.6.12 and received the following error:<br /> 'WordPress database error: [DROP command denied to user 'intltrav_wrd1'@'localhost' for table 'Awp_rg_form']<br /> DROP TABLE IF EXISTS Awp_rg_form'</p> <p>Is this something to be concerned about? Thank you. </p> https://legacy.forums.gravityhelp.com/topic/ms-access-and-multiple-tables#post-164820 Fri, 08 Mar 2013 17:17:00 +0000 Mattingly Graphics 164820@https://legacy.forums.gravityhelp.com/ <p>I have a client who has forms for user submission. The end target is Access... sort of. They don't need access as a database, but rather for querying and producing reports. The exported CSV adds a few extra steps, and we haven't been able to develop a workflow which allows allows them to simply export new entries, and have them properly import into access, purge for duplicates, etc...</p> <p>So I'm in the process of simply allowing Access to connect to the MySQL database tables for the RG_Leads tables. I can get in just fine, and the tables pull down great. But there are 3 of them. Now I need to run a Union query to pull the necessary data from the three different tables and populate a new table with that data.</p> <p>Has anyone had experience doing this? Any guidance or suggestions?</p> <p>Thanks! </p> https://legacy.forums.gravityhelp.com/topic/rg_lead_detail-table-uniques#post-149310 Mon, 18 Feb 2013 11:17:06 +0000 octoberblue 149310@https://legacy.forums.gravityhelp.com/ <p>In the wp_rg_lead_detail table, taken together are the three columns "lead_id", "form_id", and "field_number" always unique? </p> https://legacy.forums.gravityhelp.com/topic/sql-code-to-exportretrieve-form-entries-from-the-previous-day#post-143261 Wed, 06 Feb 2013 08:08:27 +0000 ab24 143261@https://legacy.forums.gravityhelp.com/ <p>Hi :)</p> <p>I need to write a sql query to retrieve a list of form entries for the previous day.</p> <p>I can't seem to find the sql queries used for the admin page (through both the plugin code itself and by using 'savequeries' wp debug feature) which lists form entries, could you please advise how i could achieve this?</p> <p>The form in question (used for College courses applications) can be found here : <a href="http://www.iwcollege.ac.uk/apply/" rel="nofollow">http://www.iwcollege.ac.uk/apply/</a></p> <p>Any help, pointers or links much appreciated.</p> <p>Thanks in advance,</p> <p>Aaron </p> https://legacy.forums.gravityhelp.com/topic/query-form-entries-from-outside-of-wordpress#post-137750 Thu, 31 Jan 2013 17:39:12 +0000 Des Moines University 137750@https://legacy.forums.gravityhelp.com/ <p>I know I can do a basic query of the database but is there any sort of API, functions, hooks etc. that can be used to easily pull form entries from outside of the WordPress environment? </p> https://legacy.forums.gravityhelp.com/topic/updating-forms-in-multisite#post-98006 Sun, 02 Dec 2012 14:43:58 +0000 chris_s 98006@https://legacy.forums.gravityhelp.com/ <p>Currently I am running an install of multisite and occasionally adding a new group of sites at once. I'm using the export_file in my config file so it makes installing a breeze. But on occasion, we want to add fields to a form, that exist across all sites the same. So my question is, is there a way to update all the forms across multisite without having to create a new form and importing it? I am currently using for IDs in my theme files to access the forms. When these form ID's change, i.e., importing a new form, the theme files don't match. Now I know this isn't the best way to do it, but I can't think of another solution to be able to use the same forms across all sites in my multisite installation. </p> https://legacy.forums.gravityhelp.com/topic/how-to-limit-the-time-that-entries-are-retained#post-116974 Tue, 08 Jan 2013 18:19:17 +0000 Anonymous 116974@https://legacy.forums.gravityhelp.com/ <p>I would like to limit a form so that entries are retained for no longer than 90 days.</p> <p>That is, all entries over 90 days will be automatically erased.</p> <p>Is there a way to do this? I don't see one.</p> <p>This is not the same as limiting the number of entries that a form will accept before locking people out. </p> https://legacy.forums.gravityhelp.com/topic/populate-hidden-field-from-another-form-input#post-107461 Tue, 25 Dec 2012 04:57:03 +0000 clueno1 107461@https://legacy.forums.gravityhelp.com/ <p>Hello</p> <p>i am editing on multiple step form. In my first step, user select a Language from drop down. The choices are below.</p> <p>English, Spanish, French, Any</p> <p>In second step i need to connect to database and populate a hidden field with value comes from database. I want to use an another text value and language value comes from first step to use in my database query.</p> <p>My code is here.. <a href="http://pastie.org/5575350" rel="nofollow">http://pastie.org/5575350</a> where is the problem? </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>