Re: applescript-users digest, Vol 3 #535 - 17 msgs
Re: applescript-users digest, Vol 3 #535 - 17 msgs
- Subject: Re: applescript-users digest, Vol 3 #535 - 17 msgs
- From: "Daniel A. Shockley" <email@hidden>
- Date: Mon, 10 Jun 2002 23:20:56 -0400
Message: 6
Date: Mon, 10 Jun 2002 12:23:46 -0400
Subject: FileMaker Scripting
From: Mario Kolaszewski <email@hidden>
To: <email@hidden>
Is it possible to change the text color or style in a single cell using
AppleScript?
Mario,
Well, you'd need to go to the field you want, then tell FileMaker to
Select All, then set the color, as follows:
-- note that you have to refer to the colors in
-- the Text Color menu item by their index
tell application "FileMaker Pro"
activate
go to cell "LastName" of current record of database 1
do menu menu item "Select All" of menu "Edit"
do menu menu item 37 of menu "Text Color" of menu "Format"
-- 37 is bright red, count across, then next row
-- (rows have 11 squares)
-- so bright red is (4 - 1)*11 + 4 [4rd row, 4th column]
-- black is (1-1)*11 + 2
-- so the general formula is INDEX = (row - 1)*11 + column
end tell
Hope that helps. I get some strange results on some fields as opposed
to others, but I'm running FileMaker 5.5 for OS X, and it is just
chock full of missing/strange bits as compared with the OS 9 version
[can't type field names in Specify Field if using a relationship,
dialog boxes don't hold shape when resized, closed, and then
re-opened, and much more...sigh. Some things in FileMaker have gotten
LESS developer-friendly as the years go by.].
--
----
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.