# DocsAutomator integration issues **URL:** \ **Category:** Ask for Help\ **Created:** [July 21, 2025, 3:16pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338 "2025-07-21T15:16:12Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 21, 2025, 3:16pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/1 "2025-07-21T15:16:12Z")
Hello, I’m trying to generate some reports from the data I have on Glide. I’m experimenting with DocsAutomator, following this guide [https://www.youtube.com/watch?v=a9OObMX-jtY&ab\_channel=DocsAutomator](https://www.youtube.com/watch?v=a9OObMX-jtY&ab_channel=DocsAutomator) If I were to extend the same example for a second invoice, how would I do it using the same Invoices table? The document that gets generated will only pick the first row from the invoice table if I use the array for {{line\_items\_1}} ---
**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:** [July 22, 2025, 12:21am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/2 "2025-07-22T00:21:18Z")
Can you show us how you’re setting it up on the Glide side? It sounds like you’re not targeting the correct row in the second case, leading me to think the action/screen filter is not being set up correctly. ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 22, 2025, 5:51am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/3 "2025-07-22T05:51:19Z")
Hi @ThinhDinh, attaching a couple of screenshots. I know I’m missing something in either the data or the action setup. Tried a few things, but not able to get it working as expected. ![Screenshot 2025-07-22 at 11.19.17 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57454f3aac3daf81b7bc2553c940ab7dad799b16.jpeg) ![Screenshot 2025-07-22 at 11.19.42 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32fb07fdab6a4a8822df2fe469b87837b7c43e69.jpeg) ---
**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:** [July 22, 2025, 1:48pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/4 "2025-07-22T13:48:46Z")
I assume that Reports screen is on the top tab level right? There’s a big chance it only connects to the first row in the table you’re building the tab on. I assume you want to use the “Array” column to build an invoice for each row. In that case, you should show a list of rows from that table, then generate the report inside the details view of each row. It would help if you can clarify your use case a bit here. Is this a list of weeks? ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 23, 2025, 9:29am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/5 "2025-07-23T09:29:40Z")
I see. This is my use case. I have a table called Programmes. Each Programme has a list of athletes (relation from Athletes table). These athletes take part in competitions, so I have a Competition Log table. I want to generate a weekly report that has a summary of all competitions participated by athletes. So I have a bunch of columns that gets all of this info into the Programmes table. My idea was that there will be one report with data of all Programmes, so tried to have an array per programme and create line items from each of that item in the array. But yes, like you mentioned, only the first row is being picked. Are you suggesting that I have separate reports per programme? It’s not ideal, but in that case, I won’t need an array, right? Just the JSON column or the joined list column would do. Any way to have one report with all details? ![Screenshot 2025-07-23 at 2.51.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6883080a6a0572ae42daa0dadc81792cc95874e.jpeg) ---
**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:** [July 23, 2025, 11:23pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/6 "2025-07-23T23:23:07Z")
> [@Ramya\_Venkatesh](#): > > Any way to have one report with all details? I assume you just need to join all the rowJSONs together, and re-structure your DocsAutomator template to fit with it. However, if what you want is a section for each of these programs within a doc, I would suggest PDFMonkey. They do better with structures that are not rows in a table. ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 24, 2025, 5:48pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/7 "2025-07-24T17:48:36Z")
> [@ThinhDinh](#): > > I assume you just need to join all the rowJSONs together, and re-structure your DocsAutomator template to fit with it. That’s what I did initially and just the first row was being picked. I could try PDFMonkey. All of these tools (including DocsAutomator) are adding to the running cost of the application 😑 so I’m also trying to think of native ways of achieving the same. ---
**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:** [July 24, 2025, 11:47pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/8 "2025-07-24T23:47:15Z")
> [@Ramya\_Venkatesh](#): > > That’s what I did initially and just the first row was being picked. That should not happen. Can you show me your attempt of doing that, and the log of stuff that was sent through the DocsAutomator integration when you try to generate a doc? ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 25, 2025, 6:32am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/9 "2025-07-25T06:32:28Z")
Where can I find the logs? ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 25, 2025, 8:05am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/10 "2025-07-25T08:05:15Z")
I had to create the workflow. Earlier, it was directly configured under the button action. Attaching the logs snapshot. ![Screenshot 2025-07-25 at 1.34.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f75493bebd2168d625a1ba6a8f44f0fbca4394a2.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 25, 2025, 12:13pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/11 "2025-07-25T12:13:15Z")
I think the piece that you are missing is that you are not joining all of your JSON into a single row. Data from only one row can be sent, so you need to join all of it into a single JSON object in one row. ---
**Author:** ![Ramya\_Venkatesh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ramya_venkatesh/32/88271_2.png) [@Ramya\_Venkatesh](https://community.glideapps.com/u/Ramya_Venkatesh)\ **Post date:** [July 29, 2025, 5:43am UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/12 "2025-07-29T05:43:01Z")
Hi @Jeff_Hager, could you please guide on how I can achieve that? Make Array picks up items from the same row. Think I’ll have to aggregate JSON objects across multiple rows and I’m not seeing any option to do that. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 29, 2025, 4:00pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/13 "2025-07-29T16:00:49Z")
I think the best way to do it is to create a Lookup column that retrieves the Row JSON column from all rows in the table, and then add a JSON Object column to merge the Lookup array into a single JSON Object. ---
**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:** [July 29, 2025, 11:09pm UTC](https://community.glideapps.com/t/docsautomator-integration-issues/83338/14 "2025-07-29T23:09:03Z")
An alternative is using a Joined List column to join all relevant Row JSON values, then add a template column: ```auto [ J ] ``` With J being the Joined List value, to get the data into a JSON array format.