The Original Filemaker Community - Forum
FileMaker News | FileMaker Tutorials | FileMaker Videos

The Leading Filemaker Developer Tools

Password protection and security…

The FileMaker FieldRepetitions Function – FileMaker Today


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.


Basic EXAMPLE:

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


EXPERIMENT

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 – dwaynewright.com

Comments are closed.

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

Privacy & Cookies Policy