# Options based on relation

**URL:** <https://community.glideapps.com/t/options-based-on-relation/46500>\
**Category:** Feature Requests\
**Created:** [August 11, 2022, 12:35pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500 "2022-08-11T12:35:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\
**Post date:** [August 11, 2022, 12:35pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/1 "2022-08-11T12:35:34Z")

</div>

It would be great to have also the following options based on the relation created between 2 tables.

1. To have a relation text component or to be able to select relation data from the normal components … in case we need to display several pieces of information based on the relation and to not have them only on the detail page of that page … but somewhere like in a dashboard
2. To be able to select in the visibility field also the field from the table that has a relation with the one we are editing
3. to be able to use in the functions columns data from the table that has a relation with the table we are editing.

---

<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:** [August 11, 2022, 1:07pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/2 "2022-08-11T13:07:13Z")

</div>

Do you mean as opposed to creating a lookup column against the relation and using the lookup value?

---

<div class="post-metadata">

**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\
**Post date:** [August 11, 2022, 1:23pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/3 "2022-08-11T13:23:15Z")

</div>

@Jeff_Hager Didn’t see that feature and it solves somehow points 1 and 3 and also solves something else I was looking into. But still, even for 1 and 3 you have to create additional columns, to bring the data again in the current table and to be able to use it in functions and in display … a relation is already created … why not just use it in display, visibility and functions.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 11, 2022, 1:23pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/4 "2022-08-11T13:23:16Z")

</div>

Sounds a lot like Inline Lookups.

> [@Select values from relations just like "User \>" (Inline Lookups)](https://community.glideapps.com/t/select-values-from-relations-just-like-user-inline-lookups/26092):
>
> Just like we can choose a value from a user profile sheet during if/then/else columns, template columns, filtering/visibility conditions, etc, would love to be able to do the same via relations. It would cut down on SO MUCH app bloat. @david @mark @tristan Here’s a mockup:

This one is high on the list of most requested features. Glide have said in the past that they plan to do it. We just don’t know when. If I was to hazard a guess, I’d say that getting Apps onto the NCM would have removed a fairly significant road block in terms of getting this one done.

---

<div class="post-metadata">

**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\
**Post date:** [August 11, 2022, 1:35pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/5 "2022-08-11T13:35:54Z")

</div>

@Darren_Murphy that’s right … what NCM means ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 11, 2022, 1:41pm UTC](https://community.glideapps.com/t/options-based-on-relation/46500/6 "2022-08-11T13:41:17Z")

</div>

> [@NCM - what is it and why do Glide Experts keep mentioning it?](https://community.glideapps.com/t/ncm-what-is-it-and-why-do-glide-experts-keep-mentioning-it/43387):
>
> New Computational Model? What is the ‘old computational model’ and why is their/what is the benefit of a new one? Thanks
