Re: FileMaker Scripting (Text Formatting)
Re: FileMaker Scripting (Text Formatting)
- Subject: Re: FileMaker Scripting (Text Formatting)
- From: "Daniel A. Shockley" <email@hidden>
- Date: Wed, 12 Jun 2002 09:35:04 -0400
Message: 3
Date: Tue, 11 Jun 2002 15:38:04 -0700
From: Lars DeRuntz <email@hidden>
Organization: iLogistix
To: email@hidden
Subject: Re: FileMaker Scripting (Text Formatting)
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.
Well, that's where the fun comes in. While FileMaker is running a
FileMaker Script, it doesn't respond to Apple Events that call menu
items, since menu items are inactive during a script execution. So I
can't find any way to have FileMaker run those directly. You could
make a stay-open applet that you send an event to (with don't wait
for completion in the FM script), it waits 1 second, then sends the
command to FM. That may do it. If it does, let us know. :-) Still it
means you need a separate little applet to be running...not ideal.
Any better ideas out there?
> 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
--
----
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.