Can we set editable by dynamic-column-settings

as description in https://docs.retool.com/docs/working-with-tables#dynamic-column-settings
we can do some dynamic-column-settings, but there is not editable option in that.
have any solutions?
thanks.

Hey @AnsonHwang!

This is something we're looking into including and we'll let you know here if/when we do!

As for workarounds, there aren't any great ones that come to mind... You may be able to use something like a listview to dynamically generate input fields based on the columns you'd like to edit then have your update query reference those fields instead:

What do you think?

1 Like

Thanks for your reply. I think the editable option is important. Because I use module, there is different fields in different app.
I show a complex relationship data(neo4j/graphql) in table component. So I need an flexible dynamic config.
The listView can't fit my case, thanks any way.

I believe this functionality can be achieved with dynamic column settings using the restrictedEditingMapper property. Setting this to "true" should disable edit. If all columns are set to be editable on the table component this may have the desired effect.


https://docs.retool.com/docs/data-in-tables#dynamic-column-settings

Unfortunately, this does not enable cell modifications ^

Hey @ericcheong! You should actually be able to set it to false to enable editing.

You can even dynamically enable/disable this setting with something like:

stateful_cols_render_validate.value.map((c) => {
  return {
    name: c,
    restrictedEditingMapper: false
  }
})

This is currently what im doing, stateful_cols_render_validate comes from another input selection where users can choose to display what existing column to display

But its still not editable :frowning: any recommendation?

Oh darn. Let me play around with this some some more to see how we can get this to work

After doing some digging, I believe this property is supposed to make an editable column non-editable when set to true.

Ideally, it also makes a column editable when set to false.

However, the only thing this property seems to do is make a manually-set editable column (manually set with the Editable checkbox) no longer editable when set to {{true}} or "\{\{true\}\}". Setting it to true doesn't work.

I filed this as a bug internally! In the meantime, it seems your best bet is to set all columns to editable and use something like the logic I sent in the screenshot above.

1 Like

Thank you

Continuing the discussion from Can we set editable by dynamic-column-settings:

In new table column setting is not showing to set dynamic-column-setting to "false"
as description in Build tables | Retool Docs
can we do some dynamic-column-settings, but there is not editable option in that.
have any solutions?
thanks.

1 Like

Hey @Vikas thanks for continuing the conversation! Looks like it was auto-closed due to inactivity, and because it had a marked Solution/Workaround. Merged your newer post back to the original thread here.

Good news! I see that the engineering team plans to implement editable dynamic columns in the near future. Stay tuned, we'll circle back once this is live.

@Vikas to close the loop, this has been implemented! Check out @Tess 's update here :slightly_smiling_face: