FMP5 & Current Record
FMP5 & Current Record
- Subject: FMP5 & Current Record
- From: James Steincamp <email@hidden>
- Date: Fri, 03 Nov 2000 01:47:45 -0500
We are developing a FileMaker Pro 5 database to track all of our design
projects. Each project has a unique serial number and a description of the
project. I would like to be able to use this information to automatically
create project folders on our ASIP 6.3x server to help our designers
organize their files in a consistent manner.
Basically, I'd like to be able to use the serial number as the folder name
and copy the project description (a hierarchical keyword list) into the
folder's comments field (so that they can be searched and provide feedback
in English as opposed to merely a project number).
Since I'm very new to AppleScript I'm fumbling around a bit. After some
trial and error, I produced this script:
tell application "FileMaker Pro"
activate
get data of current record of field "Project Number"
end tell
But, this provides me (the result) with every Project Number (even those
that aren't the current record). After some more thrashing about I managed
to generate this:
tell application "FileMaker Pro"
activate
copy cell 3 of current record to aVariable
end tell
I'm not entirely sure why this worked (the result was the correct number),
but more frustrating was that I couldn't just say "copy cell 3 of current
record to the clipboard" as my efforts are rewarded with this error: "Object
is not an element or property of this class."
How does one message the data of the "Project Number" field and onto the
clipboard? Help!
Thanks...
-james