Applescript to get a value from a FMP cell

[Daniel Paquin]

I've got an AppleScript program which starts automatically when an SDHC card is inserted in the computer. The content of the card is transferred onto a specific directory for FileMaker Pro to import.

Up to last week everything was done on the internal disk of my computers. I now have a SAN (Storage Area Network) and all computers have have access to the files.

However, I still need to keep the option to run locally. Therefore. I've created the field "MasterDisk" in the "Preference" table of my FileMaker Pro database. MasterDisk can only have the value "SAN" or "LOCAL".

I want the AppleScript program when starting to go and grab the value of the cell "MasterDisk"

If the value is equal to "SAN" the files contained in the SDHC card is to be copied onto the SAN disk. If the value is equal to "LOCAL" the files contained in the SDHC is to be copied on the local disk of the computer executing the script.

The table Preferences contain only one record. How can I get the value contained in the MasterDisk cell.

I've tried this script and I got an timeout error. I want abcd to get the value "SAN" or "LOCAL" from the Preference filemaker pro table.

tell application "FileMaker Pro Advanced"

set abcd to cell "GMasterDisk" of table "Preferences" of database e "Inventory"

display dialog abcd

end tell

I just thought of that, what about a plist. Can FMP interact with PLIST i.e save and retrieve the content of a specific field.

Regards!

Daniel