# Adding Tags to photos so dynamically searchable

**URL:** <https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096>\
**Category:** Ask for Help\
**Created:** [January 13, 2021, 1:06am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096 "2021-01-13T01:06:51Z")\
**Posts on this page:** 18\
**Page:** 2

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 18, 2021, 1:17am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/22 "2021-01-18T01:17:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 18, 2021, 1:19am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/23 "2021-01-18T01:19:39Z")

</div>

This is also a good solution.

---

<div class="post-metadata">

**Author:** ![Vaughan\_Broderick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vaughan_broderick/32/19640_2.png) [@Vaughan\_Broderick](https://community.glideapps.com/u/Vaughan_Broderick)\
**Post date:** [January 18, 2021, 2:17am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/24 "2021-01-18T02:17:58Z")

</div>

@ThinhDinh @Robert_Petitto Thanks guys, I’ll try them

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [January 24, 2021, 11:32am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/25 "2021-01-24T11:32:01Z")

</div>

Hey @Robert_Petitto , great stuff as usual, question. Could you not achieve this by using a joint list on a glide table so it doesn’t use rows…??

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [January 31, 2021, 11:00pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/26 "2021-01-31T23:00:48Z")

</div>

This is really good!

---

<div class="post-metadata">

**Author:** ![Boomer\_Rose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomer_rose/32/29375_2.png) [@Boomer\_Rose](https://community.glideapps.com/u/Boomer_Rose)\
**Post date:** [February 21, 2021, 5:40am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/27 "2021-02-21T05:40:32Z")

</div>

I am using your formula but keep getting an #REF and saying it will overlap into another column any fix for this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 21, 2021, 5:57am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/28 "2021-02-21T05:57:47Z")

</div>

Can you post the formula that gives the error, and a screenshot of the sheet that shows the column headers?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 21, 2021, 1:41pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/29 "2021-02-21T13:41:08Z")

</div>

You’ll need to delete any other existing content/formulas in that column.

---

<div class="post-metadata">

**Author:** ![Shiv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shiv/32/25831_2.png) [@Shiv](https://community.glideapps.com/u/Shiv)\
**Post date:** [May 12, 2021, 6:59pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/30 "2021-05-12T18:59:31Z")

</div>

Hey @Robert_Petitto - I finally got this working on my app and was struggling to understand the concept more than just replicating it. Glad I was able to get through. In my case am using the concept of “Category” against which am tagging each of the posts, hence the post:category is 1:1 mapping.

Now that I have got it working, I have a small UI issue that is seeing. I am displaying it as tile it’s taking too much space even with the smallest of the image aspect ratio. Currently have put it as Lists. The small grey box is that because of a CSS ?

 ![Screenshot 2021-05-13 at 12.27.40 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/69f5b134176d66e8814f44e8707a2f9f61b87039.jpeg)

Secondly is there an option to display this inside a basic table? I presume NO?

Thanks

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 12, 2021, 7:20pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/31 "2021-05-12T19:20:11Z")

</div>

Could be CSS if you have any on there. Otherwise, reconfigure your tiles to be 4-wide.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 12, 2021, 11:21pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/32 "2021-05-12T23:21:10Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/5164125dd0662d51ee6678a8a2f0ad2fcee7d819.png)

As Bob said, I usually use a tiles layout for this tag (3-wide or 4-wide), then link it to a screen with all related posts.

---

<div class="post-metadata">

**Author:** ![ply](https://avatars.discourse-cdn.com/v4/letter/p/838e76/32.png) [@ply](https://community.glideapps.com/u/ply)\
**Post date:** [January 24, 2024, 2:44pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/33 "2024-01-24T14:44:27Z")

</div>

is there a way to create the same result with at unique list of tags inside glide instead of using the Unique Tag column formula in google sheet?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 24, 2024, 3:26pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/34 "2024-01-24T15:26:23Z")

</div>

Kinda, but not really. You need to use a helper table with as many rows as you think you’ll need. Then you’ll need to transpose the unique array using the Miracle Method.

Here’s a brief overview:

---

<div class="post-metadata">

**Author:** ![ply](https://avatars.discourse-cdn.com/v4/letter/p/838e76/32.png) [@ply](https://community.glideapps.com/u/ply)\
**Post date:** [January 25, 2024, 1:07pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/35 "2024-01-25T13:07:50Z")

</div>

i get the idea. I just have the problem that i have several tags in each element and i dont know how to make them into one text string, like the textsplit function would do it.

 ![Skærmbillede 2024-01-25 kl. 14.04.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08cf851927f85d1ab792b99b830a7d643def5a46.png)  
in the screenshot i’ve used the lookup function you mention, which gets me allTags

the lookup is getting data from the colon Tags  
 ![Skærmbillede 2024-01-25 kl. 14.09.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/515df6c6e0a88ba4c87be2d91f6f1e75244d57a1.png)

i have tried making a new colon using the Splitext in Glide, but then i cannot make a lookup and that colon. Maybe because it´s an array or what?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 25, 2024, 1:20pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/36 "2024-01-25T13:20:25Z")

</div>

1. Add a join list column that points to the allTags column.
2. Use a split text column to create a new array of individual items.
3. Point the unique elements columns to the split text column

Continue as originally instructed ✌

---

<div class="post-metadata">

**Author:** ![ply](https://avatars.discourse-cdn.com/v4/letter/p/838e76/32.png) [@ply](https://community.glideapps.com/u/ply)\
**Post date:** [January 25, 2024, 2:32pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/37 "2024-01-25T14:32:08Z")

</div>

yeah joinlist was the one i was looking for 🙂 i followed all instructions and all works fine until the single value based on the index, which does not create the individual tags.

 ![Skærmbillede 2024-01-25 kl. 15.27.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd5189db174c3ad0d2dec0bf83503e2a0f6256b9.png)

Can I use the index value this way, since the original element of index(0) might contain more value?

it works now! Thank you so much 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 25, 2024, 3:37pm UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/38 "2024-01-25T15:37:54Z")

</div>

Your error is that you are targeting the remove-copies column via the table. You need to target it directly - you should see it at the top of the list in the “From” selection.

---

<div class="post-metadata">

**Author:** ![ply](https://avatars.discourse-cdn.com/v4/letter/p/838e76/32.png) [@ply](https://community.glideapps.com/u/ply)\
**Post date:** [January 26, 2024, 9:17am UTC](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096/39 "2024-01-26T09:17:48Z")

</div>

it is working now when i target remove-copies. I don´t know why it didn´t work in the first place. I deleted and created colon again and then it worked with the settings above.

[Previous page](https://community.glideapps.com/t/adding-tags-to-photos-so-dynamically-searchable/21096.md?page=1)
