Have a look at DataGrid 2, in DataWidgets Marketplace module. You need Mendix 9.6.x or higher and Atlas 3 though.
I would recommend Datagrid 2 if it is above 9.6 or if you want the datagrid then you could show all the fields required using scroll container – Just place datagrid inside the scroll container widget and give width accordingly.
You could also try another customized option by using dynamic classes for datagrid to show/hide but it requires adding more fields in entities to change true/false and then change the dynamic class using that boolean value
Please note Mendix 9.6 is an MTS release so it receives patches.
If migrating to Mendix 9.6 is no option, my DataTables widget might help you out. At least until you are ready to migrate to Mendix 9, at that point it is best to replace DataTabels with Datagrid 2.
It allows the user to choose columns and persist that to local storage in the browser.
You can also configure it to use a horizontal scrollbar.
Please note the Datatables widget is provided as-is. As Datagrid 2 is now officially supported, I don't upgrade the DataTables widget anymore to newer releases of the library used in the widget.
Thank you for your comments.
I heard about the new functions with data grid 2. The problem is that I am working in a company, where it is recommended to stick with the 8. version.