I am trying to get the folder path to work for my PDFโs.
I have made it work using the full path and filename in the spreadsheet.
I have made it work by having the filename in the spreadsheet and then the pdf sitting in the same folder level as the data spreadsheet location.
I canโt get it to work with the folder pathing in the file type field definition.
The path that works in the spreadsheet is:
01 Drawings/Permanent/Civil-Electrical - CIEL01/Single Lines/28010A1-DES-000CIEL01-DRG-0213.pdf
I have tried this in the field definition:
โ01 Drawings/Permanent/Civil-Electrical - CIEL01/Single Lines/โ&[Single Line drawing Number]&".pdf"
[Single line drawing number] is the field that contains the drawing number.
It does work with the full path but it is very messy on a form and doesnโt allow changing the drawing number easily.
URL to the files are made within Virtual column to dynamically set the url?
Why dont you encode the part of relative url, and see what happens.
โ01 Drawings/Permanent/Civil-Electrical - CIEL01/Single Lines/โ&encodeurl([Single Line drawing Number])&".pdf"
Or alternatively why don t you use the full path, but change the text appearing to user by using hyperlink() expression?
I havenโt used a virtual column I have used a file field type.
I have set the folder path to the file to this:
โ01 Drawings/Permanent/Civil-Electrical - CIEL01/Single Lines/โ
The field value is DrawingName.pdf
The data spreadsheet for the app is located in:
\CR2SM Electrical\
The folder with the file is located in:
\CR2SM Electrical\01 Drawings\Permanent\Civil-Electrical - CIEL01\Single Lines\
Are you dynamically changing the folder path based on Drawing number?
The folder path stays the same, itโs just the drawing number that changes row to row.
It looks like the issue might be in the system generated action as it only points to the field value and doesnโt add the folder path to the action.
Yep I created my own action, put the whole path in the File section of the action. Set the system action to do not display and set the action to display inline.
This does work fine for me but it would better if it worked from the file field type folder path in the column settings.
I suspect still your file path is doing something wrong to display the file on browser by linked URL.
I usually save the file into default folder, i.e. โAttachments/โ then I generate the full path to access to it with virtual column which is easy set and especially more stable.
But I sometime faces the issue, the url not returning the actual file I wish to access. The majority and sole reason for the problem was the ULR has 1) Space, 2) special characters.
So to eliminate the issue, i use encodeurl() expression when I use the expression to construct the dynamic url out of relative file path.
Your file path is eventually used within the full path to access to the file?
Currently you define path like this
โ01 Drawings/Permanent/Civil-Electrical - CIEL01/Single Lines/โ
It contains 1) Space 2) special character like - .
This need to be encoded, so that the url is returned correctly.
I have got this working well enough but now when the PDF opens on an iPhone I have no back button to return to the record.
the only way out is to crash the app and re-open.
I am using an iPhone 11 Pro max with IOS 13.
I have found that if i swing the phone to landscape and then back I can see the back button.
User | Count |
---|---|
43 | |
30 | |
25 | |
23 | |
13 |