Dynamic Columns feature in Data gird

I have a requirement to add the dynamic columns in the Data grid, Does Mendix provide this option to add the columns dynamically or can we use hide or show of the exiting data grid column based on events. if so please suggest how to implement this feature 
2 answers

AFAIK it’s not possible to create a truely dynamic table in Mendix, the columns are defined at design time and can be altered/ added at runtime.

Maybe have a look at the pivot table widget from the app store, this might come close to matching your specific requirements


I Published a widget that can probably help you out

Data Grid with variable columns. No more list view in list views!


  • Data Grid, with variable number of columns.
  • Render cell content: attribute, text or user custom to build your onw cell content, including editable inputs.
  • Empty row content message.
  • Empty cell objects can be omitted when "Optimize cell paging" is disabled.
  • On click action on row, column and or cells
  • Choose the default styling of the Data Widget Grid 2 widget, or render it as a plain HTML table without any styling.
  • Options for pagination for Row, Column or non.
  • Structure mode preview in the Studio Pro.