LinkedIn
Twitter
@Aleski - I was indeed referring to column of type File. I read this:
"Constructing an Attachment File URL
"YourAttachmentFileName" must specify the Attachment Folder Name followed by the Archive File Name. Omit the Default app folder name. Calls to โwww.appsheet.com/template/getappfileurlโ automatically prepend the Default app folder name."
I took this to mean that I can use my column File type and AppSheet will add the necessary bits for the URL.
This also leads me to a questionโฆWhat is expected to be written in terms of path + filename+ extension to the column of File Type? When I write only the โfilename.pdfโ, and then try to view that file, I get an error that file cannot be found (see pic below).
Only when I update the File column text to โappsheet/data/ServiceInsightDemo-526414/Files/Estimate_p7fudBEC_2019820_10_43_33.pdfโ, is the file able to be viewed from the app. Bu this is WITH the default app folder which seems to contradict the paragraph above.
The other puzzling thing is that in the error it seems it is trying to use appName variable = โServiceInsightBase-526414โ to create the URL. I have the Default App Folder as โ/appsheet/data/ServiceInsightDemo-526414โ. The files are written to the Default App Folder as expected. But even copying files to a folder for appName (under appsheet/data), the file is not found.
@WillowMobileSystems
I had the same problem. Then I found the reason: My Table and my file folder were outside the App folder. That happens when you create a Sheet, then an App an then forget to copy the sheet into the App folder 
Hi Fabian
Iโm trying to troubleshoot why I canโt open the file I generate in the app and found your comment.
Is it really required to have the spreadsheet inside the app folder?
I couldnโt find this written anywhere in the Appsheet documentation 
Update: Unbelievableโฆ This has solved my problem. Thanks!!!
@Steve, can we get this documented somewhere? (unless I missed it)โฆ
Sure! As I mentioned above i create the filename in 2 parts.
- I save into a column the file prefix name. This allows me to use the same name for the multiple steps I have AND include a TimeStamp to ensure uniqueness:
The below expression creates a name like "Invoice_c98a86fb_20190914_11_38_01"
Note the use of SUBSTITUTE(). I found that the Workflow steps replace the โ:โ in the time with slashes. This is why you are seeing layers of folders most likely.
- When I add the file path+name to the table, I use the expression below to build this complete name:
In this expression, the text โappsheet/data/ServiceInsightDemo-526414/โ is based on your App Default Path. When writing the actual files, the app default path is used. However, when the files are retrieved, the default path is NOT used so you have to include in the built file path+name.
Digest this and let me know what further questions you have.
hi
- i have a name column with formula:
substitute(concatenate([ืคืงืข], โ-โ, day(today()), โ-โ, index(list(โ01โ, โ02โ, โ03โ, โ04โ, โ05โ, โ06โ, โ07โ, โ08โ, โ09โ, โ10โ, โ11โ, โ12โ), month(today())), โ-โ, year(today()), โ-โ, timenow()), โ:โ,"-")
to create a unique file name.
- i then have an action Data: add a new row to another table using values from this row (my main product table). with a formula for the file path:
concatenate(โappsheet/data/qctest-310438/reports/โ,[ืคืงืข],"/",pdfreports[name], โ.pdfโ)
- than i use a work flow that executes:
3.1 change data - executes the action in step 2.
3.2 saves a PDF file
3.3 then i send an email with attachment. - i have the pdfreports table referencing the main product table using the key: [ืคืงืข]
- i have a deck view in the ux for the pdfreports table
- when i try to open the file i get an error message
Hey Guys, I am trying to make my emailed attachment pdf to be aaccessible from the link in the app. I am trying to understand the basics of linking to one specific file on my google drive for now. I canโt get it to work. The file path in the google drive is mydrive/appsheet/data/attachments/SITECH_723242305_V15.pdf
I have a column that is a FILE type. My initial value is URL to the file which looks like this.
I get 404 file not found. What am I doing wrong?
Thanks,
Hi @SITECH_Mid-Canada I think you use a Workflow to send a PDF as an E-Mail and archive it to your Google Drive.
So your workflow setting includes โAttachAndArchiveโ.
In โAttachment Folder Pathโ you can set your own path. But: this will always be located in the folder where your google sheet is located.
Out of the box it will save your PDF files to:
"mydrive/appsheet/data/YourApp/attachments"
I would also recomend to disable Timestamp.
Everything you need to know is written in this help article:
You are exactly right. I generate a PDF from a template and it is stored in a default directory. What I am trying to do next is put a link to this PDF directly into my sheet. It is usefull if I want to say print the pdf from the app without having to look for it in the emails.
It seems that what @Fabian has suggested is the way to go IF your documents are stored in a Google Drive folder. it appears that is the only Folder source that is supported at the moment.
