I'd like to know how I can set a specific value of a repeating field (say repeat No.2) of a 4 values repeating field, using AppleScript.

Don't know if this will work with FMP 6.

tell application "FileMaker Pro Advanced"

tell document "YourDB"

--assumes cell 2 has 2 or more repetitions

set repetition 2 of cell 2 of current record to "Test"

end tell

end tell

Edited March 4, 200817 yr by Guest

set repetition 2 of cell 2 of current record to "Test"

Although this seems so incredibly straight-forward, this solution did not work for me. Does anyone else have a clue?

[color:red]UPDATE: The error I encountered was a variable typing error. I was using using variables instead of actual numbers, and AppleScript doesn't recognize the cell's type (e.g. "number") when copying the value into a variable.

Edited May 23, 200916 yr by Guest
RESOLVED