55752

Sending data from AppleScript to FileMaker records

I'm computing some data in AppleScript that I'd like to then insert into a specific FileMaker record. Here's my AppleScript:

on sendDataToFM(FileNameWithExtension, ClipLength) tell application "FileMaker Pro Advanced" show every record of database 1 show (every record whose cell "File Name" = FileNameWithExtension) repeat with i from 1 to (count record) set MatchingRecord to record i set data cell "CLIP LENGTH" of MatchingRecord to ClipLength end repeat end tell end sendDataToFM ... my sendDataToFM('Some Video.mov', '00:01:22.55')

Everything works <strong>except</strong> the line

set data cell "CLIP LENGTH" of MatchingRecord to ClipLength

The error returned is

(*Can’t get cell "CLIP LENGTH" of {"Some Video.mov", ... }.*)

The script finds the right record, and the FileMaker field name is definitely "CLIP LENGTH". What am I doing wrong?

Answer1:

Try:

on sendDataToFM(FileNameWithExtension, ClipLength) tell application "FileMaker Pro" show (every record of current table whose cell "File Name" = FileNameWithExtension) repeat with i from 1 to (count record) set cell "CLIP LENGTH" of (record i) to ClipLength end repeat end tell end sendDataToFM my sendDataToFM("Some Video.mov", "00:01:22.55")

Recommend

  • Linux java wrapper and installer
  • Styling text for textarea Wicket
  • Singleton Alternative - is it equivalent?
  • Proguard Exception java.io.IOException: Duplicate zip entry
  • Is there an HTML code that can make my background picture transparent and my text non-transparent?
  • ASP.NET MVC2 Error: No parameterless constructor defined for this object
  • why does .next() give me 'undefined'
  • Julia: How to give multiple workers access to functions that are 'include(…)' into a modul
  • Primefaces :radioButton inside a ui:repeat
  • Floated image with variable width and heading with background image
  • Add dynamic data to line chart from mysql database with highcharts
  • Compiling dlib on OS X
  • Center align outputs in ipython notebook
  • Using Sax parsing to edit and write XML in VB6
  • custom UITableViewCell with image for highlighting
  • Change multiple background-images with jQuery
  • Django: Count of Group Elements
  • Recording logins for password protected directories
  • Spring Data JPA custom method causing PropertyReferenceException
  • C# - Serializing and deserializing static member
  • Align navbar back button on right side
  • How to extract text from Word files using C#?
  • javascript inside java/jsp code
  • How to check if every primary key value is being referenced as foreign key in another table
  • Sending data from AppleScript to FileMaker records
  • MySQL WHERE-condition in procedure ignored
  • Running a C# exe file
  • vba code to select only visible cells in specific column except heading
  • Symfony2: How to get request parameter
  • Google cloud sdk not working when python points python3
  • Why winpcap requires both .lib and .dll to run?
  • Run Powershell script from inside other Powershell script with dynamic redirection to file
  • How to include full .NET prerequisite for Wix Burn installer
  • KeystoneJS: Relationships in Admin UI not updating
  • AngularJs get employee from factory
  • Load html files in TinyMce
  • How can I get HTML syntax highlighting in my editor for CakePHP?
  • coudnt use logback because of log4j
  • Is it possible to post an object from jquery to bottle.py?
  • How to get NHibernate ISession to cache entity not retrieved by primary key