+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: How to display number counter in excel export? (/showthread.php?tid=1274)
How to display number counter in excel export? - ferri - May 8th, 2011
Hi,
Previously I asked on how to display a number field(auto increment/updated) in the table column.
http://forums.formtools.org/showthread.php?tid=1246
I figure this is too complicated and i'm using API forms.
Is it possible to display an auto-increment number(No.) when exporting to excel?
No. ColumnName
1 entry
2 entry
3 entry
...
Maybe somewhere at the export manager here:
{* display the column headings *}
I guess this will also work for html tables.
Thanks!
RE: How to display number counter in excel export? - Ben - May 19th, 2011
Hi Ferri,
Sorry for the wait!
Sure, no problem. You're quite right: the solution I posted *was* complicated - but it's nice in that it keeps everything sorted and consistent in the database. To do it simpler, with just having a numbered list on the outputted Excel output, just create a new Export Type (in the Export Manager module) for the Excel Export Group with the following code.
Code:
<h1>{$form_name}</h1>
<table cellpadding="2" cellspacing="0" width="100%" class="print_table">
{* display the column headings *}
<tr>
<th>Count</th>
{foreach from=$display_fields item=column name=row}
<th>{$column.field_title}</th>
{/foreach}
</tr>
{* loop through all submissions in this current result set, and display each item in a manner
appropriate to the field type *}
{foreach from=$submissions item=submission name=row}
<tr>
{foreach from=$display_fields item=field name=col_row}
{assign var=field_id value=$field.field_id}
{assign var=field_type value=$field.field_info.field_type}
{assign var=col_name value=$field.col_name}
{assign var=value value=$submission.$col_name}
<td>{$smarty.foreach.row.iteration}</td>
<td>
{if $field_type == "select" || $field_type == "radio-buttons"}
{smart_display_field_values field_id=$field_id selected=$value}
{elseif $field_type == "checkboxes" || $field_type == "multi-select"}
{smart_display_field_values field_id=$field_id selected=$value multiple=true}
{elseif $field_type == "system"}
{if $col_name == "submission_id"}
{$submission.submission_id}
{elseif $col_name == "submission_date"}
{$submission.submission_date|custom_format_date:$timezone_offset:$date_format}
{elseif $col_name == "last_modified_date"}
{$submission.last_modified_date|custom_format_date:$timezone_offset:$date_format}
{elseif $col_name == "ip_address"}
{$submission.ip_address}
{/if}
{elseif $field_type == "textarea"}
{$value|nl2br_excel}
{else}
{$value}
{/if}
</td>
{/foreach}
</tr>
{/foreach}
</table>And that's it! All the best
- Ben
RE: How to display number counter in excel export? - IndiMacA - Jul 21st, 2020
Every computer user needs a basic knowledge of using documents like excels. Therefore, https://www.essaygeeks.co.uk/proofreading/ they can use all the essential data in an organized way to help others.