Solved: How do I open a file created in workflow? - Page 2

Jolanta_Wencel · 09-09-2020 04:26 AM

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?

Chris_Jeal

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

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/")
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”

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.

View solution in original post