Dropdown filter that returns empty options from the database

blzr1987 · 2024-10-16T18:58:14.226Z

Hello, could anyone help me? I want to fetch only the Yes/No options from the database and show them in my Dropdown to create a filter on a repeating group element. However, when the data arrives, it brings fields into the database.

I can’t take a print with the dropdown open, as it closes before the print. But basically it opens like this:

field 1: Blank space
field 2: Yes
field 3: Blank space
field 4: No

My DB configs

{B9658EE9-5631-4064-8718-F13C789D7416}973×513 29.9 KB

{6D2AFED5-91DE-4AD4-8013-2B68418B4233}1182×504 39.7 KB

If I click on the first blank field in the dropdown it brings up all the user’s tasks.
{75B2278B-4394-4C59-AB72-891F969B0F44}

If I click on the Yes dropdown it only brings up the completed tasks
{1E94F612-2564-4C80-B6B5-1D406A0CD482}

If I click on the third option in the blank dropdown it brings all the tasks back again
{B801F27B-CB8C-4158-A288-59D362250150}

If I click on the No option in the dropdown, it only brings up pending tasks.
{F1DE8D60-C4A5-4C0E-9734-24D8916F1AF8}

Dropdown Menu

{9C58C0F1-8C1E-4B19-8807-B65840F8F076}764×569 45.8 KB

Repeating Group

{984FE08C-DBFA-4B9B-B922-043EDB903C4A}778×565 42.1 KB

QIRO · 2024-10-16T19:06:42.524Z

Can you not add a constraint to the search to mitigate the blank values?

[task_done] is not blank?

blzr1987 · 2024-10-16T19:14:31.704Z

Sorry, I’m new to Bubble. I’m still learning, do I add this constraint to the repeater group or to the dropdown element?

{C262565B-B319-4903-A85C-39FD57E3267E}728×564 33.2 KB

Would it be here?

QIRO · 2024-10-16T19:17:13.530Z

Instead of ‘=’ what options are you given?

blzr1987 · 2024-10-16T19:26:01.978Z

These are the options

{ADF6B598-AA38-491D-A16F-FFB40B3E154E}688×544 35.1 KB

singhsahib · 2024-10-16T19:43:05.211Z

I think for dropdown you should use static values i.e Yes & No.

And then wherever you need to use the dropdown’s value in a constraint, you should add the expression, " Dropdown’s value is Yes".

QIRO · 2024-10-16T19:53:49.778Z

As @singhsahib has said, you can use static values, then match the rows to the values.

Alternatively, if you don’t want to backtrack, just select ‘isn’t empty’.

blzr1987 · 2024-10-16T21:56:52.903Z

Thank you, it worked… investigating here, I just needed to set the task_status default to No in the database, as it understands that it has 3 options, blank, yes and no. This already eliminated the duplication problem, and to remove the blank field, just mark in the dropdown that it could not be empty and it worked. Thanks