PDF Display Issue When Updating Quotations in the Application

[Yedjeos]

I am creating an application to generate quotations. First, I create the client's data, then I add the products they are going to buy. I automatically change the status to 'generated', and the bot generates the PDF of that quotation. When I click on the PDF icon, it opens normally. However, when I want to make any changes to the quotation, I change the status to 'in process', to make any kind of modification, such as adding more products or changing the quantity of the same. As soon as I save and change the status to 'generated', the bot creates the PDF with the updates made. But when I click on the button to open the PDF, it shows the first PDF and the updates made are not displayed.

I have this function that I have in the PDF field in the formula:
"/appsheet/data/Quotation_System/Files/",
[clientName],
" ",
[invoiceNumber],
".pdf"
)```

And in the bot, I have this formula for the name:

```concatenate(
[clientName],
" ",
[invoiceNumber],
".pdf"
)```

[AleksiAlkio · Accepted solution]

It's reading the PDF from the cache because your process doesn't save the file with a new file name. How to avoid this, try this method..

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Open-a-file-action-get-current-not-cached-file/m...