Title
Need help with calculation in repeating field
Post
I have never used repeating field function before and I am a bit stuck
The field has 10 repetitions I need the following calculation for each, increasing the rep value of course.
calculation field is L1t Parameter [1-10]
Case(
IsEmpty ( L1t Parameter[1]) ; GetRepetition ( Template::Parameter Default Value ;1 );
Self
)
thanks
I don't work much with repeating fields either as there are much better alternatives for almost any use of a repeating field and this has been mostly the case since the release of Filemaker 3.0. (But my current job came with a database that has repeating fields and now I have to work with them while working out a plan to replace them with a better database design...)
Try:
Case(
IsEmpty ( L1t Parameter[Get(CalculationRepetitionNumber)]) ;
Template::Parameter Default Value [ Get(CalculationRepetitionNumber) ] ;
Self
)