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?
@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). 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
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!
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?