Dropdown after select only showing 1 item

After selecting a item from the dropdown list. Say there is 100 items. The list will then be limited to jus the selected one. I prefer 100 items to still show but of coarse the one I clicked on is selected.

Below is example of what happens after I click on “test’“

Is this the single select widget? How is your setup? It usually does not limit to a single option after selecting one.
This looks as if you have a trigger, that changes the options of your Selection Option Data Source

I think I have it right, I tried it with triggers off, Unsure if its because im using a Aggregation?

Unsure how to edit post so making another.

Solved. I had aggregation that was using a query that had a filter on it. recreated query with no filter and all is good now.

1 Like

Glad you got it sorted. For anyone reading later, this behavior comes from how Tulip handles Table Queries and Aggregations. Aggregations always return a summarized list based on the query they sit on top of. The docs note that queries and aggregations “filter and summarize your data for use in Apps”:
https://support.tulip.co/docs/table-queries-and-aggregations

The Community guide on dynamic single selects shows the same setup, where a “unique values” aggregation is used to populate dropdown options:
https://community.tulip.co/t/using-values-in-one-single-select-menu-to-dynamically-populate-values-in-a-second-single-select-menu-part-1/7251

So if the query feeding the aggregation has a filter, the Single Select will only show the values returned by that filtered result. Removing the filter (or adjusting it) restores the full set of options.

This is expected behavior and consistent with how Tulip queries and aggregations work.

1 Like