# Projects **URL:** \ **Category:** Ask for Help\ **Created:** [December 6, 2023, 3:22pm UTC](https://community.glideapps.com/t/projects/68427 "2023-12-06T15:22:38Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 6, 2023, 3:22pm UTC](https://community.glideapps.com/t/projects/68427/1 "2023-12-06T15:22:38Z")
Hi, I’ve set up my Airtable so that I have users and users work for organisations that sits in a linked table and each organisation has porjects which is also in a linked table. I want to be able to filter the projects page based on the logged in users, organisation, projects… but I can’t seem to find a way to do this. I would have assumed the filter would say, “Project Name” “is included in” “Organisaions - Projects” But Organisaitons is not listed an option, nor is user organisations Any help would be much appreciated. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ee7bd363eb15bbe1d85c80f3f58fe9a24885665.png) I’ve also tried using the linked record “Organisation” but there is no usable data in there either ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7090a1abbeb1798deb9a68b72132694ade72654a.png) I was expecting it to say “Organisation” “is equal to” “Logged in users Organisations” ---
**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:** [December 6, 2023, 3:32pm UTC](https://community.glideapps.com/t/projects/68427/2 "2023-12-06T15:32:48Z")
Disclaimer: I’m not an Airtable user, so the below is no more than a semi educated guess. Can you show me what the “Organisations” column looks like in the Glide Data Editor? My suspicion is that it probably appears as an array, in which case you might need to flip your filter around and use something like “Organisations includes Project Name”. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 6, 2023, 3:35pm UTC](https://community.glideapps.com/t/projects/68427/3 "2023-12-06T15:35:59Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/93d810e832e4f42612b9cbb3ac04283c0e164bf8.png) From the projects page ---
**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:** [December 6, 2023, 3:48pm UTC](https://community.glideapps.com/t/projects/68427/4 "2023-12-06T15:48:22Z")
mmm, okay. That looks like a relation. Again, I’m not an Airtable user so I’m just stabbing in the dark a bit here. But… try adding a Lookup column that targets that Organisation column and returns the Organisation Name. And then see if you can use that in your filter. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 6, 2023, 4:00pm UTC](https://community.glideapps.com/t/projects/68427/5 "2023-12-06T16:00:42Z")
It is a relation yes. I’ve managed to do it this way ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9bf2761deeda76a8a5cb4f4cfd4fb20e73814a75.png) becasue I can access a users email. But why can’t I see a users orgnaisation ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56cb6b0a5812fcb6b23383b49ef5bacfb174672d.png) In the database Organisation is a relationship ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/974a96f65ef596ae6625039ff4312c30e6e15d42.png) ---
**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:** [December 6, 2023, 4:10pm UTC](https://community.glideapps.com/t/projects/68427/6 "2023-12-06T16:10:20Z")
> [@Si\_Gal](#): > > But why can’t I see a users orgnaisation Yes, it’s because it’s a relation. In Glide a relation just establishes a link between one row and one or many other rows. If you need to use any values in the matching row/s, then you need to use either a Lookup or Single Value column to fetch them. Try adding that Lookup column that I suggested earlier. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 6, 2023, 4:19pm UTC](https://community.glideapps.com/t/projects/68427/7 "2023-12-06T16:19:08Z")
Great it worked. Thank you Another question if that is ok. Can prefill a form field with the oganisation name rather than just filter it so only my organisation is an avilible choice. I am creating a new projects form and I want it to set my organisation automatically. Ideally the field would be prefilled and hidden ---
**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:** [December 6, 2023, 4:22pm UTC](https://community.glideapps.com/t/projects/68427/8 "2023-12-06T16:22:07Z")
Yes, check out the below: > **[Column Values | Glide Docs](https://www.glideapps.com/docs/reference/values/column-values)** > > Column values are the values contained in your data source tables. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 6, 2023, 4:36pm UTC](https://community.glideapps.com/t/projects/68427/9 "2023-12-06T16:36:17Z")
Thank you that make sense but Organisation is not showing as an option to place my colum value into ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aac77534f27eb7c163577b8a4320d72020c052ab.png) Again this is a linked field ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 6, 2023, 11:36pm UTC](https://community.glideapps.com/t/projects/68427/10 "2023-12-06T23:36:29Z")
Does your destination table contain a column for Organization? I take it you’re showing the list of columns possible for the Organization “column value” to be written to. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 7, 2023, 6:59am UTC](https://community.glideapps.com/t/projects/68427/11 "2023-12-07T06:59:54Z")
I think this is becasue I am using Airtable and linked tables seem to work differently. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [December 7, 2023, 7:19am UTC](https://community.glideapps.com/t/projects/68427/12 "2023-12-07T07:19:33Z")
Linked column of Airtable has a lot of restriction while using it in Glide. This restricts the possibilities of using Glide in various innovative ways. I personally have stopped creating Glide app from Airtable unless its very simple app. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 7, 2023, 8:14am UTC](https://community.glideapps.com/t/projects/68427/13 "2023-12-07T08:14:34Z")
Yes i am very quickly coming to the same conculsion. Thanks ---
**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:** [December 7, 2023, 8:17am UTC](https://community.glideapps.com/t/projects/68427/14 "2023-12-07T08:17:41Z")
I’m sure Airtable is a great product, but I’ve seen enough here in the Glide Community to come to the conclusion that it doesn’t play well with Glide. So I’d back up what @Pratik_Shah said. ---
**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\ **Post date:** [December 7, 2023, 10:02am UTC](https://community.glideapps.com/t/projects/68427/15 "2023-12-07T10:02:16Z")
Sold haha. I’ve made the switch ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 14, 2023, 10:02am UTC](https://community.glideapps.com/t/projects/68427/16 "2023-12-14T10:02:33Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.