How do I open a file created in workflow?

[Jolanta_Wencel]

Hi, I’m creating an application to generate PDF files. I would like these files to be able to be opened directly in the application, e.g. in Case details or using an action. I followed the instructions I found on the AppSheet Community forum: Get URL of workflow generated file, but I am still unable to open the file (appears standard error: 404 - File or directory not found.).
I would like to make sure that I understand everything correctly: I want to create a file in the standard path (appsheet/data/[app-name]/Files), so in the file name (field: File Name Prefix) I don’t need to specify the file path. Therefore, in the File Name Prefix field I only enter the phrase: CONCATENATE (“Control_list -”, [Case ID], “. Pdf”). As far as I understand, I’m using exactly the same formula in the Set these columns field. I can find the file in the standard location, the filename is written in the file column, but I am unable to open the file. Please help: is there anything else I should pay attention to?

[Koichi_Tsuji]

One of the common mistake in terms of workflow set up to get the PDF through email and then generate the URL to access to the saved file is to forget to turn on “Disable Time Stamp”

[Jolanta_Wencel]

Hi! Thanks for quick response. I forgot to mension that I actually disabled the timestamp.

[Chris_Jeal · Accepted solution]

So, it’s a strange way round but here’s how I did it.

1. Create a file path within your column where the PDF file is going to save within your table,
   I used: concatenate("/appsheet/data/App_ID/Folder_Name/")

2. Point your workflow action ‘Save FIle’ folder path to “Folder_Name” (Disable Timestamp) and maybe use file name prefix identify your file,
   I used:
   CONCATENATE(
   DAY(TODAY()),
   IF(
   IN(
   DAY(TODAY()),
   LIST(11, 12, 13)
   ),
   “th”,
   SWITCH(
   RIGHT(DAY(TODAY()), 1),
   “1”, “st”,
   “2”, “nd”,
   “3”, “rd”,
   “th”
   )),"_",
   INDEX(
   LIST(
   “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”,
   “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”
   ),
   MONTH(TODAY())

),"_",year(today())
," @ ",[Report_Type]
)

which identifies my file within my table as “4th_May_2020 @ 0600”

3. Added a column within my table to display an action against,
   3a. Create an action to open the file: using ‘External: open a file’ and using your file(PDF) colmn as the file to open, and then displayed this inline of the column created as in point 3.

My action is shown below in the red box where once clicked opens the pdf in another browser tab.

Hope this makes sense.

Chris.

[Jolanta_Wencel]

It works! Thanks a lot!

[Chris_Jeal]

No problem.

[Ivan_Estrada]

podrias mostrarnos en la aplicacion por favor

[leentsuki_prog]

Hi! In which part do you asigned the name of the file to be open. In te workflow I assigned the id name as the name of the file, but in the file column i understand i should leave it blank? I have my files in the correct folders, but still show me a not found message