AnsweredAssumed Answered

FieldRepetitions not working as expected

Question asked by on Mar 18, 2018
Latest reply on Mar 19, 2018 by erolst

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.