I have a data table in FlutterFlow. I want to create a simple search filter using checkboxes to filter certain columns in a particular way depending on which checkboxes are checked. For example, imagine that I have the following checkboxes:
- a10
- a7
- a5
These checkboxes correspond to different columns on the data table. Let's say that someone checks on "a7". That would mean that I want to filter by column a7. In particular, I want to filter the results from the database so that only return those values which are 10 or higher in column a7 appear in the data-table.
Similarly, if someone clicked on a10, then I would want to only return those values which are 10 or higher in column a10.
And if they checked both a7 and a10, then I would only want to return values which are higher then 10 in BOTH columns.
Now, the problem is, I can't figure out how to properly sync up the check-boxes with the data-table. I keep running in circles when I try and create a filter on the data-table to filter via the check boxes.
Any idea how I could do this?
Thanks.