Hi, I'm new to Retool.
Tried to find answer in another topics but no luck.
I created a table with dynamic columns and want to parse through JSON to make "time" visible ("time" only) in each cell. As far as I'm concerned, that should be done with "format" settings. Need hint for that.
My current settings and data source example are attached.
I know that I can get rid of all the keys besides "time" with 'tranformer1' and it'll solve the problem. But I need those "id" and "doctor_id" for easy updating records in the DB.
Also tried to format cells with {{ JSON.parse(table2.selectedCell.value.time) }}, but didn't work either.
Unfortunately, we don't support setting the mapped value of the dynamic columns yet. The format field is only used for setting the column type (string, number, etc), not how the value is displayed. We have a feature request for this in our backlog.
In the meantime, I might either try a different UI (some combination of listviews/grids), or you could have a Javascript transformer that unnests the data so that the time is in it's own column, and you could conditionally hide the other columns. The hidden columns would still be accessible in the tables .data, and .selectedSourceRow properties
