-
1. Re: Need help with calculation in repeating field
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
) -
2. Re: Need help with calculation in repeating field
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
) -
3. Re: Need help with calculation in repeating field
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.
-
4. Re: Need help with calculation in repeating field
you have lost me! I cant find anywhere to specify number of repitions.
this isn't a script.
-
-
6. Re: Need help with calculation in repeating field
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
-
7. Re: Need help with calculation in repeating field
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.