How to display number counter in excel export?

ferri · May 8th, 2011, 8:08 PM

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!

***Ben*** · (This post was last modified: May 19th, 2011, 7:02 AM by Ben.)

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 Smile

- Ben

IndiMacA · Jul 21st, 2020, 9:59 PM

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.

FORUMS