# Needed Feature: Inverse Relation

**URL:** https://community.glideapps.com/t/needed-feature-inverse-relation/6201
**Category:** Feature Requests
**Created:** [March 31, 2020, 3:39pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201 "2020-03-31T15:39:48Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [March 31, 2020, 3:39pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/1 "2020-03-31T15:39:48Z")

</div>

Hi, I’m wanting to display to the user the resources made by the creator, except for the one currently being displayed. I know there’s the filter option, but not sure how to exclude the one the user is currently viewing. Is there an easy way to do this within the filter option? I’m not familiar with what values can be entered. Here’s the screenshot below…

![glide-related](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/38c9268e341603a15a77b601a3453157b6565ff7.png)

Similar to someone coming to the end of a blog post and seeing the related blog posts that they might want to check out. The user wouldn’t want to see a blog post link to the post they’re currently viewing. That’s what I’m trying to achieve here…

Thanks for your help!

---

<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: [April 4, 2020, 7:47pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/2 "2020-04-04T19:47:08Z")

</div>

I’m drawing a blank on this one. I can’t think of a way to do it with the current feature set. In the past I’ve asked for the option of an inverse relation where it returns everything that does not match. This seems like another good case for this. Or if we could set the filter on the inline list to only show records that do not match the current record you are viewing. These aren’t options at the moment.

---

<div class="post-metadata">

### Author: ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)
#### Post date: [June 29, 2020, 12:30am UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/3 "2020-06-29T00:30:22Z")

</div>

Is there an option to do that now?

---

<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: [June 30, 2020, 1:39am UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/4 "2020-06-30T01:39:10Z")

</div>

Not that I’ve been able to figure out. Glide expanded filters to allow for filtering a column based on another column in the same row, but I don’t believe you can filter an inline list by the parent row.

---

<div class="post-metadata">

### Author: ![Adam\_Xu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_xu/32/9762_2.png) [@Adam\_Xu](https://community.glideapps.com/u/Adam_Xu)
#### Post date: [June 30, 2020, 2:57am UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/5 "2020-06-30T02:57:26Z")

</div>

I had a similar situation while using “other similar listings” in a city directory app. I happened to separate my list into regular ones and featured ones, which I plan to charge. Only featured (paid) ones can be listed under detail page of regular ones, plus there will be no other listings at all under detail page of featured ones. That kind of avoided this problem.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 26, 2020, 6:34pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/6 "2020-12-26T18:34:05Z")

</div>

> [@Jeff\_Hager](#):
>
> In the past I’ve asked for the option of an inverse relation where it returns everything that does not match.

@Mark, I ran into another situation where I could REALLY use this feature. Any chance we can revisit? 🙏 I have screen filtering set up—and that gets me halfway there—but the inverse relation is needed to display users who don’t match a dynamic list. There’s no way to do this in my current setup.

@Jeff_Hager

---

<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: [December 27, 2020, 6:43am UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/7 "2020-12-27T06:43:10Z")

</div>

Agreed! Any case I’ve ran into involves the need to filter a relation inside the data editor to properly calculate rollups. There’s no way possible without some ugly workarounds. Sometimes we need to manipulate this data before we get to the visual user side of the app.

I’ll just place this link here as well. 😉

> [@Conditional Relations](https://community.glideapps.com/t/conditional-relations/13818):
>
> I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 27, 2020, 6:04pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/8 "2020-12-27T18:04:42Z")

</div>

Adding conditions into other columns would be neat—especially template/math columns.

---

<div class="post-metadata">

### Author: ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [December 27, 2020, 6:56pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/9 "2020-12-27T18:56:01Z")

</div>

This should now be possible with in-screen filters

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 27, 2020, 6:59pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/10 "2020-12-27T18:59:55Z")

</div>

@Manan_Mehta, as I mentioned above, screen filtering gets me 1/2 way…it allows me to display the information correctly on the front end, but inverse relations are necessary for logic in the GDE.

Vote here:

> [@Conditional Relations](https://community.glideapps.com/t/conditional-relations/13818):
>
> I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 9, 2021, 4:59pm UTC](https://community.glideapps.com/t/needed-feature-inverse-relation/6201/11 "2021-02-09T16:59:29Z")

</div>


