I am wondering if there is a way to create a script that will import a CSV from the same folder where the FMP file is. The names and locations of the files don’t have a set path. We work primarily on MAC but do have some people on PC. Here is the typical file path — but it changes.
Ideally, it would be able to know to grab the CSV with the same name as the FMP, If underscores do not work well, at this point I can name it anything I want, but would ideally keep the set up as below.
Alternatively, I wouldn’t want to change protocol, but I could make the csv have a constant file name, but the script would still need to know to reference the folder of the current file.
Here is as far as I got... can I do calculations in the File Path List?
And the error I get: