Re: Filemaker 8 Help - Find a record
Re: Filemaker 8 Help - Find a record
- Subject: Re: Filemaker 8 Help - Find a record
- From: Malcolm Fitzgerald <email@hidden>
- Date: Mon, 4 Dec 2006 10:54:21 +1100
On 30/11/2006, at 9:21 AM, Chris Prew wrote:
Hi -- I've been using Applescript with FMP 5/6 for a long time, but
writing Applescripts for FMP8 is driving me batty.
I need to convert a lot of scripts that read text input, find the
text item in FMP in a certain cell, and then grab data from the
record in question, and repeat ad infinitum. Anybody shed some light
on what the proper context for this is?
set store_number to (whatever the store number is from the list)
tell application "FileMaker Pro Advanced"
tell database "CorpDB"
go to layout "MyLayout"
show (every record of table "Stores")
show (every record of table "Stores" where cell
"StoreID" is equal to store_number)
end tell
end tell
When I do this it'll find the store number for the first store
number on my list, but it'll never go beyond that store.
FMP's capabalities have increased tremendously but it's applescript
interaction has become much more tedious.
Here are a few gotcha's.
databases can have many documents!
databases can have many windows!
window names and database or document names may be different!
"whose" clause only works when all objects belong to the current layout!
This code works inside a repeat loop for me
tell application "FileMaker Pro Advanced"
tell document "Research Kit.fp7"
go to layout "Notes - Form View"
tell current table
show (every record whose cell "Research Notes ID" is equal to
store_number)
end tell
end tell
end tell
malcolm
_______________________________________________
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/mailman//archives/applescript-users
This email sent to email@hidden