A lot of things can be done by a user who knows his way around. By adding controls certain things can be made available for the less experienced user, although it might not always be obvious how things work.
I have run into a couple of situations that I would like to be available by clicking a button. Certain things might be possible by making (hidden) extra columns, but others seem to be impossible to do.
What I would like to be available as buttons actions (placed on the canvas):
filtering rows in a table (and undoing the filter by hitting the button once more)
sorting a table
Another option that would be very nice is to have a button or switch (on the canvas or in a table column) that goes through a predefined number of settings every time you click on the button. I think this can be done now by using functions, but it is pretty complicated and hard to change. It would be nice if this could be done based on a lookup table (or a list). This might seem a futile difference from what is possible now, but if you want to do these things on a mobile phone (and if you want to do it quick), it is often quicker to hit the button a couple of times instead of getting a popup list. I am thinking about thinks like “yes, no”, “yes, no, blank”, “red, blue, green, yellow”, “done, blank” - even if there are choices when using a select list (the last sample “done, blank” might have many more items in the column, like “planned, in process, rejected”. But also scrolling through a user list by keeping on hitting the button is for small groups a nice feature. If the button label would show the current choice it would a nice finishing touch.
But, I came to write this message because I was trying to make a button on the canvas filter a table, and I couldn’t find a (simple) way to do it. Can it be done?