AnsweredAssumed Answered

Insert records using AppleScript into a remote Filemaker DB

Question asked by SamsEcke on May 18, 2012
Latest reply on May 19, 2012 by davidanders

Title

Insert records using AppleScript into a remote Filemaker DB

Post

All,

I want to connect to a remote filemaker DB using AppleScript and insert records into a table. Here is the piece of code that I have come up with so far:

 

tellapplication "FileMaker Pro Advanced"

getURL "FMP12://XX.XXX.XX.XXX/Test.fmp12"

telldatabase "Test"

settheRecordtocreatenewrecordattable "table1"

tell theRecord

setcell "fname" to "Test"

setcell "lname" to "Test"

setcell "age" to 25

setcell "email" to "test@yahoo.com"

endtell

endtell

endtell

 

 

When I run this script, I keep getting the following error:

error "FileMaker Pro Advanced got an error: The event failed." number -10000.

I'm using FM Pro version 12 and I'm on a Mac OSX 10.7.4

Outcomes