Dynamic labeling on a table component using "number" as a formatting option does not render the data as a number

[jordreding]

Hi All,

I am having trouble with formatting one of my table columns as a number using the formatting options in the dynamic columns setting of my table. For some reason, whenever I reference my format as seen here:

and then add the number settings as seen here:

it does not show comma thousands separators and it does not limit the data to 0 decimal places.

the odd part is, the dynamic formatting seems to work well with my percents, tags, and currency values. With numbers however, it does not change. If i change it to “auto” it does change and allow the numbers setting to work, but auto fails to recognize one of my columns incorrectly so I would like to do it this way.

Is this a Retool bug or has someone already solved this?

Let me hear y’alls thoughts!

[Jack_T]

Hi @jordreding,

That is odd, sounds like a bug. Let me test this out and see if I can reproduce it.

Bummer that 'auto' type doesn't work for you use case, but good to hear the dynamic formatting works well for the other values.

How do you have the dynamic column set up?

I created some basic data in a variable as the source for the table and it is assigning that ID row to be a number and says I won't have any dynamic columns given my data source

Let me know what steps I should follow to set up my seed data array to test out the dynamic column number instructions.