Table not getting updated

[DPaquin]

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, 2018 by DPaquin

[comment]

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, 2018 by comment

[DPaquin]

Thanks Comment for the response, this is greatly appreciated.

It worked.