Re: FileMaker Pro question
Re: FileMaker Pro question
- Subject: Re: FileMaker Pro question
- From: "Daniel A. Shockley" <email@hidden>
- Date: Mon, 22 Apr 2002 17:01:47 -0400
Gray,
The following set the value of the field OK to "checked" in just the
field whose Page was 10. It did that correctly, whether Page was a
number field, or a Text field.
Btw, I always make Boolean check box-style fields as Numbers. Then,
you can do fun things like linking to related records based on
whether they have a 1 in them, or are empty. I have a value list in
my default FileMaker template called "ONE" The only value in that
list is the number 1. Then, I shrink the checkbox on the layout so
all you can see is the box itself, not the number 1 next to it. In
that way, I make checkboxes that I put the field's name next to, and
it looks like standard Mac OS checkboxes, with nice labels. That
doesn't work if you want real text values with possibly multiple
choices, but it's much better for simple boolean things like, Use my
Nickname, etc.
Here's the code I used.
tell application "FileMaker Pro"
set cell "OK" of (every record whose cell "Page" is "10") to "checked"
end tell
Message: 14
From: email@hidden
Date: Mon, 22 Apr 2002 14:12:03 EDT
Subject: FileMaker Pro question
To: email@hidden
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.
Thanks,
Garry Simon
--
----
Daniel A. Shockley
email@hidden
email@hidden
http://www.danshockley.com
_______________________________________________
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.