Incremental field names within script?

[lizard294]

Hi everyone,

I am trying to write a Filemaker 9 script that accesses a group of text fields that are named with sequential numbers.

Example:

Item1

Item2

Item3

Is there a way to read data from these fields sequentially by calculating the field names? I was hoping to do something like:

TableName::Item$LoopNumber

The above doesn't work, however. Is there any way to do this in filemaker? Thanks!

[comment]

Try something like:

GetField ( "TableName::Item" & $LoopNumber )

[lizard294]

Works perfectly, thanks for the help!!

Is there an equivalent function to GetField to save new field contents?

[comment]

I am afraid I don't understand the question.

[Mark DeNyse]

lizard,

There's no straight-up equivalent for a SetField() inverse of what you seek, but there are a number of tricks that people have posted here. One that I've used (if you have 8.5 or later) is to calculate the field name and pass it to GoToObject(), then use SetField() without specifying the target field (since you're already where you need to be via GoToObject() ). The one catch is that you have to give object names to each of the fields you want to use.