Applescripting finder in Filemaker
I am using Filemaker 11 on a Mac network and have a DB to keep track of jobs that come through. As a new job is entered we create a new record and type in all of the information. I have set up a portal to show related quote information from my Quote DB so that I can copy/paste or click and drag information. Where I can info is automatically filled in from the quote via lookups. Everything is working fine there.
What I am trying to figure out how to do is set up filemaker to take the value from my Job# field, bring up a Finder window to my "Jobs" folder on the server, then create a new folder using the Job# as the folder's name.
I am not very well versed in applescript, but it seems like this would be a doable task. It would be convienient to have the job folder created at the same time we log the job in.