Re: fileMaker Value Lists
Re: fileMaker Value Lists
- Subject: Re: fileMaker Value Lists
- From: Oakley Masten <email@hidden>
- Date: Thu, 13 Sep 2007 06:51:13 -0700 (PDT)
--- Bruce Robertson <email@hidden> wrote:
> > 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.
>
> 1. Sorry I still cannot understand your explanation.
>
> 2. Why have ANY spreadsheets? You've got a
> database.
>
Good Morning Bruce
I have always found the AppleScript List to be of
great value in solving problems and I appreciate your
participation. Especially since you are helping me in
solving this problem. You have helped me define and
document what I want to do and are continuing to do
so.
The spreadsheets are used by 36 different people who
only work in Excel and have absolutely no interest or
need to working any other way.
They Create these spreadsheets to drive communication
betweeen each other, our many vendors and many
suppliers.
Also, and most importantly, the Owner of the company
wants the spreadsheets - marketing uses them - the web
team uses them - the merchandising team uses them -
the catalog department uses them - the product
developement group uses them. I am just looking for a
way to manage sorting and printing them automatically.
Therefore back to my question, which you have not
answered.
Is it possible to load a Filemaker 8.5 value list into
a variable?
And if so how?
Thanks
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