How to display a hidden column if filter data was found in it ?

Ragim

Good day!
I have a table in which some columns are hidden by default at the time of its creation. How can I display these columns when searching data was found in them?

colin

Hi @Ragim ,

I can't think of a tidy way of doing this. The only thought that comes to mind is to create a search listener, then scan the data in the hidden columns to see if there's a match, and if so, make that column visible. Not ideal, but it should work.

Cheers,

Colin

kthorngren

To take @colin's solution a bit further you could use filter() and count() in the search event for the hidden columns. If the count is greater then 0 then display the column.

Kevin

Ragim

Thank you for your answers, I will definitely try, and I will write if I succeed.