Filtering records that share the same tags

[david_essman]

I have a base that has a table for tags, a table with a list of clients, and a table with images

in the images table I have images, a lookup field for the tags from the tags table, and then a lookup field for client

client A’s red tagged images are image 1 and image 4
client B’s red tagged images are images 2 and 3

in the client tag sets base, I specify which tags belong to each client (tags can overlap)

client A: red, green
client B: yellow, orange, red

both client A and B have images tagged ‘red’

in the tags table, it shows each of the tags, the images containing each tag and the client tag sets

I’m having trouble figuring out how to create a grid view within the tags table that will show the images tagged ‘red’ but only if their client is client A. and then another grid view that shows images tagged ‘red’ but only if their client is client B.

[TheTimeSavingCo · Accepted solution]

Hm, I think for this you may need to use the conditional lookups / rollups instead of view filtering I’m afraid

[david_essman]

Thank you! I think this worked. I created a separate lookup field for client A and another lookup field for client B and then created grid views for each and just hid other one.

The only drawback is lookup field can only get the image(in the attachment field) and not the entire record