I need help to view the pdf.

AppSheet AppSheet Q&A
1

Hello everyone,

I need help to view the pdf.
I have created a bot to generate the pdf when a record is added or updated.
The file path is by default /appsheet/data/Projects.
File name prefix: CONCATENATE( [Code], “.pdf” )
Disable timestamp? activated
Path in the pdf column: CONCATENATE(“Files/”,[Code], “.pdf” )
The pdf is generated correctly in drive in additions and in updates
The system generated action to view the pdf correctly returns the file the first time it is generated, but when the record is updated it still shows the file without updating.

Any help is appreciated
Thank you so much

​

2

Apparently right now, you have to make a unique file name, otherwise it grabs the cached file. There are workarounds but didn’t seem worth the effort ime.

Do do so, if checked, uncheck this and fix up the path.

generativegeorg_1-1683815930453.png

Some related posts

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/File-column-showing-cached-PDF-not-linking-to-actual-file/m-p/376239

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Image-does-not-change-in-pdf-when-change-in-server/m-p/254722#M35289

https://www.googlecloudcommunity.com/gc/Announcements/Call-to-Action-for-Apps-Constructing-URLs-to-GetTableFileUrl/m-p/359650

3

Oh if you hit secure PDF access it might help. Allowing you to retain the non-unique path.

generativegeorg_2-1683816379992.png
generativegeorg_2-1683816379992.png271×137 7.41 KB

I’m trying this now… will report back tomorrow.

4

From what I can tell, that actually worked.

5

Thanks generativegeorg I’ll try

​