i coming here after quiet a while . Was working on a Servoy project last 6 months.
I want to have dynamic columns to be shown on a layout .
For example :- if the user selects 10 columns from a checkbox selection set , that columns only should appear in another layout with data in list view .
*There is a solution for it . By taking column names as record's another column value and keeping data in their respective records.
But , by this way , the DB will become heavy .Say , 1000 original records are there with 10 columns names selected . Then , we have to create 10*1000=10000 records in the DB.
Is there any other effective way to accomplish this ?
Thanks in advance.