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
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}}
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.
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.
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?
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?
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.
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.
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?
Where can I find the logs?
I had to create the workflow. Earlier, it was directly configured under the button action. Attaching the logs snapshot.
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.
