Dynamic Columns in New table needs Documentation. Missing Features?

I don't see any documentation for the "Use Dynamic Colum Settings" for the new Table.

image

It is unclear how to use this, even after reading a few posts on this forum. Could we get some explanation on how to use this? I am currently using dynamic columns on the now "Legacy" table. My use case is I have multiple "Views" that I allow the end user to select from, and when selected, it not only dynamically hides the columns but also reorders them depending on the purpose of the view.

Previously, I simply gave the dynamic columns an array of column names, and it respected the order and the names and configured the table correctly.

[
"thumbnail_url",
"name",
"brand_logo",
"fulfillment_status",
"started_processing",
"fulfillment_state",
"incomplete_project_items"
]

Configuration of the columns in the Legacy Table, including colors, types, mapped values was all done in the normal field selection, with the caveat that you had to temporarily turn off "Dynamic Columns" in order to edit them.

I cannot get the new table to do this simple case. Am I missing something?

Hey @Highway20Productions! Thank you for the feedback here on our lack of documentation on the new Dynamic Column Settings feature. It's honestly not quite intuitive on the new Table component. We're working on both an official docs update and a how-to Community Post. Both coming soon. :slight_smile:

1 Like

I have a similar issue, not having the dynamic option is a stopper to migrate to the new tables…

Definitely! I filed a few requests to make our dynamic column settings more usable and intuitive.

We also have some new official docs to try bridging the gap.

Please keep the feedback coming!

I'm liking the official docs, but there still missing information on using tags and avatars with dynamic columns and how to set the options. The example "Currency" format seems to have lots of options but Tags and Avatars only have Colour and image, no options data, captions, etc.

It would be so powerful to have this functionality.

Passed that feedback along, thank you!

I do see what you're seeing and assume that we might not support full dynamic column settings for certain column types, but I will update this thread if I find out otherwise.

On this note, 2 things. One, what is the variable called for "Number". Most of the other ones are just lowercase for that word, like "Currency" is "currency" and "BigInt" is "bigint" but "number" does not work.

AND, how do I dynamically change the background color on a dynamic column? For example, a column called "Profit" comes up, and I want it to be red when negative and green when positive.

Hi @szabon!

For your 1st question, are you curious about the Number column type? In what context are you referencing this column?

And for your 2nd question, would something like this be helpful? :slight_smile:

https://community.retool.com/t/color-code-a-column-in-a-table-based-on-its-value/23762

Do dynamic Columns even work in the new table? I still use Legacy table because of that.

1 Like

Hi Victoria! Does this work with dynamic columns?

Hi all! In addition to the docs that Victoria linked above, one of our team members put together a Tips & Tricks article on implementing dynamic columns in the modern table component. I recommend reading through it and am happy to answer any clarifying questions that you might have afterwards! :+1:

Sorry for the delay. When I put in the dynamic column settings that the format is "number" or "Number" it does not recognize it. For example, if I put "currency" it works fine, but if I put "Currency" it does not.

What I am looking for is a list of what the column types are in code, not the dropdown menu, because it does not actually correlate to the dropdown menu for "Number"

To @szabon and anybody else tracking this, we've just updated our docs with a list of all valid column formats! The correct value for "Number", for example, is decimal.