Forms response table Attachments with Table transform

[nothing much]

Hi,

There is a form containing a macro form - attachments. What is does is let the individual filling the form attach some document.

Now the response table for the form, contains this field data in a column named attachements with a download option in each row.

When i put the response table of the form in a table transform macro to clean the rows in the response table based on certain conditions. The Column containing the attachments shows "download" option, but that is not working.

What might be causing this issue and how can it be resolved?

[Stiltsoft support]

Hi @nothing much ,

The Table Transformer macro is ours and it belongs to the Table Filter, Charts & Spreadsheets for Confluence app.

The issue seems to be an expected behavior: the Table Transformer macro treats the source table as an SQL database (a table with headers and cells containing strings and numbers). So, when you manipulate with the attachments column, its contents is returned as a simple string.

You may try to use the Table Filter macro instead and try to filter out the unwanted rows. The Table Filter macro preserves initial cells formatting (for example, links), so, the download function may be working fine.

[nothing much]

I require to modify the table in various ways: add new columns based on conditions on other columns, sort and order these rows to remove duplicates, rename various columns, etc.

How i achieve the above functionality and keep the attachments download function working without using Table Transformer Macro. 

The Table Filter Macro doesnt have these capabilities.

[Stiltsoft support]

And what app are you using to create your source table? Confiforms (judging by the forms' names) or smth else? 

Maybe there is a kinda of a workaround to create a source table in a way that there will be no any needs to modify it later.

[nothing much]

I am using forms in confluence. Its slightly different from confiforms. Due to certain restrictions i cant use confiforms.

[Stiltsoft support]

Is it also a 3rd party app or smth?

Seems that nothing can be done from our side here.