# Combine two filters (simulate OR clause for list)

**URL:** <https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686>\
**Category:** Get Help\
**Created:** [December 10, 2021, 6:57pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686 "2021-12-10T18:57:29Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![sladerose](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/sladerose/32/7333_2.png) [@sladerose](https://forum.adalo.com/u/sladerose)\
**Post date:** [December 10, 2021, 6:57pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/1 "2021-12-10T18:57:29Z")

</div>

Hi, I’m in desperate need of combining two custom filters for a list, however, I need the filters to be OR clauses. I am happy to employ any workaround.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1af121d69bf751fc4e1a37216ac861495b9a4c36.png)

---

<div class="post-metadata">

**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\
**Post date:** [December 10, 2021, 8:23pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/2 "2021-12-10T20:23:04Z")

</div>

Stay tuned! 😁

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [December 10, 2021, 8:28pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/3 "2021-12-10T20:28:49Z")

</div>

😲 is it going to be a new release???

---

<div class="post-metadata">

**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\
**Post date:** [December 10, 2021, 9:02pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/4 "2021-12-10T21:02:06Z")

</div>

> **[Logical "And" and "Or" functions | Voters | Adalo](https://ideas.adalo.com/feature-requests/p/logical-and-and-or-functions)**

---

<div class="post-metadata">

**Author:** ![TKOTC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/tkotc/32/6863_2.png) [@TKOTC](https://forum.adalo.com/u/TKOTC)\
**Post date:** [December 11, 2021, 3:07am UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/5 "2021-12-11T03:07:46Z")

</div>

Hi, the workaround is the use an external service like Xano or Integromat. You still store the data in the Adalo database, but you use the external collections to get the list of users. Integromat will retrieve all the calendar dates, tasks, and users then apply the filter you want. You link the list to the external collection that you create.

It is a little convoluted. Maybe @Erik has a video tutorial on this

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [December 14, 2021, 10:23am UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/6 "2021-12-14T10:23:04Z")

</div>

Hi @sladerose,

If the list isn’t too long, you can try to achieve this using visibility condition. I’ve created a short video with a workaround: [Adalo hints: how to simulate OR condition in the list - YouTube](https://youtu.be/sVCbURCCrwc)

As for me this is suitable for smaller-sized lists; for larger amounts of data it’s better to use methods advised by @TKOTC or wait till Adalo introduces built-in OR filtering 🙂

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![TKOTC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/tkotc/32/6863_2.png) [@TKOTC](https://forum.adalo.com/u/TKOTC)\
**Post date:** [December 14, 2021, 2:02pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/7 "2021-12-14T14:02:11Z")

</div>

I think that might lead to duplicates in the list. A long time ago I built the merge list that can take different collections and merge+sort them together. The original intention was to create a notification window like the Adalo forum where you merge mentions, replies, likes, etc… or to merge Facebook feeds with Twitter feeds, etc…

It might work for this, haven’t used it in a long time though.

> **[adalo-pragmaflow-components/src/components/MergeList at main ·...](https://github.com/pragmaflowinc/adalo-pragmaflow-components/tree/main/src/components/MergeList)**
>
> main/src/components/MergeList

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [December 14, 2021, 2:12pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/8 "2021-12-14T14:12:21Z")

</div>

In my solution this most probably **will** lead to duplicates if you use “contains” case - I’ve explained that in a video and showed the example.

It happens in a case when one list item matches both criteria: then both visibility conditions will be met → both groups will appear, so one item will be displayed twice.

However, this happens only on the visibility layer; the list item is a single one.

Just a clarification from my side - the trick with visibility could be used (a) when the list isn’t very large (as it is displayed in the unfiltered state, so the app will show all items - some of them invisible, but still); and (b) when the list items are kind of “unique” and there is no probability that **both** conditions are met.

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [December 24, 2021, 2:13pm UTC](https://forum.adalo.com/t/combine-two-filters-simulate-or-clause-for-list/20686/9 "2021-12-24T14:13:07Z")

</div>

Closed on December 24, 2021, 2:13pm UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
