Filter Action Not Updating Table

I have a table that loads all the data from my data source.

I want to create a button that on click filters the data and displays only the filtered data in the table.I followed Create a Filter page for how to build the filter - Create a filter | UI Bakery Docs

I’ve created my button, I’ve associated the On Click trigger with my action that filters the data, the data is filtered (I can see my results on the Result tab), but the table does not update to display only the filtered data. All the data remains displayed.

I’ve tried adding an execute action to my action steps (much like you do with an update row action) but that doesn’t work.

Not sure what I’m doing incorrectly. Any help is appreciated.

Joe

Hi @jhalpin,

I remember that modifying the table data in certain ways does not update the UI, but when I just quickly tested some ways, I had no issues whatsoever.
If you could share how exactly the filtering is done, we should be able to spot the issue. At best would be to show how the data is fetched, what the table’s data setting is set to and the action or other way that filters the data.

Hi Max,

Thanks for helping. According to the Create a Filter page, the UI should update, but maybe I’m assuming it should?

Here’s a screen cap of my action with the filter. My data source (google sheet) is named crm. And the column I’m filtering by is “Type”.

The Result tab shows the data filtered successfully (11 records out of 177 filtered) and the Logs tab indicates the action executed successfully. The filter is working but the UI does not update (the table allows me to view 177 records rather than just 11).

Is there an update UI action I can create?

I’ve also tried attaching the action to the init trigger of the table and that doesn’t work either. I’ve also tried a text input field like the example used on the Create a Filter page and the same thing occurs. Filter works but the table does not update based on the filter.

I’m missing a step for updating the table. Not sure how to do that.

Figured it out. Need to set the table’s data to the action.

2 Likes