I may be going about this the wrong way, so I'm open to suggestions,
but here's the direction I'm going right now and where I'm stuck....
FMPro 9 on Mac
Troi File Plugin
I'm trying to dynamically set paths to particular server volumes and
local folders that are on the user's desktop. The server paths are no
problem since they are the same for every user, but the desktop paths
are a bigger pain since each user's desktop is a different path based
on the user name. The Troi File plugin lets you get around this with
the FindFolder function, which a switch can be set to -Desktop in
order to deal with each unique desktop. That all works fine.
NOW I want to build a calc field in the Sharepoint table that creates
the syntax for the Troi Plugin and use the Evaluate function to set
that information into a global variable. This would happen at startup
so all the variables are set just once, then called throughout the
solution. I know this is getting confusing, it's confusing to me, but
my goal is to be able to calculate the path to the desktop folder
rather than have to include the TrFile_FindFolder( "-Desktop") every
time I need to set a local file path. I've got it working in a
standard text field, but I'm having trouble using the Quote() function
in the calc to get the field formatted correctly for the Evaluate()
function to work.
Here's what works in the text field:
xtext = TrFile_FindFolder(" -Desktop") & desktopfolderfield & ":" &
subfolderfield & ":"
Script = set field (filepath) to Evaluate (xtext)
I can also make this setup work
calcfield ="TrFile_FindFolder("&Quote(" -Desktop")&")"
Script = Evaluate ( calcfield) & desktopfolderfield & ":" &
subfolderfield & ":"
What I need is:
calcfield = "TrFile_FindFolder("&Quote(" -Desktop")&")" and then
adding the syntax correctly for & desktopfolderfield & ":" &
subfolderfield & ":"
So this script works = Evaluate(calcfield)
I know I'm just missing the order, but I've worked on it too long.
Time to step back and get help.
Thanks,
Rick
___________________
Rick O’Quinn
Photographic Services Coordinator
University of Georgia
Public Affairs
Broadcast, Video & Photographic Services
188 Georgia Center
Athens GA 30602-3603
Work: (706) 542-8085
Fax: (706) 583-0011
[email protected]
http://www.photo.alumni.uga.edu
