将数据从 AppleScript 发送到 FileMaker 记录 [英] Sending data from AppleScript to FileMaker records

问题描述

我正在 AppleScript 中计算一些数据，然后我想将这些数据插入到特定的 FileMaker 记录中.这是我的 AppleScript:

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 except the line

set data cell "CLIP LENGTH" of MatchingRecord to ClipLength

返回的错误是

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

脚本找到了正确的记录，FileMaker 字段名肯定是CLIP LENGTH".我做错了什么?

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

推荐答案

尝试:

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")

这篇关于将数据从 AppleScript 发送到 FileMaker 记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！