Need help with calculation in repeating field
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
Hi Phil
the result fields repititon number has to be the same as Lt1Parameter
ie
Case(
IsEmpty ( L1t Parameter[1]) ;
Template::Parameter Default Value [ 1 ] ;
Self
)
Case(
IsEmpty ( L1t Parameter[2]) ;
Template::Parameter Default Value [ 2] ;
Self
)
Case(
IsEmpty ( L1t Parameter[3]) ;
Template::Parameter Default Value [ 3] ;
Self
)
Yep. I had that in mind with my last post. With a calculation field that is a repeating field, this is something that you specify in the number of repetitions box in the lower left corner of the Specify Calculation dialog box. The Get(CalculationRepetitionNumber) function then returns a different value for each repetition of the calculation field.
you have lost me! I cant find anywhere to specify number of repitions.
this isn't a script.
Hi Phil
Yip but i cant use the Self expression in a specify calculation field
should have stated the field was auto-enter
Not going to use repeating field after all because of their limitations, used a related table instead!
thanks
I agree that a related table makes more sense, but in an auto-enter calculation, you specify the number of repetitions on the storage tab in the field options dialog.
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
)