# Filtering data per record **URL:** \ **Category:** Feature Requests\ **Created:** [December 30, 2019, 6:12pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207 "2019-12-30T18:12:36Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![lmishelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lmishelle/32/1316_2.png) [@lmishelle](https://community.glideapps.com/u/lmishelle)\ **Post date:** [December 30, 2019, 6:12pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/1 "2019-12-30T18:12:36Z")
Same concept as filtering per user data, but instead based on the column value of the particular record. This would be a great work around for many to many relationships until it’s released. I’m currently building a festival app for a client trying to showcase all inclusive passes available for certain events. They’ve done this by offering weekend and all access passes, the issue is that when I create a create a relationship column I only have the option to choose a weekend or weekday. This works for just weekdays, but not weekends, where the all access pass would still apply. If filtering by per data record was available, I could create an inline list and use the filter feature as such: Filter PASSTYPE that CONTAINS **[record column]** PASSTYPE would then be a set of values I set, where one would include both ‘Weekday’ and ‘Weekend’ - i.e. (1) Weekday (2) Weekend (3) Weekday/Weekend) - allowing for the correct passes to show, including those where multiple applies. Is there already a fix for this? If so that would be awesome! ---
**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 31, 2019, 12:47pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/2 "2019-12-31T12:47:06Z")
Have you tried using a relation against an array of values? For example, set up three columns like ‘PASSTYPE 1’, ‘PASSTYPE 2’ and ‘PASSTYPE 3’. Fill the first column with ‘weekday’ when it applies. Fill the second column with ‘weekend’ when it applies. Fill the third column with ‘both’ for all records. When creating your relation, Glide will present to you a PASSTYPE column which will be an array of all three columns. ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [December 31, 2019, 4:36pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/3 "2019-12-31T16:36:54Z")
We are not allowed to filter by array column. > [@Array Column](https://community.glideapps.com/t/array-column/2864): > > So If I have columns named Skills 1, Skills 2… Skills 6 it creates an array column in DATA named “Skills”. I want to be able to filter a layout based on the data in that one Skills array column. When I try to select that one array column in layout, the array column isn’t available, and I’m forced to select from the individual columns. Is there a way to do this without concatenating all the columns on the spreadsheet? This is a viable workaround, but I think you in… ---
**Author:** ![lmishelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lmishelle/32/1316_2.png) [@lmishelle](https://community.glideapps.com/u/lmishelle)\ **Post date:** [December 31, 2019, 5:22pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/4 "2019-12-31T17:22:55Z")
This worked perfectly! 😀 ---
**Author:** ![lmishelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lmishelle/32/1316_2.png) [@lmishelle](https://community.glideapps.com/u/lmishelle)\ **Post date:** [December 31, 2019, 5:49pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/5 "2019-12-31T17:49:17Z")
Jeff\_Hager’s fix requires you to create a relation from the array, not filter on it. I’ve posted a screenshot of what worked for me. ![Screenshot 12-31-2019 12-28-19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c8fb49d15f47f7fb2206a63a04af25bce9285611.png) Screenshot of data in Glide. I may not have needed to create an additional Relation column since Glide automatically created from the array. I’ll have to try it out. But, in creating my Relation column directly to the “Passes” sheet, everything lined up accordingly. Below are screenshots of the end result. You’ll see in one example where an event on a weekday only includes all access passes that cover weekdays and weekends, but does not showcase weekend passes. And for the weekend event, both pass types show up. > **[Screenshot 12-31-2019 12-30-00 PM.png](https://drive.google.com/file/d/1egvaMcGJ0VdMpdyfeJEHE384zF6DtsvW/view?usp=drive_open)** > > Google Drive file. > **[Screenshot 12-31-2019 12-34-50 PM.png](https://drive.google.com/file/d/1vGwZLcFEkmxg3zEtTQizmeogSW--P2-k/view?usp=drive_open)** > > Google Drive file. ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [December 31, 2019, 5:53pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/6 "2019-12-31T17:53:39Z")
Interesting, I’ll have to take a look at that. I appreciate the clarification. ---
**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 31, 2019, 6:17pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/7 "2019-12-31T18:17:58Z")
@Tim_Sullivan True, but he mentioned trying to set up a relation column before trying to use a filter, so that’s what I was focusing on. ---
**Author:** ![lmishelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lmishelle/32/1316_2.png) [@lmishelle](https://community.glideapps.com/u/lmishelle)\ **Post date:** [December 31, 2019, 7:56pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/8 "2019-12-31T19:56:01Z")
**She** 👍 Thanks again for the fix, this is the best work around I’ve found to showcase many-to-many relationships. ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [March 27, 2020, 6:10pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/9 "2020-03-27T18:10:01Z")
> [@lmishelle](#): > > **She** 👍 @lmishelle This was very helpful! ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [March 27, 2020, 6:10pm UTC](https://community.glideapps.com/t/filtering-data-per-record/3207/10 "2020-03-27T18:10:36Z")
> [@Filtering data per record](https://community.glideapps.com/t/filtering-data-per-record/3207/9): > > @lmishelle This was very helpful! \*Ignore this repost