# Can't seem to get multi-select working as filter

**URL:** <https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790>\
**Category:** Ask us anything\
**Tags:** filter\
**Created:** [October 8, 2023, 1:05pm UTC](https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790 "2023-10-08T13:05:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [October 8, 2023, 1:05pm UTC](https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790/1 "2023-10-08T13:05:20Z")

</div>

Hello!

I have no problem with single select, but don’t understand how I can filter results with multi-select.

I have a database in Supabase, where I have categories.  
Currently it has ID, Name

Another database with the tools, that has 2 relation columns(primary\_category & secondary\_category) to the database category id.

I’ve chosen multi-select dropdown, where after you have clicked on the values, you get these variables (which are categories\_id)  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/504b9db9ce012f99fc98dfb19622c7652fc5566e.png)

Afterwards, I don’t understand how I can create a formula that filters only tools, that has these IDs (screenshot) all of those tools, for primary\_category and secondary\_category.

Any tips?

---

<div class="post-metadata">

**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\
**Post date:** [October 9, 2023, 2:58pm UTC](https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790/2 "2023-10-09T14:58:50Z")

</div>

Hi @david 👋

I made [this video for you](https://youtu.be/B-ECnBQh9Gc?si=YxUIRgUDSj3MG2YD), let me know if it helps.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [October 11, 2023, 3:07pm UTC](https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790/3 "2023-10-11T15:07:10Z")

</div>

Thanks @Joyce,

Thank you for your previous assistance. I managed to fix this with your pointing out of using “in” instead of “=”, which had me stumped.

Now, I’m encountering a different challenge that perhaps you or other community members could assist me with.

I have set up three databases: “Tools”, “Professions”, and “ToolsProfessions”. In the “ToolsProfessions” database, I have established connections between “Tools” and “Professions” since one tool can be applicable to multiple professions. However, I’m struggling to figure out how to implement additional filtering with this setup.

I appreciate any guidance or suggestions you or the community could provide.

Thank you!

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [October 11, 2023, 9:40pm UTC](https://community.weweb.io/t/cant-seem-to-get-multi-select-working-as-filter/4790/4 "2023-10-11T21:40:53Z")

</div>

How does the data look when you pull it from Supabase? Could you share an example that you actually want to filter? Do you filter it on the front(weweb) or backend (supabase)?