• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: FileMaker Pro question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

  • Prev by Date: RE: MacOS: Making 6,000 barcodes
  • Next by Date: Re: OS X AND TypeText
  • Previous by thread: Re: FileMaker Pro question
  • Next by thread: Re: illus-trator
  • Index(es):
    • Date
    • Thread