This isn't exactly a 'custom function' but perhaps someone who deals with functions can help.

I have a script that first determines if the user is running in OSX or Windows.

Then it creates a path to a file. (Using in part 360Works Select File() function)

Here is the script:

The OSX part (top) works. The Windows portion (bottom) produces this 'mess':

I thought the problem might be in the get(systemDrive) function so I replaced it with C: . But, it still didn't work.

What am I missing? (Yes, I tried putting filewin: in front without a good result.)

Thanks

Ron

It looks like the 360Works SelectFile() function is returning the network path of the file. With a bit of manipulation, you can use this value in FileMaker:

Set Variable [$$SelectImportFile; Value:SelectFile]

Show Custom Dialog ["Windows"; "filewin:" & Substitute($$SelectImportFile; "\\"; "/")]

This should yield the following result:

filewin://psf/Home/Documents/FileMaker docs/_Projects/Lodge Membership/LodgeMembership888.fp7

This value can then be used in various script steps like "Import Records []" and "Export Records []".

Great solution. Thanks.