Filtering out columns based on the client's choice

I recently sent this to This email address is being protected from spambots. You need JavaScript enabled to view it. and I got a reply from Mr. Tomaz Sustar.

I felt that I need to add this here also so other ppl can see it.

What I am looking for is this: when the client get all the columns in the output, I want him to be able to filter out the columns he wants to.

Mr. Tomaz suggested to add input check boxes where clients can choose what columns they want to filter out as a second output.

I have been struggling since yesterday with GridBuilder to do it but still no luck.

I need more input and hints to get this done.

Thanks again.

where is file name for searchform functions?

Hi,

I think I'm looking for the same thing here.

I have a table in my database with about 20 columns in it. I'd like the client to be able to choose which ones to see - is this possible?

Or do I need to make say 6 or so different tables, each with a different view?

If it is possible, could you be explicit in how to do it?
Thanks again,
Steve

sdwek wrote:
Dear Steve,

In my case, I wanted to show all columns to the users and then giving a feature where he/she can hide/show columns as desired.

In order to this, and as Tomaz instructed, the best thing to do is to add check boxes with the names of the columns. As the user selects/deselects a column name, the column will appear/disappear accordingly.