How can I add thousand separators to dynamic columns in a Retool Table without breaking numeric sorting?

💬 App Building
1

  1. My goal: Figure out a way to add thousand separators to dynamic columns.

  2. Issue: I cannot find a way to add thousand separators to dynamically generated columns without breaking sorting behavior.

    When I format numbers using .toLocaleString() (to show commas), the values are converted to strings — which causes the table’s built-in sort to treat them lexicographically instead of numerically (e.g., "9,999" appears after "12,000").

  3. Steps I've taken to troubleshoot: Converted numeric values to strings with .toLocaleString("en-US") inside my transformer — this added commas correctly but broke numeric sorting.

    Verified that the issue is specific to dynamic columns; static columns can be formatted via column settings.

3

Hello @engineering-tajir ,

In your dynamic column settings, go to Column Properties and add a new property for Number. Within that, you'll find an option to Enable Thousands Separator simply toggle it on.

image
image1095×632 79.2 KB

5 Likes