I am getting a value from a plist file and I am trying to update the value of a field in a FileMaker Pro table. The script read the plist files correctly but the field does not get updated in the FileMaker Pro table.

Would anyone have an idea why set _EventNo to field  "EventNo" of table "Preferences"  does not work?

Many Thanks!

 

 

tell application "System Events"   

      tell property list file ("Volumes:NX5U:NX5U.plist")       

           tell contents             

                 set _EventNo to {value of property list item "EventNo"}         

           end tell     

       end tell

end tell

set _EventNo to field  "EventNo" of table "Preferences"  

Edited December 2, 20187 yr by DPaquin

You are setting the variable to the value of the field, not the field to the variable. Note also that "field" in AppleScript is not the same thing as "field" in Filemaker.

Assuming you only have one record in Preferences, try changing the last line to:

set field "EventNo" of table "Preferences" to _EventNo

 

 

Edited December 2, 20187 yr by comment

Thanks Comment for the response, this is greatly appreciated.

It worked.