Hi,

I'm looking for a way to create a button that will open a folder from FileMaker. I have 2 field that supplies our naming convention when we create the folder in the server (all folder are created in a central place).

How would I take the 2 field and put it into a path that will open the folder in the finder (I'm on a mac, put I would like a cross platform solution).

Thank you

Probably will need some sort of OS-level scripting to do this, so it won't be cross-platform. AppleScript on macintosh is easy, you'll need WinBatch or some other commercial, third-party solution on Windows.

I can't speak to the Mac question, but its really easy on a Windows machine. First use a calc field that builds the path name to the folder you want. Make sure that the final result is enclosed in quotes. Then use a SendMessage command set to field value and point it to your calc field.

For example:

Assume drive c:

Var1 = folder name

Var2 = subfolder name

Var3=calc: """C:" & Var1 & "" & Var2 & "" & """"

The result is "C:folder namesubfolder name"

Then script Send Message [open doc, fieldname = Var3]

Run this and the folder opens!

Cheers,

Dan