Gravity Support Forums Topic: Create a report from 2 forms

Gravity Support Forums Topic: Create a report from 2 forms https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms Gravity Support Forums Topic: Create a report from 2 forms en-US Mon, 20 Apr 2026 15:05:41 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php David Peralty on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375797 Thu, 11 Jul 2013 12:39:48 +0000 David Peralty 375797@https://legacy.forums.gravityhelp.com/ I'm sorry, but I can't help you create this customization. All of the information you need should be available to you in our Gravity Forms files, and the database tables created. You should be able to get a list of entries from rg_lead_detail. gediweb on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375794 Thu, 11 Jul 2013 12:36:46 +0000 gediweb 375794@https://legacy.forums.gravityhelp.com/ David, Could not make it work :( i am a little dangerous with SQL, but in no way an expert. How do i get a list of all the entries for each form? gediweb on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375579 Thu, 11 Jul 2013 09:57:22 +0000 gediweb 375579@https://legacy.forums.gravityhelp.com/ thanks, will see if this helps... David Peralty on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375573 Thu, 11 Jul 2013 09:51:52 +0000 David Peralty 375573@https://legacy.forums.gravityhelp.com/ Here is what we use in export.php - <pre><code>$sql = "SELECT d.field_number as field_id, ifnull(l.value, d.value) as value FROM {$wpdb->prefix}rg_lead_detail d LEFT OUTER JOIN {$wpdb->prefix}rg_lead_detail_long l ON d.id = l.lead_detail_id WHERE d.form_id={$form["id"]} AND cast(d.field_number as decimal) IN ({$field_ids}) LIMIT {$offset}, {$page_size}";</code></pre> gediweb on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375559 Thu, 11 Jul 2013 09:45:56 +0000 gediweb 375559@https://legacy.forums.gravityhelp.com/ David, can you give me the SQL that generates that export, then i can work with that. I need to do the export/comparison couple times a day, so i need to automate it a bit David Peralty on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-375520 Thu, 11 Jul 2013 09:04:30 +0000 David Peralty 375520@https://legacy.forums.gravityhelp.com/ Could you export the two forms as two CSV files and then manage/manipulate the data? We don't have a database schema available. The tables that store entry data are the _rg_lead tables. I hope that helps. gediweb on "Create a report from 2 forms" https://legacy.forums.gravityhelp.com/topic/create-a-report-from-2-forms#post-374498 Wed, 10 Jul 2013 23:07:58 +0000 gediweb 374498@https://legacy.forums.gravityhelp.com/ I have 2 forms, registration and credit cards. I have a lot of registrations and not so many payments. I ideally would like to have a report in Excel that will give me all users, indicating who paid anw who did not. I have access to db from desktop, but cannot figure out how to make a query. is there a description on how Gravity keeps the data?