Hi everybody I would like to put a filter of the table in the section via a button. I can not get it though. Can someone give me an example? The filter in the table to set directly works fine but the button does not work

Hey all - just came across this thread and wanted to share an update. The launch of our SetControlValue formula may actually provide an easier solution to this problem. You can take Alden’s earlier suggestion , but you no longer need to use a second table for the checkbox. You can just build the chec…

Dear @Max_Huttmeier , As far as my knowledge goes, you will need to create a control to be able to filter your table, buttons do not have this functionality Below is one of the many supporting materials available: https://help.coda.io/controls/filtering-tables-and-views-based-on-controls Hopeful …

@Max_Huttmeier As @Jean_Pierre_Traets mentioned, the best way would be to use existing controls to use as a filter. I could see that in some cases you want to use buttons - here’s an example how you could do it. Doesn’t scale for all cases (like where you have big set of possible values to filter…

Thanks for your advice. But my approach is different: If a user in a view has filtered and sorted the data differently, he should be able to set a standard filter and a standard sorting with the button again. So I need a function that writes a filter statement in the table filter and thus restores…

I like the idea; I don’t think it’s possible the way you’re intending to do it. You can do what Krunal suggested and turn the filter criteria into a column but that complicates it. It would be nice to store a set of filters and sorts to a data set. Power BI has a similar feature called bookmarking…

[image] Shaun_McLean: It would be nice to store a set of filters and sorts to a data set. Power BI has a similar feature called bookmarking. I’d be all for it. +1 on being able to save different configurations of filtering/sorting rules. Having the ability to toggle between pre-saved configu…

I was actually digging around a bit. There’s a hacky way to do it: [image] Hack to filter lots of data Tips and Hacks Hi, For the lookup columns I added ToText() and then it works fine. Lower(Description+","+FormulaSelect.ToText()+","+[Doc<>]) Does this work for you. …

Here’s another example of how to filter a table using a button: This has a separate table of filter settings that you can enable/disable via buttons on the canvas.

Because I searched for a while: in the formula for the filter, the row from the “Filter Settings” table is reached using “@”, in this case @Show Done?

Hi everyone, I found an easy way to display both checked and unchecked row. Create a “Done” column with a Checkbox type Filter 1 - Create filter based on the “Done” column, set as “is unchecked”. Filter 2 Create a second filter based on the “Done” column, set as “is checked”. Use the “O…

Set filter with a button

Shaun_McLean March 28, 2019, 12:04am 7

I was actually digging around a bit. There’s a hacky way to do it:

Topic		Replies	Views
Can you use a button as a filter for a table?	3	1400	August 28, 2022
Button to filter table	8	282	July 2, 2025
How to apply table filters with buttons?	4	1878	June 17, 2020
Filter Button to Toggle Table Views Product Feedback	11	1753	April 1, 2020
Directly apply filters to buttons Product Feedback	1	447	February 13, 2022

Set filter with a button

Related topics