Topic: Move or hide columns natively in a tablegrid

Just sharing a little information. I wasn't aware of MVD's native ability to hide and move columns in a tablegrid so easily. The following link shows a short video showing how this is easily done by the end user.

To do this, in the tablegrid properties, options, set the properties to the following status:
- goCanHideColumn = true
- goDisableColumnMoving = false


https://www.youtube.com/watch?v=smervFM_XHc

Roberto Alencar

Re: Move or hide columns natively in a tablegrid

Is the current user setting for visibility and column position saved the next time the application is launched?

Визуальное программирование: блог и телеграм-канал.

Re: Move or hide columns natively in a tablegrid

k245 wrote:

Is the current user setting for visibility and column position saved the next time the application is launched?

Hi k245! I ran some tests with an application without any scripts, and unfortunately, the information about which columns were hidden or moved isn't saved.

Anyway, my goal was to enable better analysis of monthly values by comparing specific columns and moving and/or hiding one or more of them.

Roberto Alencar

Re: Move or hide columns natively in a tablegrid

Hide and Seek and Leapfrog
https://k245.ru/wp-content/uploads/2025/07/Igry-detej.jpg
Custom column settings: built-in capabilities supplemented by scripts.
https://k245.ru/en/mvdb-en/hide-and-see … pfrog.html

Визуальное программирование: блог и телеграм-канал.

Re: Move or hide columns natively in a tablegrid

k245 wrote:

Hide and Seek and Leapfrog
https://k245.ru/wp-content/uploads/2025/07/Igry-detej.jpg
Custom column settings: built-in capabilities supplemented by scripts.
https://k245.ru/en/mvdb-en/hide-and-see … pfrog.html


Very good, congratulations!

Roberto Alencar

Re: Move or hide columns natively in a tablegrid

Hi Roberto, Konstantin,
Attached are a couple of suggestions that might help.
1.  Hide Columns Persistent.
With this option, the selection of hidden columns is persistent between sessions. 
Click on the 'Columns' button and then click on the columns in the 'pop-up' grid that you want to hide / unhide (highlighted with an 'x') and then click on the 'Columns' button again.
2.  Re-sort Columns Persistent.
With this option, the order of the columns in the tablegrid is persistent between sessions.
Click on the 'Columns' button and then 'drag and drop' the columns in the 'pop-up' grid in whatever order you want.  When they are in the order that you want, click on the 'Columns' button again to re-sort the tablegrid.
Maybe this can give you some ideas.
Regards,
Derek.

Post's attachments

Attachment icon column persistence.zip 904.53 kb, 65 downloads since 2025-07-16 

Re: Move or hide columns natively in a tablegrid

derek wrote:

Hi Roberto, Konstantin,
Attached are a couple of suggestions that might help.
1.  Hide Columns Persistent.
With this option, the selection of hidden columns is persistent between sessions. 
Click on the 'Columns' button and then click on the columns in the 'pop-up' grid that you want to hide / unhide (highlighted with an 'x') and then click on the 'Columns' button again.
2.  Re-sort Columns Persistent.
With this option, the order of the columns in the tablegrid is persistent between sessions.
Click on the 'Columns' button and then 'drag and drop' the columns in the 'pop-up' grid in whatever order you want.  When they are in the order that you want, click on the 'Columns' button again to re-sort the tablegrid.
Maybe this can give you some ideas.
Regards,
Derek.

Hi Derek, I understand the dynamics of storing information about modified columns in a specific table and restoring this situation in the OnShow procedure. Thank you.

Roberto Alencar

Re: Move or hide columns natively in a tablegrid

Hi all

k245 wrote:

Hide and Seek and Leapfrog
https://k245.ru/wp-content/uploads/2025/07/Igry-detej.jpg
Custom column settings: built-in capabilities supplemented by scripts.
https://k245.ru/en/mvdb-en/hide-and-see … pfrog.html


Good, well thought out work.
But we can do without the "Grid_ColPos2Ind" function. Not critical for a small number of columns.


And an interesting take on the solution from Derek.