Is it possible to create a link (URL) to a PDF created by Appsheet

AppSheet AppSheet Q&A
1

I have a report that creates a PDF for each job finished during the day, attaches it to an email and saves/archives a copy of the PDF in a Google Drive folder. As a result, I end up with multiple emails, each with an attachment. To make it more efficient, I’d prefer it if the job created and saved the PDF’s but sent just one email listing all the jobs with a link (URL) to the PDF. Is this possible, and if so, where do I need to save the PDF’s so any recipient of the email (with shared access to the Google Folder) can click on the link in the email and have it open the PDF?

2

This Q&A might give you some ideas..

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/What-is-the-best-way-to-retrieve-and-view-files-in-app-that-are/m-p/367400

(Sorry I have not read it and understood it in full detail but seemed promising.)

4 Likes
3

Thanks TeeSee1. I haven’t had a chance to study it in detail but I am hoping it will lead to a conclusion. I will keep this thread open till I get a chance.

1 Like
4

Thanks for the links. They led me to the solution I needed - I didn’t realise it was so easy! Thanks!!!

1 Like
5

You can try it

CONCATENATE(“/appsheet/Data/”,CONTEXT(appname),“/Files/”,CONCATENATE([product_id],“-”,TEXT(NOW(),“yymmddhhmm”)),“.pdf”)

1 Like
6

Thanks JOHNN. I didn’t need to go that far in my case. I found that I could use the system variables to do what I needed



Expression variable

Description


_ATTACHMENTFILENAME

Archive attachment filename.


_ATTACHMENTFILE_URL

Archive attachment file URL.


_ATTACHMENTFILE_WEB_LINK

Link to the archive attachment file. The Attachment Name is used as the link text.
1 Like