# Limiting data to logged in user of relational Airtable

**URL:** <https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709>\
**Category:** Ask for Help\
**Created:** [August 14, 2022, 9:00am UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709 "2022-08-14T09:00:15Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 14, 2022, 9:00am UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/1 "2022-08-14T09:00:15Z")

</div>

Hello,  
I am very new to glide & to airtable. I have created an air table, simple relationship of participant who then participates in many events. When participant logs in, they should be restricted to their profile and to their events. I can successfully restrict the participant in one of three ways (flag as row owner, create a visibility condition on the tab, add a filter on the list), HOWEVER when I try and do the same on the events they participate in, I have no option to flag the foreign key field as event owner, and I can only set the condition and filter to empty or not empty.

Thus when someone logs into the Glide APP, they can see only themselves as participant, but can still see every event that everyone else has entered. Can anyone advise how I go about to solve this issue?

Much appreciated  
Zita

---

<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 14, 2022, 12:15pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/2 "2022-08-14T12:15:43Z")

</div>

Can you share some screenshots showing how you have everything set up?

---

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 14, 2022, 9:10pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/3 "2022-08-14T21:10:31Z")

</div>

![RelationalProblem_Image_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/831fedc3dbfd552618aa85100ba976d27051f707.png)

---

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 14, 2022, 9:11pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/4 "2022-08-14T21:11:01Z")

</div>

![RelationalProblem_Image_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/0/305c3f3b5c44e1f509e1edec3bccf8263427de84.png)

---

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 14, 2022, 9:11pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/5 "2022-08-14T21:11:58Z")

</div>

Thank you for looking into this. I have taken some images from Airtable as well as Glide and uploaded as best I can to describe what I am seeing.

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [August 14, 2022, 10:24pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/6 "2022-08-14T22:24:29Z")

</div>

Hey Zita,

You can use a join list column to convert this to a string and then filter with that!

Check this video! : [Airtable Dances - Glide.mp4 on Vimeo](https://vimeo.com/739479591) ( sorry for not having audio. mic was good before but it braked this week and trying to fix it. )

Thank you

---

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 14, 2022, 10:28pm UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/7 "2022-08-14T22:28:04Z")

</div>

Thank so much for this. I am just out for a small bit. As soon as I get home I will try this!! So very much appreciated 🙂

---

<div class="post-metadata">

**Author:** ![ZitaKemp](https://avatars.discourse-cdn.com/v4/letter/z/d26b3c/32.png) [@ZitaKemp](https://community.glideapps.com/u/ZitaKemp)\
**Post date:** [August 15, 2022, 1:50am UTC](https://community.glideapps.com/t/limiting-data-to-logged-in-user-of-relational-airtable/46709/8 "2022-08-15T01:50:08Z")

</div>

I have played around with this quite a bit since is went through all the details of your email. I was very helpful. I ended up solving this with a combination of what you had recommended. I created a copy of the relational field (FK Email address) and then added an if-then-else field which I filtered on. This is working really well.

 ![RelationalProblem_Image_3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf5a6bf5e027a2f7282951dfc665279bbcc5d74b.png)  
Thank you so much for your time!
