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!
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.
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.
