I am trying to get the number of field repetitions for a particular field on the current layout. The FieldRepetition command should return (in my case) 34 vertical. (Although "34" is all I'm worried about).
In the syntax for the command, I have specified Get (FileName) for the filename and Get (LayoutName) as the first two parameters. If I try to use the "actual" name of the field in the third parameter, nothing is calculated. If, however, I set the third parameter to be Get ( ActiveFieldName) and click on the field I want, the correct result is calculated. I'm confused as to why I cannot use the actual field name!
I have attached a screenshot to show the field definitions and calculations etc.
The file is being hosted from a local in-house FileMaker Server, so I'm not sure whether that maybe causing some issues.
I would appreciate any feedback on what the problem may be.