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.