# Email Report
**URL:** https://community.glideapps.com/t/email-report/1452
**Category:** Ask for Help
**Created:** [October 28, 2019, 8:58pm UTC](https://community.glideapps.com/t/email-report/1452 "2019-10-28T20:58:21Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)
#### Post date: [October 28, 2019, 8:58pm UTC](https://community.glideapps.com/t/email-report/1452/1 "2019-10-28T20:58:21Z")
If I set up my app to generate a report how can I get it to send said report it the layout it’s set up in the app as an email or a Pdf document
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 28, 2019, 10:53pm UTC](https://community.glideapps.com/t/email-report/1452/2 "2019-10-28T22:53:22Z")
I’m not understanding your question completely but as far as I know you would have to use a script to create a report. As for sending the report, again you would have to write a script if you wanted to send it via email.
---
### Author:  [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)
#### Post date: [October 28, 2019, 11:35pm UTC](https://community.glideapps.com/t/email-report/1452/3 "2019-10-28T23:35:36Z")
So the idea is when I pull information using a submission form it create a report inside my app.
I’d like to have a button that if you click it, it emails that pulled information almost like a screenshot.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 29, 2019, 12:24am UTC](https://community.glideapps.com/t/email-report/1452/4 "2019-10-29T00:24:05Z")
I would love an option like this too. I create dynamic billing invoices in my sheet and display them in the app using html tables (I have a column with dynamic markdown tables as well if the html stops working, but for now, the html version looks better). It would be great if I could download a PDF or send as an email, but it’s not an option within Glide. In the future, I plan to explore third party tools that can do this for me, such as Zapier or Integromat. I haven’t had an immediate need to dig into it further, but it looks promising according to @mmgt2005 and the following post:
> [@Print values from your app](https://community.glideapps.com/t/print-values-from-your-app/1300):
>
> Is there any component to send a text cell to the printer?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 29, 2019, 1:45am UTC](https://community.glideapps.com/t/email-report/1452/5 "2019-10-29T01:45:20Z")
Here is a link to a tutorial that will create the PDF’s as well as email them. It is converting the entire spreadsheet and then zipping it, but you should be able to adapt it to only one sheet and just mail the PDF instead of zipping it up.
> **[Convert and Email Google Spreadsheets as PDF Files](https://ctrlq.org/code/19869-email-google-spreadsheets-pdf)**
>
> You can set up a cron job in Google Drive using Google Apps Script that will send any Google Spreadsheet, or any other document or file in the Drive, to one or more email addresses at a specified t…
---
### Author:  [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)
#### Post date: [May 14, 2020, 2:50am UTC](https://community.glideapps.com/t/email-report/1452/6 "2020-05-14T02:50:40Z")
@Jeff_Hager Could you please guide how to show report using html table on the screen. My use case is my staff Attendance sheet report is generated send to Admin email via script, it is working fine but it would be more convenient if I can display the excel or PDF version or any mode on the screen in parallel.
Glide does not have any option display msg box to show that report is generated. If I write the msg in a cell and show it after report is generated, same msg will show whenever people people go to that screen which is not desired. Showing the report on screen may help in that case.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 15, 2020, 4:22am UTC](https://community.glideapps.com/t/email-report/1452/7 "2020-05-15T04:22:41Z")
I create a table using html tags. You can use markdown tables too, but I needed the flexibility of html. It’s realtime data and highly specific to my use case. There are a lot of formulas and queries being used to generate my invoice, so it’s hard to provide a guide that works for anybody. You could probably use a template column to join a bunch of data together along with the html or markdown. Not knowing your specific situation, why can’t you just show a link to the sheet or PDF? An image component should be able to render a preview of a PDF, and you can create an open link action to open and view the PDF.
If you want to see an old test version of my app, here’s a link. [https://vkjff.glideapp.io/](https://vkjff.glideapp.io/)
---
### Author:  [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)
#### Post date: [May 16, 2020, 3:55am UTC](https://community.glideapps.com/t/email-report/1452/8 "2020-05-16T03:55:35Z")
Thanks. Based on your suggestion I will try to show through linked image.