Hi everyone, new to Glide!
Is there a way to find duplicate values between two columns that consist of arrays (retrieved from lookups)? In the example below, I’d love to create a new column that shows this data. For each row, the only value would be “Exercise & Fitness”.
Thanks for any help!
What you can do is take your first lookup and use it to create a second relation to your data. That way you will use your array of Liker Hobbies in a relation to any matching rows in a Likee relation.
You can’t compare two arrays like you’re asking. You have to use the Relation → Lookup → Relation → Lookup method. Hope that makes sense.
2 Likes