fileMaker Value Lists
fileMaker Value Lists
- Subject: fileMaker Value Lists
- From: Oakley Masten <email@hidden>
- Date: Wed, 12 Sep 2007 13:24:59 -0700 (PDT)
Original Post:
>> Is it possible to load a Filemaker 8.5 value list
into
>> a variable?
>> The value list is created dynamically from the
items
>> in the current database for the field in question.
>> The database records change from project to
project,
>> so I can't easily specify the list in a "hard
wired"
>> fashion.
>>
>> Such as
>>
{"summer","Fall","winter","spring","holiday","special"}
>>
>> show (every record whose cell "Caption" contains
>> "spring")
"Bruce Robertson" wrote:
> Though applescript is useful for some things I don't
see why it is necessary for what you are trying to do.
This seems like just standard FileMaker scripting.
"Gary (Lists)" Wrote
Totally agreed, Bruce.
And this may be one of the (recent spate of)
ill-formed questions which only serve to confuse both
asker and potential answerer alike.
It's really most helpful that people say what they are
trying to accomplish, more specifically, rather than
just include some small bit of pseudo-code.
Working with Value Lists in FM can be done with AS,
but how that happens (i.e., the way in which those are
established in FM) is a matter of specifics.
I don't ready anything in Oakley's post that suggests
an extra-FM need...but I think it must be a matter of
my not really "getting" the goal.
Blah. 'nuf from me.
--
Gary
Oakley now writes
OK Gentlemen In a attempt to ask what I thought to
be a simple question I did not provide enough
information.
Please, let me try again.
I have a Filemaker database that contains Items in a
catalog listed by SpreadName and ItemNumber.
The item list and spread names are not in order.
There are 8 to 10 items per spread.
I also have a folder of Excel files for each item with
the name of each file being the ItemNumber.
I need to group the files by spread, sort them by
ItemNumber and print them from Excel. These printed
sheets will then be given to the appropriate people
for further use.
There are usually 32 spreads/catalog and therefore
300+ items.
My thinking was that:
1] I would use AppeleScript to loop thru the Spreads
in FileMaker. [32}
2] Then I would loop thru the found set of records for
that spread. [8-10]
3] Get the name of the File to print
4] Have AppleScript Open that file in Excel and print
it.
5] Mark that record as printed.
6] If the file is missing Mark the record Missing
File
7] Have appleScript Move the printed file into a
subfolder marked Done
8] The creative director can then view a list of
Missing files and go get them.
To be totally accurate: The spreads are divided among
3 or 4 different Designers and they are also part of
the database. I would want to first loop thru the
Users list and then print the individual item sheets
by spread for that user in order. Ultimately I
would have AppleScript create the Done subfolders
using the Users Name and move the printed Excel file
into that folder to be delivered along with the
printed pages to that user.
In order to do this I have created a Value list in
FileMaker that uses the SpreadName field to
dynamically create the list. I have done this because
the items and spread names change with every new
catalog.
I want to load that value list into the variable to
drive the SppreadName find process for step 2.
I have done a work-a-round by looping thru all of
the records and adding each SpreadName to an
AppleScript list variable theSpreadNameList if it is
not already there. This works just fine but takes a
long time.
Therefore: My original question: Is there a way to
load that Dynamic Value List into AppleScript
directly?
If there is a way to do all of this without
AppleScript I would be grateful for your help.
Thanks for everyones input on this ?
Oakley
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden