I’ve set a workflow to attachandarchive, having set the Attachment Folder Path to both blank (left it as default) and as a test to ‘mmattachments’, either way this is setup I can’t find the attachments. My app is in a dropbox account, should I be looking for the attachments somewhere else?
If your Dropbox is your main provider with your Appsheet account, the files should be under Root > Appsheet > Data > Appname-123456 > mmattachments
2 Likes
Hi Aleksi, my App is in Dropbox, however I’ve discovered the attachments are being saved to my Google Drive which I don’t really want. Can I specify the dropbox default path within the ‘Attachment Folder Path’ instead? And what would be the syntax to allow this to happen?
Regards
This means that your main data source with your Appsheet account is Google, not DropBox and I’m afraid you can’t save files then to DropBox.
2 Likes
How strange. I have always saved the App csv files to Dropbox and edited table structure from there… You learn something everyday.
Kind Regards
CONCATENATE(“mmattachments/Customer Quote- “,[Customer],”- “,[JobID],”.pdf”)
Now that I have my file location(Google), the above is set in an action to update a row in the reports.csv table.
I have a REF row set to ‘File’ but when I try to access the file from the UX I get a 404 page.
How do I get the file to open?
Cheers
Please take care that you don’t have spaces with your file name.
1 Like
Hi Aleksi, I have edited the filename:
CONCATENATE(“appsheet/data/QuotesMM-658599/mmattachments/”,[JobID],“.pdf”)
And as you can see below the table shows the location of the file.
I can see the file and can open it from my Google Drive:
But when I try to open it in the APP:
I get:
The desktop browser (Chrome) shows this:
As the url.
Any idea why I can’t open the produced file either on desktop or the App ??
How have you generated the URL for your PDF?
Part way there.
So turning off ‘Require Image and File URL Signing’ off allows the following to load from the app:
I guess I have to just find a way to build the URL ??
No, this is the path you need to follow if the request is the same.
CONCATENATE(“https://www.appsheet.com/template/getappfileurl?appName=QuotesMM-658277&fileName=mmattachments%2F",[JobID],".pdf”)
This adds a record in the add row to another table and is selectable from the Ref View on the main table. It seems to be working so far.
Cheers
Yes