RE: FileMaker 'create new record @'
RE: FileMaker 'create new record @'
- Subject: RE: FileMaker 'create new record @'
- From: Craig Sutherland <email@hidden>
- Date: Mon, 30 Oct 2000 11:53:14 -0600
>The data is being filled in the field creation order and not according to
the fields that are actually on this layout.<
I haven't had alot of scripting experience with FM but.....I have heard that
creation order is the only way the data will go in...You may have to
re-create the fields in the correct order for your script to work properly.
Probably not the answer you wanted.....maybe someone else has some type of
"workaround" or knows for a fact that what I have told you is true.
Steve Goodman
Six|12 - THE LTC GROUP
Also there needs to be as many items in the list as there a fields in
the database. The items in the Applescript list need to be of the
same class (text,number, date,etc.) as the Filemaker fields are.
Include null items as needed- {"Mr.","Fred","","Smith"} for a 4 field
record with Title,FirstName, MIddleInitial,LastName as fields(in that
order) and Mr. Smith having no middle initial.
Another gotcha is that Filemaker uses the creation order of fields
when importing data. That can be found in the Create Fields
window.
Craig