# Include multiple line item tables in your PDFs using DocsAutomator

**URL:** <https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972>\
**Category:** Project Showcase\
**Tags:** actions, tutorial\
**Created:** [October 14, 2023, 9:52am UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972 "2023-10-14T09:52:36Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 14, 2023, 9:52am UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/1 "2023-10-14T09:52:36Z")

</div>

Hi everyone,

I’m excited to announce that including multiple line item tables is finally possible with Glide’s native [DocsAutomator](https://docsautomator.co/) integration! 🎉 🎊 💪

Please find a demo / walkthrough of how it works below.

Getting that syntax right can be a bit tricky, so please don’t hesitate at all to reach out anytime if something doesn’t work 🙂 🙋

Wish you all a great weekend & look forward to your feedback!  
Rupert

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1822feffea1aab767e91e195d506b13eca1661c.jpeg "How to Include Multiple Line Item Tables in Glide (native integration)") ](https://www.youtube.com/watch?v=TdVuZPjfZq0)

---

<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:** [October 14, 2023, 10:39am UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/2 "2023-10-14T10:39:05Z")

</div>

Great work!

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 14, 2023, 10:40am UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/3 "2023-10-14T10:40:45Z")

</div>

Thanks @ThinhDinh 🙏

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 14, 2023, 12:52pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/4 "2023-10-14T12:52:02Z")

</div>

Awesome! Thanks for the integration!

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 14, 2023, 1:43pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/5 "2023-10-14T13:43:11Z")

</div>

Thanks, @Robert_Petitto !

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [October 14, 2023, 1:51pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/6 "2023-10-14T13:51:27Z")

</div>

You should not use Joined List or Make JSON Object for this.

Use the `JSON Object` column to make objects, and use `Make Array` and `Lookup` to make arrays of objects.

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 14, 2023, 2:17pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/7 "2023-10-14T14:17:47Z")

</div>

Thanks, @david. Just tested using `JSON Object` and that’s great, thanks! (side note: why do `Make JSON Object` and `JSON Object` both exist?)

Re. using `Make Array`: That was my original approach, but I couldn’t get a nested array by using two `Make Array` columns. The array stays flat, no matter how many `Make Arrays` get chained. Nested arrays are necessary for multiple line item tables.

Did I miss something?

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [October 14, 2023, 6:17pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/8 "2023-10-14T18:17:58Z")

</div>

`Make JSON Object` will disappear next week – it’s being replaced.

Will look into Make Array issue.

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [October 15, 2023, 12:15am UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/9 "2023-10-15T00:15:06Z")

</div>

Excellent Update. Thanks.

---

<div class="post-metadata">

**Author:** ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)\
**Post date:** [October 16, 2023, 6:03pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/10 "2023-10-16T18:03:44Z")

</div>

In have a client with a Jobs table that has has connected timesheets and equipment logs. I created a search feature so he can find all jobs n a certain date range. I would like an automation to create a pdf from this data that has each job on a separate page with its timesheets and logs.

Is there a way to create a pdf with each job on a separate page?

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 16, 2023, 6:42pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/11 "2023-10-16T18:42:12Z")

</div>

Hi @GrumpyRick, I’m not 100% sure I understand the data structure, but currently DocsAutomator prints from a “main record” in a table. So in your case, that would be the jobs table and in that a single job. Based on that job, you can include connected data (like timesheets and equipment) from other tables. That would produce individual PDFs / Google Docs of each job. DocsAutomator is not able to print multiple records at once currently, so you would have to combine multiple PDFs after they’ve been printed.

Feel free to reach out in the DocsAutomator chat if you feel I haven’t understood your challenge correctly!

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [October 25, 2023, 5:51pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/12 "2023-10-25T17:51:34Z")

</div>

Hello.  
Two arrangements are used in the video. I only require one.  
That means that instead of putting [[array1],[array2]], I should put [[array1]].  
What other change should I make?  
For some reason the PDF is not being generated, I must have something wrong.  
On the other hand, does DocsAutomator have somewhere to see the json code?

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 25, 2023, 6:18pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/13 "2023-10-25T18:18:55Z")

</div>

Hey @Inspector1_ColmenasM, single line item tables have a different syntax. Please follow the instructions in this video: [https://youtu.be/ov-2xXliqxQ?si=qtElD08E6sGqGRTx](https://youtu.be/ov-2xXliqxQ?si=qtElD08E6sGqGRTx)

Please reach out anytime if you have questions 🙂 Best place to reach support is via the chat in the app!

---

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [October 25, 2023, 8:28pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/14 "2023-10-25T20:28:30Z")

</div>

that was excellent!!!  
Works great for me!!!  
thanks a lot

---

<div class="post-metadata">

**Author:** ![Rupert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rupert/32/44178_2.png) [@Rupert](https://community.glideapps.com/u/Rupert)\
**Post date:** [October 26, 2023, 12:25pm UTC](https://community.glideapps.com/t/include-multiple-line-item-tables-in-your-pdfs-using-docsautomator/66972/15 "2023-10-26T12:25:45Z")

</div>

Great 💪
