Rolling through FileMaker...
Rolling through FileMaker...
- Subject: Rolling through FileMaker...
- From: James Steincamp <email@hidden>
- Date: Sun, 21 Jan 2001 12:29:21 -0500
With help from the list, I was able to write the following script a few
months back:
tell application "FileMaker Pro"
set serial_num to cell "Project Number" of current record
set the_comm to cell "Description" of current record
end tell
tell application "Finder"
if (folder serial_num of desktop exists) is not true then
set the new_folder to make new folder at desktop ,
with properties ,
{name:serial_num, label index:6, comment:the_comm}
set view of container window of new_folder to name
set shows comments of new_folder to true
open the new_folder
make new folder in new_folder with properties ,
{name:"Product", label index:6}
make new folder in new_folder with properties ,
{name:"Packaging", label index:6}
make new folder in new_folder with properties ,
{name:"Illustrations", label index:6}
make new folder in new_folder with properties ,
{name:"~Resources", label index:5}
set zoomed of container window of new_folder to true
else
display dialog "A folder with this name already exists." buttons
{"OK"} default button 1 with icon note
end if
end tell
It works perfectly, except that I would like to:
1. Have it roll through our FileMaker database and create a folder for each
project (we have over 2500). I've tried to write this myself... but failed.
:(
2. The cell 'Description' actually resides in another linked database (FM 3
Pro)... unfortunately, I did not create the database (and it's extremely
hackneyed), so i'm a bit nervous to dig around in it... but when I view as
layout it shows up as '::Description.' How do I go about sucking this info
out of FM via AppleScript?
thanks much in advance...
-james