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

Password protection and security…

FileMaker Calculation Fields With Repetitions – FileMaker Today


A calculation field can have a repeating storage option set for it just like a text, number, date, time, timestamp and container field.


FileMaker Calculation Fields With RepetitionsRepeating fields are odd little things…


From Dwayne Wright PMP, PMI-ACP, CSM

Certified FileMaker Developer


WEB: www.dwaynewright.com

EMAIL: This email address is being protected from spambots. You need JavaScript enabled to view it.

TWITTER: dwaynewright

YOUTUBE: FileMakerThoughts


A calculation field can have a repeating storage option set for it just like a text, number, date, time, timestamp and container field.


FileMaker Calculation Fields With Repetitions Repeating fields are odd little things and I seldom use them anymore. Back before FileMaker 3, they were a workaround for the flat nature of FileMaker. According to the FileMaker wikipedia entry, FileMaker 3 rolled out in December 1995. So in the 13 + years since FileMaker went relational, repeating fields have been used as workarounds for things other than relationships (by experienced developers) and sometimes used instead of relationships (by inexperienced developers).


So there really is no way to say that repeating fields are used for this, that and the other. It is more like, “he/she is using repeating fields to do this, interesting”.


Calculations with repetitions are used primarily when interfacing with other repeating fields. This is so you have a clean calculation that extends what the standard repeating fields told you about a particular record. So if the standard field has 10 repetitions, your associated calculation will likely have 10 repetitions as well.


So in summary, a calculation can have a repeating storage option set for it, mainly so it can calculate results from other repeating fields accurately. You will generally run into this when an advanced developer is doing something “special”, when you are working on a very old file that hasn’t been modified in a long while or when a developer used a repeating field where they could have used a relationship portal.


© 2010 – Dwayne Wright – dwaynewright.com

The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

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