Re: FileMaker Scripting (Text Formatting)
Re: FileMaker Scripting (Text Formatting)
- Subject: Re: FileMaker Scripting (Text Formatting)
- From: Lars DeRuntz <email@hidden>
- Date: Tue, 11 Jun 2002 15:38:04 -0700
- Organization: iLogistix
Is it possible for FileMaker Pro to tell itself to do this, from within one of its own
"Perform AppleScript[]" script steps?
I think someone has done that before, but I just can't remeber how.
-Lars DeRuntz
iLogistix
Fremont, CA
"Daniel A. Shockley" wrote:
>
>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
>
>
--My own tests
>
do menu menu item 2 of menu "Font" of menu "Format"
>
do menu menu item "Geneva" of menu "Font" of menu "Format"
>
do menu menu item 2 of menu "Size" of menu "Format"
>
do menu menu item "18 Point" of menu "Size" of menu "Format"
>
do menu menu item 2 of menu "Style" of menu "Format"
>
do menu menu item "Outline" of menu "Style" of menu "Format"
>
do menu menu item 2 of menu "Align Text" of menu "Format"
>
do menu menu item "Right" of menu "Align Text" of menu "Format"
>
do menu menu item 2 of menu "Line Spacing" of menu "Format"
>
set ColorColumn to 10
>
set ColorRow to 6
>
do menu menu item ((ColorRow - 1) * 11 + ColorColumn) of menu "Text Color" of
>
menu "Format"
>
--end of my own tests
>
>
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.
_______________________________________________
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.