Re: Alert on new FileMaker Record creation
Re: Alert on new FileMaker Record creation
- Subject: Re: Alert on new FileMaker Record creation
- From: John Haley <email@hidden>
- Date: Mon, 3 Dec 2001 10:25:18 -0600
I use Script Scheduler in the Auto Enter Calculation field definition to
activate a FileMaker Script that contains this AppleScript
tell application "FileMaker Pro"
tell document "Interior Program"
set CustNum to cell "Customer Number" of current record
set CustName to cell "Customer Name" of current record
end tell
end tell
set vemail to "email@hidden"
set vsubject to "New Interior Account in FileMaker"
if CustName b "" then
set vcontent to "<html><body>Customer " & CustNum & CustName & "
was created." & "</body></html>"
tell application "Outlook Express"
set myMsg to make new outgoing message with properties
{subject:vsubject, address:vemail, content:vcontent, has html:true}
send myMsg with sending
end tell
tell application "FileMaker Pro"
activate
end tell
else
end if
HTH
On Friday, November 30, 2001, at 08:39 AM, Robbie Newton wrote:
>
I have a sort of bug report9 database for our company FileMaker solution
>
that certain employees can request new features. But I have to ask them
>
to
>
send me an email every time they enter a new one because I cant figure
>
out
>
how to make FileMaker alert me if there is a new record (bug) entered
>
into
>
the bug report database. I was just thinking this morning that maybe I
>
could
>
use AppleScript to write something like that. Does anyone have any idea
>
if
>
this is possible before I spend hours trying to figure it out?
>
>
TIA
>
-Robbie
>
_______________________________________________
>
applescript-users mailing list
>
email@hidden
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
[demime 0.98b removed an attachment of type image/tiff which had a name of pastedGraphic.tiff]