Setting a Repeating field in FileMaker

Scripting Forums AppleScript | Mac OS X
#1

Sorry for this simple question, I was sure I knew how to do this but my technic did not work…Pleas help I cant find the answer in google.

I am trying to set a field with AppleScript in FileMaker 15 this is the code I have now:


tell application "FileMaker Pro"
	set cell "Name" of current record to "Mike" as text
end tell

It works perfect but if the field “Name” has repetitions and I would like the text “Mike” in the second repetition something like this is needed:


tell application "FileMaker Pro"
	set cell "Name[2]" of current record to "Mike" as text
end tell

but it does not work… help!!! how do I do it? :frowning:

#2
  1. Most likely, you have not yet assigned a name to the second cell, therefore you refer to a non-existent name “Name[2]” and 2) no need command as text, since “Mike” is already text.

By default, all cells are named similar to “A2”, indicating cell of column “A” and row “2”, until you yourself give them some other name. I do not have FileMaker Pro on my computer, so check what I said yourself.

#3

Thank you for replaying but in filemaker repeating fields have the same name and the [2] that I added is a way to get or set values in repeating fields but from within filemaker that is why I had the idea this will also work in AppleScript but I was wrong or its a filemaker bug I dont know. thanks any way

#4

Hi, just to let you know that this is the right code:


tell application "FileMaker Pro"
	set repetition 2 of cell "Name" of current record "Mike"
end tell

it has to have the current record for this to work! good day!!!

#5

I’m glad you found yourself a solution to a problem, that might be useful to other FileMaker Pro users. As I said, I do not have this application, which means that I do not have its scripting dictionary too, which I could experiment with.