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 cer…

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 r…

We are not allowed to filter by array column. [image] Array Column Report a Bug So If I have columns named Skills 1, Skills 2… Skills 6 it creates an array column in DATA named “Skills”. [image] [image] I want to be able to filter a layout based on the data in that o…

This worked perfectly! :grinning:

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] Screenshot of data in Glide. I may not have needed to create an additional Relation column since Glide automatically created fro…

Interesting, I’ll have to take a look at that. I appreciate the clarification.

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

She :+1: Thanks again for the fix, this is the best work around I’ve found to showcase many-to-many relationships.

[image] lmishelle: She :+1: @lmishelle This was very helpful!

[image] Filtering data per record Feature Requests @lmishelle This was very helpful! *Ignore this repost

Filtering data per record

Feature Requests

Tim_Sullivan December 31, 2019, 4:36pm 3

We are not allowed to filter by array column.

Topic		Replies	Views
Array Column Report a Bug	2	471	December 23, 2019
Array to array relation with AND condition Ask for Help	13	2420	March 19, 2021
Matching data using Query and filter Ask for Help	14	133	May 4, 2025
Relation multiple factors Ask for Help	19	428	June 7, 2021
Filter for something included in an array Ask for Help	16	917	August 26, 2021

Filtering data per record

Related topics