Hide/show complete columns in table view (not column values, not action but filter)

Dear AppSheet team,

would be great to have the option of hiding/showing chosen column through a filter button (not through conditional hide of a specific column value, not throgh an action (like the link to filtered view)).
The solution through “go to filtered view” costs much time and does not allow to go back without coming bck to the previous view.
The solution of “show if” of a single value of the column filteres only the specific value, but does not hide the whole column. So in the table view the column itself is shown, but without values.

Filter out specific columns (like rows) would be great! Especially to be able to create specific filtered views of a table.

Thank you much!

Thank you MultiTech.

But isn’t it, as I mentioned just for hiding out the values within a column. The column itself (and the space it takes) within the table view is still there, in your solution, but its just empty.
(In your description its about “hiding out the values of a column”. Thats not what I mean. I would like to have a dynamic view that hides the whole column, not just the values. Because sometimes I do not need a column with all empty values. It just takes a lot of space…)
Or not?

2 Likes

By the statement above, I assume you mean if none of the rows in the view have a value then the complete column is hidden. But as soon as one of those rows gets a value, then the column “magically” appears - even though only the one row has a value?

Just to be sure it’s clear, the Show_If column constraint operates at the column level. So if it were set to FALSE, the column will not appear in the Table view - even if it were explicitly listed as a column in the view.

By the way, you can insert expressions into the Show_If to control the showing/hiding of the column. For example, you could insert an expression that checks if all values in a column are empty and if so hide the column!

1 Like

Hey Willow,
thank you for your reply. Actually not quite so.
I would like to hide columns f.e. through a “user preferenced filter button” (the kind of filter that you have if you filter out values, but in this case I would like to filter out some columns “view 1”, “view 2” etc.).

F.e. if I have a table with a lot of columns and I want to give the user the choice which table he wants to see. There may be a bunch of this tables (that have just specific columns).

Currently it is f.e. possible to solve it through a “linktofiltered view” or “linktoview”, where I link to a view, where some columns are filtered out.
But then there are lot of paths created, just to get to another view of the same base. And then if you “go back” with the left arrow, you get to the previous view, but not the the main one. As well the solutions gets slow.

I have also tried to solve it through with link to some user settings cell where the columns are defined, but then the user needs to update the whole table to make the new setting appear. So it is very very slow…

I guess also my problem could be solved, if there would be the “appsettings” function, so that some changes that don’t need to be uploaded could happen on the phone, so that adjustments of views, filters and choices would not have the need the app to be uploaded…

As mentioned here, there are a lot of data sending to the servers and back, that are not necessairy. Such changings could stay on the device and would directly take influence on the app, not just after the resync of the data…

1 Like

It is not possible to dynamically or programatically show or hide columns in a table view.

1 Like

Ah yes! I remember now. Even if I implemented an expression to hide it, the column will still show but the values would be hidden resulting in a completely blank column.

2 Likes

Right. Show_If shows or hides the column’s value in a row, not the column itself.

yes. that was what I was talking about :slight_smile: