# Inverted Relation

**URL:** <https://community.glideapps.com/t/inverted-relation/3553>\
**Category:** Feature Requests\
**Created:** [January 12, 2020, 11:56pm UTC](https://community.glideapps.com/t/inverted-relation/3553 "2020-01-12T23:56:15Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 13, 2020, 3:25pm UTC](https://community.glideapps.com/t/inverted-relation/3553/3 "2020-01-13T15:25:41Z")

</div>

Yeah, I guess it would have helped to actually paste the link to the original post, huh. I guess I forgot to do that. The original problem involves a non-user specific list of tasks, so only one list is maintained. A user can open a task and then using a form button, they can submit that they completed the task. What I would like to do is to then provide a list of only the tasks that the user has Not completed yet. I’ve been trying to solve this in my concepts app if you need a better visual. On a user record, I am able to get an array of completed tasks using relation and lookup columns. I would like to then use that array list for an inverted relation against the generic task list sheet to only get the records that do not match the list.

Like I said before, I think the new filter options you have in staging would solve this particular problem beautifully.

I don’t have any other great examples, but maybe this would also be useful in situations where you want to return a list of available items for sale, or available timeslots for appointments. By using an inverted relation and an array of purchased items, or occupied timeslots, you can easily only return the unpurchased items/open timeslots.

> [@Filter to use Per User email and "contains" operator](https://community.glideapps.com/t/filter-to-use-per-user-email-and-contains-operator/865):
>
> I’m working on solution for this thread ([Help designing spredsheet/Glide - Curriculum with many user](https://community.glideapps.com/t/help-designing-spredsheet-glide-curriculum-with-many-user/813)) and building it into into this app ([https://concepts.glideapp.io/](https://concepts.glideapp.io/)). I think I came up with a really simple solution to use one list of tasks, but display it and filter Finished and Not Finished tasks for multiple users. My idea is to use a Filter with the Contains operator. The only thing I’m missing is the option to obtain the user email for the filter. I don’t think the Per User Data would…

---

_[View the full topic](https://community.glideapps.com/t/inverted-relation/3553)._
