Using a table with multiple conditionals/filters

Need help
1

Hi all,

I am soooo close to having a custom software up and running. I just keep having one issue. I can’t get the table functionality to work properly.

I have a few different conditionals and I don’t know how to make them operate together. I have selected ‘Ignore empty constraints’ but I just don’t understand how to make them operate in sync.

The table is a list of all commutes. I use Zeroqodes Fuzzy search to enter the names of either passengers or drivers. This works well and returns a list of the relevant users on the conditional side of things. But I also want to be able to Select a date range which limits all results to a certain period or only display commutes that are live, of a certain status, limit to a certain row count etc. I know i’m probably missing something very obvious…:sweat_smile:

I know that on the element main data source input I can do "Date = Date/Time Picker A Value etc, but it doesnt allow me to do eg: “Driver = Fuzzy search match’s” nor can I include "Row Count = Dropdown’s value

If I have explained this well enough that someone understands what I’m doing, how should I best implement this. Help is much appreciated!

image
image365×560 12.3 KB

image
image370×796 23.7 KB

3

Not sure if I got the entire picture, but here’s my take:

Search for Commutes
    Date ≥ DateRangePicker A's value:start
    Date ≤ DateRangePicker A's value:end
    Status = StatusDropdown's value
    Live?  = LiveToggle's value

:filtered
    (FuzzyDriver's Matches is empty
     OR Driver is in FuzzyDriver's Matches)
    AND
    (FuzzyPassenger's Matches is empty
     OR Passengers intersect with FuzzyPassenger's Matches :count > 0)

:items until RowCountDropdown's value
  • Fuzzy…’s Matches exist only client-side, so we tuck both fuzzy checks into a single Advanced clause—keeping them in sync while still respecting “ignore empty constraints.”
  • Driver is in… is the correct operator here; Bubble balks at Driver = FuzzyDriver’s Matches because that’s “single value equals list.”
4

Legend @adamrsousa! Will give this a go. Thank you for going to the effort of writing this out, appreciate it.

:filtered
(FuzzyDriver’s Matches is empty
OR Driver is in FuzzyDriver’s Matches)
AND
(FuzzyPassenger’s Matches is empty
OR Passengers intersect with FuzzyPassenger’s Matches :count > 0)

This may be where I was going wrong.
The original Data source of the table did incl Driver =, Date =, Live = etc, but then when the conditional on if “Fuzzy search matches are not empty” was yes, it would change data source alltogether in the conditional field which didn’t include the prior filtered conditions. This could also be somewhat good in that the search for a name superseeds any other condition…Will have to play around with it. I guess it comes down to making the conditional interact with the base data source as opposed to using a new one every time a new conditional state is met.

I have had no issues using conditional filtering on other projects but this time its doing my head in :sweat_smile: