# Filter data for Docs Automator

**URL:** <https://community.glideapps.com/t/filter-data-for-docs-automator/75619>\
**Category:** Ask for Help\
**Created:** [August 13, 2024, 9:56am UTC](https://community.glideapps.com/t/filter-data-for-docs-automator/75619 "2024-08-13T09:56:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [August 13, 2024, 9:56am UTC](https://community.glideapps.com/t/filter-data-for-docs-automator/75619/1 "2024-08-13T09:56:01Z")

</div>

I have a list of inventory items, and the “Site” column indicates the warehouse location.  
I have a button ‘‘Generate PDF’’ that will be visible for multiple warehouse managers. The users table has a column with warehouse location for every user.  
How can I filter the items based on the warehouse location in glide?  
I filter the items on the screen based on the user warehouse location but when I generate the PDF it still adds all the items from the database. How can I filter without creating new columns to filter data for each warehouse?

Kind regards.

---

<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:** [August 13, 2024, 10:12am UTC](https://community.glideapps.com/t/filter-data-for-docs-automator/75619/2 "2024-08-13T10:12:44Z")

</div>

Use a Query or Multiple Relation as the source of your Generate PDF action.

---

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [August 13, 2024, 11:06am UTC](https://community.glideapps.com/t/filter-data-for-docs-automator/75619/3 "2024-08-13T11:06:03Z")

</div>

Thank you, I filtered the items with a query and lookup for name, Id and so on but I’m not able to create the Json Object for Docs Automator the way it should be. Pictures attached. I’m sure is something easy but can’t wrap my head around it

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04839282cf57a3ab1814a23d66632201da9d1ad2.png)  
This is my Json  
 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c4163c5a52ca740076d1df177fcdb891edcc8e7.png)  
And it should look like this  
 ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a929194fd9639f1ffbdf7c03709c3b9187b42f3.png)

Thank you

---

<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:** [August 13, 2024, 11:11am UTC](https://community.glideapps.com/t/filter-data-for-docs-automator/75619/4 "2024-08-13T11:11:19Z")

</div>

Try using a Lookup column through the Query instead of a Joined List.