The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

Our Preferred Cloud Hosting Provider

The FileMaker FieldRepetitions Function – FileMaker Today

Get real time updates directly on you device, subscribe now.

The FieldRepetitions function gives you the number of repetitions and the orientation of a given repeating field on a layout. So if we had a repeating field using this function, we would see something like ( 4 horizontal ) or ( 4 vertical ). Now I do want to emphasis the importance of the layoutname parameter. Some user might make the mistake of putting in the table name, which will not work because this function is layout dependent. Also the returned result of repetitions is for the number of repetitions shown on the layout. This might be different than the overall number of repetitions available for a defined repeating field.


FieldRepetitions ( Get ( FileName ) ; Get ( LayoutName ); “repeating_field_1” )


Now, I tried experimenting to see if I could use get function for the various parameters to have a dynamic return. That is to say, show me what the results are for the current repeating field that I have the cursor within. The calculation looks like this …

FieldRepetitions ( Get ( FileName ) ; Get ( LayoutName ) ; Get ( ActiveFieldName ) )

I did get this to work using the Data Viewer in FileMaker Advanced but not as a standard calculation field. However, I do think using the Data Viewer or as a branching indicator in a script would be the more traditional use of this design function.

© 2010 – Dwayne Wright –

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More