# Dynamic report/export (e.g. for pdf invoice) **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [February 24, 2021, 11:35am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614 "2021-02-24T11:35:30Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![rokapp](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@rokapp](https://forum.adalo.com/u/rokapp)\ **Post date:** [February 24, 2021, 11:35am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/1 "2021-02-24T11:35:31Z")
Hi, Is there a way to make a dynamic report (e.g. invoice) for example in a 3. party service? In Adalo I have a collection of Customers and another collection of Billing\_hours. These two collections have a relationship, in which one customer from Customer collection can have multiple billing hours from the Billing\_hours collection. For example Customer Alpa Ltd. has 13 billing hour records. I want to make a report (e.g. invoice) by clicking a button in the app, in which all the billing hours records of the selected customer are listed (and even in the selected time frame). To create the pdf, sheet, etc. I naturally must use a 3. party service. It seems that I can not use Zapier, since it works only with one data row at a time (not with the selected data set). Is there a solution for this? Or even better, a public demo. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [February 24, 2021, 7:35pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/2 "2021-02-24T19:35:30Z")
Hi @rokapp , As for me it’s possible to do this, though it is not trivial. I would use Countdown timer + Airtable + Integromat + Eledo for this. Did something similar already, worked for me. Best regards, Victor. ---
**Author:** ![rokapp](https://avatars.discourse-cdn.com/v4/letter/r/53a042/32.png) [@rokapp](https://forum.adalo.com/u/rokapp)\ **Post date:** [February 25, 2021, 7:34am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/3 "2021-02-25T07:34:59Z")
Hi @Victor , Sounds good! Could you explain more your solution or even share a demo? For example how/why you use the Countdown timer? I get the role of Eledo (to form the pdf) and Integromat (to transfer the data to Eledo). I tried to use earlier Zapier and PDFMonkey, but the problem was that Zapier delivers data per a new record to the collection, and thus a solution where multiple records from various collections are delivered didn’t work. ---
**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\ **Post date:** [March 1, 2021, 6:08pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/4 "2021-03-01T18:08:14Z")
Hello, Victor @Victor. 1. The order of steps should be exactly like this? > [@Victor](#): > > Countdown timer + Airtable + Integromat + Eledo 1. Can you recommend a tutorial? 2. There is no way to connect Adalo to Eledo directly, like using Custom Actions? **Thank you!** ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [March 9, 2021, 6:11pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/5 "2021-03-09T18:11:53Z")
Hi @ionutilie, Reg. (1) & (2) - I see it like this. The main problem is that Adalo doesn’t have a filter on API queries, which means that you need to filter out the unneeded records in Intergomat… which takes the credits, and there is also a limit on the number of records returned. This is not a problem when you have 10 records, but when you have 1000 - this will quickly become one. I haven’t made any tutorial for this, and to be honest, it took me quite a bit of time to find the working solution :)) As for (3) - sure, you can use Eledo directly. Their API is pretty simple, and have an option of providing you the link to PDF instead of giving the data directly. The question is what you are going to do with the resulting link to PDF file - I have no idea how long will they store it (and will they) :). Best regards, Victor. ---
**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\ **Post date:** [March 9, 2021, 8:22pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/6 "2021-03-09T20:22:33Z")
**Thank you** again @Victor ! I understand that Integromat may be complicated at this task but as it is possible to use directly Eledo, why not to keep it simple? Maybe is something that I don’t get it clear… I have tested Eledo using Zapier and after two weeks the files are still related to the URLs. The only limit is that Zapier needs 2 minutes to execute the task… I will give it a try using Custom Actions. Best Regards, Ionut ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [March 10, 2021, 5:55pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/7 "2021-03-10T17:55:16Z")
Hi @ionutilie, This is what they state on their website: ![Screenshot 2021-03-10 at 20.53.52](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7d0e23c4d1d512dfb26eadeb9a7a16a40690c78d.png) I don’t know how to interpret this in terms of storing PDF links… and didn’t find any clarifications on the site. Just informing you 🙂 Best regards, Victor. ---
**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\ **Post date:** [March 10, 2021, 7:50pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/8 "2021-03-10T19:50:32Z")
Thank you @Victor. You are right. I didn’t pay enough attention, and yes the URLs are in relation with Zapier, not directly on Eledo’s server… ![IMG_4658](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/5624e8c60ff6655a900302377f1f1a931ed0002b.jpeg) Regards! Ionut ---
**Author:** ![kfall](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@kfall](https://forum.adalo.com/u/kfall)\ **Post date:** [April 6, 2021, 7:12pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/9 "2021-04-06T19:12:53Z")
Hi Guys, Thank you for this information. My question to you all is, if I want to export a filtered list of records that have several fields in a records, how do I get this into Eledo? This is specifically what I am attempting to do…my webapp user is filtering a list of surveys by date interval, then they want to export this list by PDF or CSV. Please help and explain how to do so in Adalo with custom action or otherwise. Thank you very much, K ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [April 7, 2021, 9:46pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/10 "2021-04-07T21:46:48Z")
Hi @kfall, Quick research shows that it seems Eledo can accept a lists/arrays in the request. The problem is how to pass the unknown number of records (could be 1, could be 10) from Adalo to Eledo and fill in this list. I guess this could be done via Integromat and possibly Airtable, but this requires some time for the research… Best regards, Victor. ---
**Author:** ![anon78309838](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@anon78309838](https://forum.adalo.com/u/anon78309838)\ **Post date:** [April 8, 2021, 7:19am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/11 "2021-04-08T07:19:26Z")
I made a tutorial for this along with an Integromat template: [Create a PDF from a record in Adalo - Adalo Resources](https://help.adalo.com/integrations/integromat/create-a-pdf-from-a-record-in-adalo) ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [April 8, 2021, 9:46am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/12 "2021-04-08T09:46:59Z")
Hi @anon78309838, Great tutorial! Nice that Integromat can watch records, it solves a lot of issues reg. search. Though as I understood the question from @kfall - it is needed to create a PDF out of _several_ records in the list. Imagine a bill with several line items - could be 1, could be 5, could be 10… I wonder how “watch records” could be used here - interesting thing to think about. Best regards, Victor. ---
**Author:** ![kfall](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@kfall](https://forum.adalo.com/u/kfall)\ **Post date:** [April 8, 2021, 10:43am UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/13 "2021-04-08T10:43:34Z")
Thank you @Victor and @anon78309838 for the brain time! Just to be extra clear, what we are trying to achieve is the creation of a PDF from a filtered list. This list can have one record or many. In fact we are trying to create a way to have a button at top of the filtered list that would allow a user to download/export a PDF/CSV of the filtered list to send to a third party. Thanks again guys. Any thoughts really help. Keep up the great work! K ---
**Author:** ![Gabriel](https://avatars.discourse-cdn.com/v4/letter/g/9de0a6/32.png) [@Gabriel](https://forum.adalo.com/u/Gabriel)\ **Post date:** [April 11, 2021, 7:09pm UTC](https://forum.adalo.com/t/dynamic-report-export-e-g-for-pdf-invoice/9614/14 "2021-04-11T19:09:07Z")
Hi there Colin, I’m following the steps provided in the article for the PDF Form using the option dynimic export; however, as I’m new in the process, I’m haven’t been able to identify the App ID and and Data collection from api documentantion, at the end there is a message that says: [401] Access token / app mismatch. Could you please guide or let me know a turorial to identify better that information. thanks! Gabriel