# List Filtering Issue

**URL:** <https://forum.adalo.com/t/list-filtering-issue/2407>\
**Category:** Get Help\
**Created:** [July 8, 2020, 11:43pm UTC](https://forum.adalo.com/t/list-filtering-issue/2407 "2020-07-08T23:43:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isimmons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/isimmons/32/1343_2.png) [@Isimmons](https://forum.adalo.com/u/Isimmons)\
**Post date:** [July 8, 2020, 11:43pm UTC](https://forum.adalo.com/t/list-filtering-issue/2407/1 "2020-07-08T23:43:47Z")

</div>

I have a list where users can choose activities to sign up for. That list is pulling from a database that has a property that shows the requested amount of users they want to sign up for. Once a user signs up, it drops their username into another property. By doing this, I can show use a count function to show how many users have signed up and show on the list (I.E. 0/2 users signed up). What I am now trying to do is add in some filtering so that item activity only shows if there are still spots remaining.

I thought this would be as easy as adding in a filter that has this argument but the option does not exist. I can add the count of the signed up users as one side of the filter argument but I cannot add the requested # of users as the other side of the argument. See screenshot below.

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

Any ideas on how to make this work?

---

<div class="post-metadata">

**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\
**Post date:** [July 9, 2020, 3:38am UTC](https://forum.adalo.com/t/list-filtering-issue/2407/2 "2020-07-09T03:38:42Z")

</div>

I would do :  
“Long Travel Bus” “activity” needs 2 Bus drivers.  
I would make another collection “ACTIVITY” beside the USER collection:

- Activity name / needed users / actual users / emailA / EmailsB
- Long travel Driver / 2 / 0 / empty / empty

UserA 1 logs in and choose…  
“Long travel” is displays (among other activities)  
for now Long travel = 0 (drivers)  
UserA click on “Button Driver1”, (Adds himself to this activity)  
“Long travel” now displays… = 1 Driver (1 more missing) / userA@email / empty

UserB; logs in and subscribes to the same activity. Now Bus drivers = 2. / userB@email completed  
run filter : if needed bus driver = bus drivers subscribded  
Send Email (or whatever form of message) to EmailA and B = “Hello you have another driver ready to go.” contact : EmailA/B  
\*you would need tome Date to reset each activity …at some moment  
and voila…  
🚒 🚒 🚒 🚒 🚒 🚒

---

<div class="post-metadata">

**Author:** ![Isimmons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/isimmons/32/1343_2.png) [@Isimmons](https://forum.adalo.com/u/Isimmons)\
**Post date:** [July 10, 2020, 2:16am UTC](https://forum.adalo.com/t/list-filtering-issue/2407/3 "2020-07-10T02:16:14Z")

</div>

Not exactly what I am doing and I am afraid it would take me too much time to try to explain. Thanks for the help though.

---

<div class="post-metadata">

**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\
**Post date:** [July 10, 2020, 2:22am UTC](https://forum.adalo.com/t/list-filtering-issue/2407/4 "2020-07-10T02:22:30Z")

</div>

no problem, with more complicated script you ve got to try to create it as far as you can…then share screens if ever needed then

---

<div class="post-metadata">

**Author:** ![Isimmons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/isimmons/32/1343_2.png) [@Isimmons](https://forum.adalo.com/u/Isimmons)\
**Post date:** [July 10, 2020, 10:09pm UTC](https://forum.adalo.com/t/list-filtering-issue/2407/5 "2020-07-10T22:09:56Z")

</div>

I’d be happy to zoom screen share It’s all built. just hard for me to convey.

if interested, let me know.

---

<div class="post-metadata">

**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\
**Post date:** [July 10, 2020, 11:51pm UTC](https://forum.adalo.com/t/list-filtering-issue/2407/6 "2020-07-10T23:51:08Z")

</div>

so you mean its buit …and working as you’d liked…or still some issues ?
