How to Fix Export Issue for Icon Columns in Retool Table?

💬 App Building
1

Hi Retool Community,

I’m running into an issue with exporting data from a table that contains an Icon column, and I’d love your help!

Context:

  1. I have a column in my Retool table that shows an expandable arrow icon (/icon:bold/interface-arrows-expand-3) for display purposes.
  2. The value behind the icon is the organization_id, and I want this value to be included in the exported file instead of leaving it blank .
  3. However, when I export the table:
  • The column with the icon doesn't export, only the title.
  • The column to the right shifts to take the place of the organization_id, which messes up the export format.

What I Tried:

  1. Using a Transformer: I tried to replace the icon with the organization_id for export purposes, but it resulted in null or blank values.
  2. Adding a Hidden Column: I created a hidden column containing the organization_id, but the same export issue persisted—exported data still didn’t reflect the correct values.

Expected Behavior:

  1. In the table:
  • Display the expandable arrow icon for users.
  1. In the export:
  • Export the organization_id (the number behind the icon).
  • Prevent the next column from shifting in the exported file.

Current Column Setup:

The icon column uses this logic:

javascript

CopyEdit

{{ item !== null ? "/icon:bold/interface-arrows-expand-3" : "" }}

The value behind the icon is stored in the organization_id field.

Question:

How can I ensure:

  1. The table shows the icon for users while preserving the data integrity for export.
  2. The export contains the organization_id in the correct column (instead of leaving it blank).

Thanks so much for your help—I’d greatly appreciate any suggestions or workarounds!

image
image242×812 3.77 KB

image
image646×1438 57.9 KB

Here the Org Subscriptions should be the org ID but right now it's showing the Subs ID. So the right column took place of the blank column. image

2

HI there @PaulaG,

There are a couple of ways to achieve this. Before delving into any of these, quick question: do you want to export data as shown in the table (after filters being applied) or is that not relevant in your case?

Asking because if it is not relevant, then you can easily manipulate your table's data source, e.g. query1.data. Otherwise, you need to first get the table's displayed data and then manipulate it.

3

Hi @MiguelOrtiz ! thanks for your reply. I need to export data as shown in the table (with filters applied and specific columns).

4

The issue was that I had the "Org ID" displayed in another column, and the table couldn’t export the same variable ("Org ID") in two different columns at the same time. This caused the export to fail or result in incomplete data.

To resolve this, I removed the "Org ID" column from the table view. Now, the export works correctly, with the "Org ID" being downloaded from the column where it is already associated with the expandable arrow.

2 Likes