Re: FileMaker Pro question
Re: FileMaker Pro question
- Subject: Re: FileMaker Pro question
- From: Peter Matthias Noordzij <email@hidden>
- Date: Mon, 22 Apr 2002 23:20:27 +0200
02/04/22 20:12, email@hidden wrote:
>
I have a question regarding trying to script an aspect of FileMaker Pro. We
>
use a database for tracking the processing of pages (within the graphic arts
>
field). Each record contains many fields. One of the fields is a page number;
>
another is a checkbox called "OK". After a page is processed, the technician
>
checks off the "OK" checkbox for that particular page. A problem arises when
>
I try to script this function; if I tell FMP to check off "OK" in every
>
record whose cell "Page" is "10" (representing the page number), records for
>
pages 100 and 1000 are also checked. I have some goofy workarounds for this,
>
but I am hoping there is an easier ("correct") way.
suppose your checkbox is field 48 out of 60 then
return cell 48 of the current record
will return "" if OK is not checked and "OK" if it is checked.
return cells 1 thru 60 of the current record
will return a list of the contents of all fields given a certain
layout. In a different layout the field order will be different,
so you must make sure to activate the correct layout first.
When finding 10, 100 and 1000 you can try this:
if the number of records as number > 1 then
repeat until cell "Page" of the current record is "10"
go to the record after the current record
end repeat
end if
Page 10 should be a unique number in your database though.
Matthias
* * *
Peter Matthias Noordzij Waaldijk 77 5327 AB Hurwenen
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.