# Creating a PDF from different tables? **URL:** \ **Category:** Ask for Help\ **Created:** [December 4, 2025, 4:05pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630 "2025-12-04T16:05:49Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 4, 2025, 4:05pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/1 "2025-12-04T16:05:49Z")
Hi there, I have added DocsAutomator to my app as I am looking to be able to create pdf reports. While testing I discovered i could only do I table at a time. I was looking to make a wrap of data from 3 different tables a user has access to. Has anyone ever done this if it is feasible? Any turnaround tips otherwise, not to technical if possible? Thanks Stan ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [December 4, 2025, 4:12pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/2 "2025-12-04T16:12:56Z")
@Rupert for visibility ---
**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:** [December 4, 2025, 9:16pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/3 "2025-12-04T21:16:03Z")
@HouseSnap I assume it’s multiple rows of data from different tables, so you would use DocsAutomator’s “line items” feature ([see here in DocsAutomator’s documentation](https://docs.docsautomator.co/integrations-api/glide)). You could merge data from multiple tables by adding all joined lists in the final array which is passed to DocsAutomator. Please check out the videos and instructions in the knowledge doc for examples. If you get stuck somewhere, please reply here or feel free to reach out DocsAutomator’s support chat 🙂 Thanks for tagging @nathanaelb !! ---
**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:** [December 4, 2025, 11:42pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/4 "2025-12-04T23:42:03Z")
Hey, just wanna say thank you for all the great work you have done with DocsAutomator. Recently I have enjoyed creating JSON objects, even nested JSON objects with your latest update: [Nested Line Items | DocsAutomator](https://docs.docsautomator.co/features/line-items/nested-line-items) Then I use a manual workflow to take that JSON object in, and then an API call (not the DocsAutomator integration) to generate a document. It saves me some time having to re-create variables in the integration since I do use that JSON object for other purposes. ![CleanShot 2025-12-05 at 06.41.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0ee3117e5b5fd7ef8cf2f794a7f20bce3883985.png) ---
**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:** [December 5, 2025, 10:53am UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/5 "2025-12-05T10:53:08Z")
Amazing, @ThinhDinh ! Did you grab the structure for nested from [DocsAutomator’s API documentation](https://docs.docsautomator.co/integrations-api/docsautomator-api)? Hopefully the native integration allows for passing of JSON objects at some point so that no workarounds are needed anymore for line items… 🙂 I will continue to speak to Andy & the team to hopefully have a DocsAutomator x Glide integration 2.0 at some point! ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 5, 2025, 9:37pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/6 "2025-12-05T21:37:10Z")
Hi rupert and thanks. I didn’t had the chance to work on it today, but will be looking at it latest tomorrow and will let you know ---
**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:** [December 5, 2025, 10:11pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/7 "2025-12-05T22:11:48Z")
Yes that’s the method I’m using. Just need to construct an object with the document’s ID, name and pre-constructed data. It works very reliably! ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 5, 2025, 10:34pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/8 "2025-12-05T22:34:48Z")
So I have been testing your solution and thanks it a new discovery for me quite great 🎉. However, because of my configuration I believe I don’t get any data. Being limited for now i will not test 10 times 😉 In My configuration every user has access to specific data from other tables, which means that their userid or row ownerid is specific in any other tables in which they created data (line items). therefore should i use, rather than **{{line\_items\_1}}** something like this **{{line\_items\_rowid (or something similar that id the user) }}**? or another way? Thanks P.S : I believe we can use array feature (in glide) rather that creating a template “arr”, no? ---
**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:** [December 6, 2025, 3:20am UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/9 "2025-12-06T03:20:11Z")
> [@HouseSnap](#): > > However, because of my configuration I believe I don’t get any data. Can you show us your configs? > [@HouseSnap](#): > > Being limited for now i will not test 10 times What’s your limitation? The free plan in Glide or in DocsAutomator? You can set your document in DocsAutomator to a testing mode. ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 6, 2025, 10:04am UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/10 "2025-12-06T10:04:40Z")
> [@ThinhDinh](#): > > ent in DocsAutomator to a testing mod I am still on free plan for docautho, so only 20 credits 😉 My config is : user table house table room table each rooms are related to a house which is related to a user. logged in user can only access data from specific line items in house & room table wich are in relation with the user. I will rewiew my docautho because i might have missed something and try again. if it doesn’t work can share a loom. Thanks @ThinhDinh ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 6, 2025, 12:33pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/11 "2025-12-06T12:33:31Z")
Hello there, so I have reviewed my docauth config and my glide columns and i discoverd I missed to properly set the joinlist column. One data still doesn’t show but it shouldn’t be a bother to find the reason. I am adding a question on which I am not sur for @Rupert : can we add photo in a line item column? ---
**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:** [December 6, 2025, 2:45pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/12 "2025-12-06T14:45:01Z")
> **[Dynamic Images | DocsAutomator](https://docs.docsautomator.co/features/dynamic-images)** > > DocsAutomator allows for images to be added anywhere in documents I believe you can. Just use {{line\_items\_1}}{{image\_something}} ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 6, 2025, 3:27pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/13 "2025-12-06T15:27:50Z")
thanks i did include an {{image\_photo}} but it wouldn’t retrive the files or files. But it’s working with a public url, which i believe maybe the limitation, but not sure as I was able to retrieve other images on my doc outside the line\_item. or it’s the size. I have added the url of the image in glide to my json. so no need to add the {{line\_item\_1}} to my image column. I got 99% of the work done so thank you very much for your help. Just need the image line\_item, will have a look and let you know ---
**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:** [December 6, 2025, 11:37pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/14 "2025-12-06T23:37:49Z")
> [@HouseSnap](#): > > thanks i did include an {{image\_photo}} but it wouldn’t retrive the files or files. But it’s working with a public url, which i believe maybe the limitation, but not sure as I was able to retrieve other images on my doc outside the line\_item. or it’s the size. It has to be a public URL. Are the non-working URLs public or not? Are you using a Glide storage image or something else? Can you show us your setup? ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 7, 2025, 6:45am UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/15 "2025-12-07T06:45:04Z")
Set up in docauth or in glide? here are some print screen of my json in one table, array in anther table and docauth. image urls are there, and yes they are hosted through glide. don’t worry if some names don’t match i have made changes. my main issue is the image that doesn’t shows up. I am still looking into it. ![Screenshot 2025-12-07 07.08.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4db21c65b8ba52dc8fbda250a300ced91ba0a5d5.png) ![Screenshot 2025-12-07 06.57.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5ca84bf15ea477a6a98f3141765ca5099b508ec7.png) ![Screenshot 2025-12-07 06.56.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4f065dc361c4a79988b43b49edbaf7325af749e.png) ![Screenshot 2025-12-07 06.56.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d755b097d1acb5594b9cb1cbb731d992facc46c.png) ---
**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:** [December 7, 2025, 11:54am UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/16 "2025-12-07T11:54:24Z")
From your screenshots, my only concern is the names not matching. The only other stuff is that you are using “image” twice in your variable. I would check for full variable matching again, and if it doesn’t work, please show us your latest configs on both sides. ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 7, 2025, 4:53pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/17 "2025-12-07T16:53:25Z")
Ok so i cleaned the name matching and all text works fine (there was issues with capital letter and other little stuff i don’t have yet full automatism on Json writing 😉 ) However new issue is that no image are being shown. Maybe I will see this directly with @Rupert this week and will post the results. Thanks again for your help 🙏 ---
**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:** [December 7, 2025, 11:34pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/18 "2025-12-07T23:34:05Z")
In your DocsAutomator configuration, does that image variable show up with configs for an image (width, height etc)? ---
**Author:** ![HouseSnap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/housesnap/32/92689_2.png) [@HouseSnap](https://community.glideapps.com/u/HouseSnap)\ **Post date:** [December 11, 2025, 3:07pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/19 "2025-12-11T15:07:39Z")
Ok so I had a chat with @Rupert and while I finally found out I have mistaken in some naming relationship he gave me good tips on other things like do not finish a image name by “\_number”. Solution found thank all for your help ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 18, 2025, 3:08pm UTC](https://community.glideapps.com/t/creating-a-pdf-from-different-tables/85630/20 "2025-12-18T15:08:30Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.