Email Report

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

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.

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.

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:

1 Like

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.

2 Likes

@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.

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/

1 Like

Thanks. Based on your suggestion I will try to show through linked image.

1 Like