https://legacy.forums.gravityhelp.com/topic/daily-report-list-entries Gravity Support Forums Topic: Daily Report - List Entries en-US Sun, 19 Apr 2026 20:04:01 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/daily-report-list-entries#post-103762 Tue, 18 Dec 2012 00:06:45 +0000 Chris Hajer 103762@https://legacy.forums.gravityhelp.com/ <p>You could mimic the export routine that Gravity Forms uses, and script it by using wp_cron() or an actual shell cron job. There have been no further updates on automated exports of the entries. </p> https://legacy.forums.gravityhelp.com/topic/daily-report-list-entries#post-103712 Mon, 17 Dec 2012 21:55:11 +0000 Josh Fialkoff 103712@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> Is there an update on this?<br /> Are there any other ways to automatically create a daily (or periodic) summary of form submissions and have it sent to specific recipients?<br /> Thanks,<br /> Josh </p> https://legacy.forums.gravityhelp.com/topic/daily-report-list-entries#post-88106 Tue, 06 Nov 2012 20:21:09 +0000 mshussein 88106@https://legacy.forums.gravityhelp.com/ <p>Hello,</p> <p>I am trying to create a report that is run daily via cron which will list all entries for that day.</p> <p>I am creating from plain old PHP (ie: i'm not using wordpress/gravity forms functions whatsoever).</p> <p>All is well, I can get all the data, but how do I get the NAMES of the fields?</p> <p>How do I know what each 'field_number' means?</p> <p>Do I need to look at a meta table and unserialize some text into a PHP array?</p> <pre><code>$result = mysql_query(&quot; SELECT wp_rg_lead.id, wp_rg_lead.form_id, wp_rg_lead.post_id, wp_rg_lead.date_created, wp_rg_lead.ip, wp_rg_lead.source_url, wp_rg_lead.user_agent , wp_rg_lead_detail.field_number, wp_rg_lead_detail.value, wp_rg_lead_detail_long.value as long_value FROM wp_rg_lead LEFT JOIN wp_rg_lead_detail ON wp_rg_lead.id = wp_rg_lead_detail.lead_id LEFT JOIN wp_rg_lead_detail_long ON wp_rg_lead_detail.id = wp_rg_lead_detail_long.lead_detail_id ORDER BY date_created DESC; &quot;); echo &quot;&lt;table&gt;&quot;; // build leads into array $leads = array(); while ($row = mysql_fetch_assoc($result)) { // if the lead isnt in the array, then add it if (!isset($leads[$row[&#39;id&#39;]])) { $leads[$row[&#39;id&#39;]] = $row; } // store the data and field $leads[$row[&#39;id&#39;]][&#39;fields&#39;][$row[&#39;field_number&#39;]] = $row[&#39;value&#39;]; } $doneHeader = false; foreach ($leads as $id =&gt; $lead) { // if we haven&#39;t done the table header, then do it if (!$doneHeader) { echo &quot;&lt;tr&gt;&quot;; foreach ($lead as $name =&gt; $value) echo &quot;&lt;th&gt;{$name}&lt;/th&gt;&quot;; echo &quot;&lt;/tr&gt;&quot;; $doneHeader = true; } echo &quot;&lt;tr&gt;&quot;; foreach ($lead as $name =&gt; $value) { if ($name == &#39;fields&#39;) { echo &quot;&lt;td&gt;&quot;; foreach ($value as $fid =&gt; $fv) { echo &quot;{$fv}&lt;br&gt;&quot;; } echo &quot;&lt;/td&gt;&quot;; } else { echo &quot;&lt;td&gt;{$value}&lt;/td&gt;&quot;; } } echo &quot;&lt;/tr&gt;&quot;; } echo &quot;&lt;/table&gt;&quot;;</code></pre>