Re: Setting cells in Filemaker
Re: Setting cells in Filemaker
- Subject: Re: Setting cells in Filemaker
- From: Ehsan Saffari <email@hidden>
- Date: Fri, 4 May 2001 23:12:42 -0600
Hello, On Fri, 04 May 2001 11:58 -0400, Matthew Broms
<email@hidden> wrote:
>
I'm having trouble setting a just the group of cells in a specific layout in
>
Filemaker Pro. I've tried multiple variations of the following:
>
>
Go to layout "recap_input" of window "myDB.fp5"
>
Create new record of layout "recap_input" with data {"x", "y", "z"}
>
>
When I try to do this, it's as if Filemaker ignores the layout I specified
>
and just starts populating cells in the order which they were defined when
>
creating the database.
To find out the order of fields in a layout, so you can use that order
when creating new records with data:
Tell application "FMP" to get name of every field of layout "whatever"
the result fielnames list will be the correct order to use for create new
record with data at that layout.
>
So if the fields of a layout I specified to populate
>
only have the 4th, 5th, and 6th cells I defined, these will be left blank
>
and cells 1, 2, & 3 will get the respective data.
>
>
The only way I have figured out to set just the cells of a particular layout
>
is to explicitly state each cell, such as: set {cell "xyz" of record 1,
>
cell "abc" of record 1} to {"Hello", "World"}. This seems laborious and
>
inefficient, especially if I were to have a DB with 100 fields per record
>
and my target layout has a mixture of 50 of them. Does anyone know a
>
quick/simple way to do this - to properly direct Applescript to tell
>
Filemaker to do this by using ONLY the cells of a specified layout?
Best to use a layout that has only the cells that you need to populate
and pass the data in the order that FMP knows (as returned by my example
above). Otherwise how is FMP to know which 50 of the 100 cells should get
which piece of data?
hth
ehsan