Re: Filemaker Basics
Re: Filemaker Basics
- Subject: Re: Filemaker Basics
- From: Malcolm Fitzgerald <email@hidden>
- Date: Tue, 10 Aug 2010 14:42:47 +1000
On 10/08/2010, at 1:27 PM, Tim Mansour wrote:
>> get cell "fileName" --> returns value from record 1
>> get cell "fileName" of current record --> error "object not found"
>
> In the FileMaker object hierarchy (which, btw, is not necessarily
> obvious from reference material), Records belong to either Tables or
> Layouts so you need to explicitly state the context of the Record. For
> instance:
>
> get cell "fileName" of current record of layout "Details"
> -- keeping in mind that every layout has its own found set
>
> get cell "fileName" of record 1 of table "Files"
> -- keeping in mind that multiple tables may have the same field name
Yes, I've got the dictionary open and I can see the containment but I'm surprised that I can't get any results from a named cell. The filemaker reference says that I should be able to use an object name but it fails consistently.
tell application "FileMaker Pro Advanced"
cell "c_isp.filename" of current record of layout "information" --> object not found
cell 3 of current record of layout "information" --> "writing.pl"
cell "c_ISP.fileName" of current record of table "WBB" --> object not found
cell "c_ISP.fileName" of record 2 of table "WBB" --> "writing.pl"
end tell
It seems as though I need to have a subroutine which can be passed a cell name and hand back a cell number.
The other thing that I'm missing is a way to identify the number of the current record in the found set.
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/archives/applescript-users
This email sent to email@hidden