I’m trying to use a button to update all rows in a column. I want the button to stamp the current date and then show the user clicking the button. I’m guessing this is a problem with displaying the date and user in the same field. The formula does not show an error:
Today() +"- "+ User().Name
but returns this: 44118 Tom Huber
Instead of: 10/14/20 - Tom Huber
I know this is probably possible as well, I just can’t figure out the formula. But is it possible to make a button act as a filter? For example if I have a selected list colum with values of “New”, “Existing” and " Add-On", can I create a button that will filter the table to just show the “New” results. I’ve tried to pull the formula created from the interactive filter, but I can’t seem to figure out how to set it to filter on one specific result:
Thank you. I was hoping to use a button to avoid using the interactive filter. When I click on the button on the example below, I would only want to see the rows that have the test column populated with 1. So it should refresh the table to only show 3 results…aa,bb,ff
can I ask you what is the advantage of using a button to filter data?
What you ask can actually be done (through a utility table).
However, I really struggle to understand the added value, considering that you need to have one button per filter; therefore - in your case - three buttons.
From a “normal” UI (and UX too) perspective a drop-down would be the most expected way to achieve that.
Also considering that it is extensible by design (i.e. adding more values, wouldn’t change your implementation).
I really appreciate your insight and your actual need to better get into the point.
Well, It took me some time to get to a workable solution but I must say that filtering a table with a button is quite less efficient than using interactive filters .
But, here it is
I found inspiration in this post to get there.
So, I had to add a checkbox field in your example table and a single select control on the canvas to choose the number you want to filter your table by.
After that just click on the button “Filter”.
Technically, the button doesn’t filter the table, it just checks the appropriate checkboxes. Then the table filters those checkboxes afterwards by using the values in the formula I put on the canvas under “Filtered results” with this formula :
Hello, thank you both for your input and providing a few suggestions. I do understand that this is basically achieved with the interactive filter. I was just looking to make the filtering process a little cleaner for specific users. The example I provided was small. But if we expand to say a data set of 20 different filter (returns). Having to click the select all, to clear and unclear the filter is just a bit clunky in my opinion. If I have a user that needs to see all the results, but then typically only filters on 5 different returns. They have to:
click select all to clear,
then select the 5 different filters they want
and then click to the side to refresh… so 7 clicks total just to get the filters results.
If I can clean that to make them a button that automatically filters the 5 returns they always filter by then that just seems like a cleaner and easier for that user
I hope I explained a little better. Again thanks for the examples!
If I understand correctly your need here, then I think, like Frederico suggested it above, using a utility table could help as the “Clear” button I put in my last example (on the canvas) could clear the checkboxes in the table you need to filter and also the Filtering by values in the utility table (as buttons on the canvas work a little bit differently than buttons in a table).
Here’s another example using a utility table .
It’s still works like my previous one though (not actively filtering the table, just checking the right checkboxes) .
Edit : You can hide the Checkbox field in the table if it bothers you .
You can also hide the Filtered Rows field in the utility table too .
I see what you mean and I encourage you to pursue your investigation (thanks also to the restless help of @Pch).
I only have the suspect this might be of an over-complex solution to a not fully outlined problem.
Unless you are totally certain that the users will only filter with those specific column values every time (and in that case, you could easily build up a view), you then have to build up new filters and maintain them every time a new user’s request arises.
This sounds a bit familiar to me as I have seen these “uncontrolled routes” so many times.
Sorry if I keep on challenging you. I’d be happy to discuss on a more concrete example if you think this is useful.