Adding Tags to photos so dynamically searchable

[Robert_Petitto]

I JUST created this yesterday. Give me a second and I’ll do a quick tutorial.

[Vaughan_Broderick]

Thanks for the responses. I’ll check out this asap

[Robert_Petitto]

Bah it cut me off after 3 minutes! I’ll need to rerecord

[Vaughan_Broderick]

[ehdubya]

This would be awesome! Thanks Robert!

[Robert_Petitto]

As promised:

Glide: Create Searchable, Filterable and Clickable TAGS

[Vaughan_Broderick]

Thanks Robert!

[Vaughan_Broderick]

Hi Robert, would you mind posting the 2 formulas that you mention in the video.
Cheers

[Robert_Petitto]

I said I’d do that, didn’t I?

Make Tags Lowercase Column:

={"Tags (lower)";arrayformula(if(len(O2:O),lower(O2:O),""))}

Unique Tags Column:

={"Unique Tags";sort(unique(TRIM(transpose(split(textjoin("|",true,iferror(split(Posts!P2:P,","))),"|")))))}

[Vaughan_Broderick]

Thanks Robert! A big help. Now to see if I can get this done.

[Robert_Petitto]

[Krivo]

@Robert_Petitto really well done. Think a lot of people can use this.

[ehdubya]

Thanks for this Robert!

Whoa…wait a sec…

[Robert_Petitto]

CSS

[ehdubya]

Figured that was the case! Thanks for the reply!

[kabookie]

I think my brain exploded watching that video.

[Vaughan_Broderick]

@Robert_Petitto thanks for your help Robert. I got this built successfully!

I was able to show my project sponsor last week and loved the app. One thing I need to add was how to also filter the tag buttons by another variable - the person who the post was recorded for.

To explain, this app captures photos by a User on behalf of children in care. Then once tagged, the person or child can review the photos. So at the moment all the tagged photos for every child show up in every child’s photo section. As opposed to only the tagged photos for that child. In this case I would only want to see the tags ‘sport’ and ‘family’ for this child.

Any thoughts on this feature? Appreciate any assistance.

[ThinhDinh]

I assume you can do a relation of the tags back to the images sheet and return all the emails that has images containing that tag. Then you can have a joined list column to return all the matching emails.

Filter the inline list by email joined list includes signed-in user’s email, or something along those lines.

[Robert_Petitto]

Off the bat, you’ll need to filter where filter name is the one clicked AND where user tagged is user sheet > user.

To prevent tags from even showing up, you’ll need to do a bit of dancing. My first inclination is to do a mult relation from the user to the photos sheet. Then, lookup the filter names. Then in the inline list, filter where filter name > is included in > user > filter name lookup

[Robert_Petitto]

This is also a good solution.