https://www.machform.com/forums/ MachForm Community Forums Topic: Single checkbox result not exported en Wed, 06 May 2026 04:33:41 +0000 https://www.machform.com/forums/topic/single-checkbox-result-not-exported#post-490 Mon, 31 Dec 2007 15:25:00 +0000 yuniar 490@https://www.machform.com/forums/ <p>No problem! :-) </p> https://www.machform.com/forums/topic/single-checkbox-result-not-exported#post-489 Mon, 31 Dec 2007 15:17:49 +0000 villah 489@https://www.machform.com/forums/ <p>Like a charm! Thanks!</p> <p>Hans </p> https://www.machform.com/forums/topic/single-checkbox-result-not-exported#post-487 Mon, 31 Dec 2007 11:46:44 +0000 yuniar 487@https://www.machform.com/forums/ <p>Oh, I think you just found a small bug for that one.</p> <p>Here is how to fix it, edit your <strong>export_entries.php</strong> file, look around line 193 - 227.<br /> You will find this block of code:</p> <pre><code>//first, reorder columns into the correct position $query = &quot;select element_id, element_total_child from ap_form_elements where form_id=&#39;$form_id&#39; and element_type != &#39;section&#39; order by element_position asc&quot;; $result = do_query($query); while($row = do_fetch_result($result)){ $element_id = $row[&#39;element_id&#39;]; $total_child = $row[&#39;element_total_child&#39;]; if($total_child &gt; 0){ $max = $total_child + 1; for($i=0;$i&lt;=$max;$i++){ if($i == 0){ if(in_array(&#39;element_&#39;.$element_id,$columns)){ $temp_columns[] = &#39;element_&#39;.$element_id; } }else{ if(in_array(&#39;element_&#39;.$element_id.&#39;_&#39;.$i,$columns)){ $temp_columns[] = &#39;element_&#39;.$element_id.&#39;_&#39;.$i; } } } }else{ $temp_columns[] = &#39;element_&#39;.$element_id; } }</code></pre> <p><code></code><br /> Replace that block with this one:</p> <pre><code>//first, reorder columns into the correct position $query = &quot;select element_id, element_total_child, element_type from ap_form_elements where form_id=&#39;$form_id&#39; and element_type != &#39;section&#39; order by element_position asc&quot;; $result = do_query($query); while($row = do_fetch_result($result)){ $element_id = $row[&#39;element_id&#39;]; $total_child = $row[&#39;element_total_child&#39;]; $element_type = $row[&#39;element_type&#39;]; if($total_child &gt; 0){ $max = $total_child + 1; for($i=0;$i&lt;=$max;$i++){ if($i == 0){ if(in_array(&#39;element_&#39;.$element_id,$columns)){ $temp_columns[] = &#39;element_&#39;.$element_id; } }else{ if(in_array(&#39;element_&#39;.$element_id.&#39;_&#39;.$i,$columns)){ $temp_columns[] = &#39;element_&#39;.$element_id.&#39;_&#39;.$i; } } } }else{ if($element_type != &#39;checkbox&#39;){ $temp_columns[] = &#39;element_&#39;.$element_id; }else{ $temp_columns[] = &#39;element_&#39;.$element_id.&#39;_1&#39;; } } }</code></pre> <p><code></code><br /> If you have any difficulty with the code, let me know. I'll send you the file directly.<br /> Thanks for reporting this, I'll update the package with the bugfix. </p> https://www.machform.com/forums/topic/single-checkbox-result-not-exported#post-483 Mon, 31 Dec 2007 00:49:52 +0000 villah 483@https://www.machform.com/forums/ <p>I am using the checkbox option to create a 'Subscribe me to your newsletter' option at the end of the form. This shows up fine in the backend, but when you export it to XLS/CSV it doesn't show..</p> <p>Hans </p>