File manipulating with FMPro fields
File manipulating with FMPro fields
- Subject: File manipulating with FMPro fields
- From: cheshirekat <email@hidden>
- Date: Tue, 3 Apr 2001 16:31:49 -0600
I've been working fairly heavily with a Filemaker Pro 5 database I
created for my own personal use that I'm trying to tweak as much as
possible so that I have to do less manual work. Isn't that the point of
AppleScript? ;)
The database has a field "Questionable File" which just has the name of a
file. I need to make sure that file exists without knowing the exact file
path. If exists is true, then storing the path in a field of the current
record. An example directory:
folder "Utopia1:MTS:"
The "MTS" folder may have several layers of subfolders, but I want the
search to start at "MTS" and search through all of the folders until the
file is found. (Yes, the file *should* be there somewhere, in a rare
instance I'll have to set a radio button if it's MIA.) Since this
drive/partition is several GB large, I don't want to have to search the
entire drive. I know there are some FM plugins that allow for doing file
stuff from within FM - is this one of the tasks I can use a plugin for?
My other option is to use Sherlock or Find File osax, or File Buddy or ??
I'm leaning towards a FM plugin because I have to accomplish other file
tasks besides just searching for files while in FM. What are my options
of scriptable helpers? I might even want to have a startup script that
will check the "MTS" folder for any new additions and deletions against
an external database? What are my options for speed and scriptability
since my database is getting extremely large?
I have no preference whether the suggestions ore for freeware, shareware,
commercialware, osax, etc. since this is for my personal use. My goal is
to do as little typing as possible so that I can do other tasks while
updating and maintaining this database which is taking up a large amount
of my limited free time. I really love creating new databases with FM and
now I'm looking to expand my knowledge and usage.
Thanks!
kat
p.s. Sorry for the lack of brevity, I just wanted to be clear what I'm
looking for. I know there are some people on this list that use AS with
their FM databases.