Filter data for Docs Automator

Ask for Help
1

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.

2

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

2 Likes
3

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
1574×504 68.4 KB

This is my Json
2
2313×792 25.8 KB

And it should look like this
3

Thank you

4

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

1 Like