I have an inventory app. i need to generate a report of all the inventory that was moved out today

[Gokulakrishnan_]

How do i add all of today’s entries made to a delivery child table to a pdf report. I have a pdf file row for the child table that works only for individual deliveries.

[graham_howe]

Have you considered creating a Slice? This is effectively a view of a table with a filter applied. You can then treat the slice as you would a table in the rest of the application.

[WillowMobileSys]

Graham_Howe:

Have you considered creating a Slice?

Yes, a Slice is one way to do it and I would strongly recommend using a Slice IF you are also planning to use this same set of data in the UI of the app as well.

If you ONLY need this data in the PDF, then I would recommend referencing the data only there. No sense in adding additional processing overhead to the app if its not needed.

To do this in the PDF, you would be using Automation and in this case a Scheduled Bot with the “For EachRow” setting turned OFF.

In your template you would use a START block at the very top to choose the list of rows to be used in the generated report. Something like this:

<<START: FILTER(Child Table,  [Date] = TODAY()>>

---report body---

<<END>>

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.

[Gokulakrishnan_]

How do i open the file through the app on demand??

[WillowMobileSys]

It would be better to create view to show the data. Is there a reason you need to save the file and view it later?

Assuming you do have a reason, it is possible to automatically add the file into AppSheet and view it when requested. This does take some effort.

You might review this post first. I tried to spell out the steps to get files added into the app. Come back here of you still have questions.

What is the best way to retrieve and view files in app that are generated from templates? Questions

I use workflows to generate and send customer pdfs from templates in Google. Currently, I use the archive option to save the generated result in the default location in Google with the current timestamp to ensure file name uniqueness. When certain record info changes, a new file is generated with the updated details and saved as a new file. I would like to be able to retrieve the history of all saved files associated with a certain record and display them in the app - as a list or gallery. W…

[Gokulakrishnan_]

When crossing state lines the truck driver needs to have a physical copy of the list of goods.