AnsweredAssumed Answered

Script - Specify Output File Path questions

Question asked by lindseym on Nov 8, 2016
Latest reply on Nov 8, 2016 by thurmes

I edited this because I realized that I had an extra / in my file path.




I get my script to run just fine and have the exported Excel file go into the same folder as the FMP File, but what I want it to do is go to a relative path above the containing folder. I can't use a fixed file path because each client has their own FMP database, which is filed about 50 different ways.


currently I have: File:/Site Survey/Lables.xlsx


Screen Shot 2016-11-08 at 3.58.35 PM.png


First, I have been getting this error. I tried changing the name and deleting the existing file, but that doesn't help.


Screen Shot 2016-11-08 at 3.57.22 PM.png


Ideally I would like the script to work up the folders----> meaning it would save in "Site Survey"in a perfect world, it would go backwards until it found "Survey"and thenin a subfolder called "Beginner".




Screen Shot 2016-11-08 at 4.21.08 PM.pngScreen Shot 2016-11-08 at 4.22.58 PM.png



I know just enough about file paths to get into trouble.

Any pointers?