PDF File URL not updating

[eldderri]

Hi friends,

     I am creating a url file for each PDF file created ,but it seems the url is not updating whenever I create another data entry .Url file is used in my embedded app view to be sent later.The problem is that when I create other entries the url keeps the first file and does not change accordingly.

I am using the following expression to create this url:CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl?appName=",
ENCODEURL("CheckList-618890389"),
"&tableName=", ENCODEURL("CheckList"),
"&fileName=", ENCODEURL([File 2])
)

I think the problem is related with file cache.

Waiting for your reply

Best regards,

[jaichith · Accepted solution]

Check out this :

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Open-File-Image-with-external-browser-without-lo...

[eldderri]

Thank you.It solved the half of my problem as when I open the file url in my detail view ,the url is really updating when entering new enteries ,but when using the url in embedded app view in dynamic email.The url is not updating and gives me the old url.

Do you have any suggestions to solve this issue?

[jaichith]

Did you update the URL for the Dynamic Email? 

Do you create new versions of the file and retain old versions or overwrite with new one?

[eldderri]

How to create new versions of the file and retain old versions?

[peterson]

I usually do this way:
1. I have a file ID column
2. I concatenate the file name + File ID + ".pdf"
3. I use this File ID column to trigger my automation, everytime the ID is different then before, run the bot
4. I create an action that set a uniqueID to the column
5. I set this column as not show.

This way every file will have a unique name, and it will create a new file preserving the old ones.

[eldderri]

I did the same but now I am speaking about creating URL in embedded app view in dynamic email as shown in my previous message.I want to update the url whenever a new entry is added .I am using this action now instead of the system action:

My url is :

The idea is to have the same file detail view as in embedded app view used in dynamic email:

[eldderri]

Still not having the solution as when I create a checklist for the same driver again,the pdf file keeps the first file.Is it related to the naming of the file Name created?

Shall I replace the name of the file with a unique ID or what?

[eldderri]

I found the solution by replacing the file name  [Prénom])with [ID]) column so that I get a new url for my file every time the PDF file is created.

Thank you so much for you all