I want to know that how can I show/hide column Dataview like drill down rows like this picture below.
Anyone have an idea?
Hello Ilham If you're a developer and want to permanently hide/show blocks, you can do it directly in the Dataview layout using the "Hide Block" option.
Else, if you're just a user and want to do it temporarily, you can go to the Dataview options menu and manually hide/show the columns you want.
Akrem
So it can't be possible to configure it dynamically from Dataview settings?
I'm not sure I fully understood what you meant by "dynamically". If you mean displaying or hiding columns temporarily (not saved) on the screen, then it's option 2 — using the Dataview options menu ( data and the check box for columns) to manually show/hide columns that you want.
But if you want it to be fixed and saved, then it's option 1 in design mode using the "Hide Block" option directly in the Dataview layout.
Hi @Ilham Maulana Habibie ,
you could try to use the FlexGrid, instead - that would give the user more flexibility in column grouping, look here
https://help.board.com/docs/additional-flex-grid-object-interaction-features
Best, Helmut
Hi Ilham, there's no direct way to programmatically show or hide individual blocks, what you can do is disable "Show All" for columns and then make that block an algorithm so that you populate it or not conditional on whichever criteria you choose, disabling "Show All" means only the blocks containing one or more rows of data will be displayed, so if your algorithm renders that block blank on all rows the block won't be displayed.
Hi @Helmut Heimann
I have tried using Flex Grid, but there is limitation of column groups when I dragged them. I saw that only 7 columns that can be dragged, but I need more 7 columns that should be dragged.
ok, then I'd opt for the column chooser, like @Akrem ABDELHAFIDH suggested.
Any other option would require more effort and be less ergonomic (you could, for example, let the user change the width of the desired column to be invisible, but that can't be reset easily, and a reset would always reset the widths of all columns) and seems not feasible for the case.
And I'd encourage you to open a new idea in our idea section.
