# Extract records that have all of these tags

**URL:** <https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932>\
**Category:** Ask for Help\
**Created:** [August 20, 2025, 12:31pm UTC](https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932 "2025-08-20T12:31:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NAOYA\_WASHIZAWA](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naoya_washizawa/32/91292_2.png) [@NAOYA\_WASHIZAWA](https://community.glideapps.com/u/NAOYA_WASHIZAWA)\
**Post date:** [August 20, 2025, 12:31pm UTC](https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932/1 "2025-08-20T12:31:58Z")

</div>

I am creating a patient education program.  
There are 20 tags in the tag master.  
Each patient has 0 to 20 tags, which are stored in an array.  
I specified multiple tags on the search screen and stored them in an array.  
I would like to extract patient records that have all of these tags.  
What steps should I take?  
Please let me know if you know of any good templates or videos.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [August 21, 2025, 12:14am UTC](https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932/2 "2025-08-21T00:14:24Z")

</div>

Can you show me what you have done so far, so I or another person can send you the specific solution for you ?

---

<div class="post-metadata">

**Author:** ![NAOYA\_WASHIZAWA](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naoya_washizawa/32/91292_2.png) [@NAOYA\_WASHIZAWA](https://community.glideapps.com/u/NAOYA_WASHIZAWA)\
**Post date:** [August 21, 2025, 5:45am UTC](https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932/3 "2025-08-21T05:45:34Z")

</div>

Thank you so much !

I’m performing an OR search using tags.  
If I select dog and bicycle, records that have those tags will be displayed.  
If I select bicycle and book, records that have those tags will be displayed.  
I would like to perform an AND search using the same mechanism.

 ![Screenshot 2025-08-21 12.34.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/771c6b8a42cdb038d734079946dc5ba8af7192a9.jpeg)

 ![Screenshot 2025-08-21 12.34.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a50205bebdcde5db1563d2ea7b903b84b96a4427.jpeg)

---

<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:** [August 22, 2025, 12:27am UTC](https://community.glideapps.com/t/extract-records-that-have-all-of-these-tags/83932/4 "2025-08-22T00:27:37Z")

</div>

I think you can try something like this:

- Cast the TagSearch column to the table you’re storing the patient records, using a Single Value column.
- Create an array from the single value “tag search” by splitting it using a Split Text column.
- Add a Make Array column, combine the patient’s array with the search array.
- Use a column to find duplicated items in the combined array.
- Use 2 columns to check the array length of the duplicated items and the tag search. If those lengths match, that record matches your search.