10 Replies Latest reply on Oct 5, 2016 1:03 PM by TSGal

    Different behavior between a repetition calculated field and a repetition field with auto enter calculated value

    gcatnine

      I would like to know if this behavior is intentional

       

      Product and version FileMaker Pro 15.0.2 (it was the same from version 13)

      OS and version Windows 10

       

      Description

      In a calculated field with repetitions, the formula is applied to all repetitions

      In a field with repetitions, with auto enter calculated value, the formula is applied only to the first repetition

       

      How to replicate

      Create a calculated field with repetitions. In the formula put: get(CalculationRepetitionNumber).

      All repetitions will be filled with the respective repetition number.

      Then change the field to number. In the Options check “Calculated value”. The formula will be the same.

      Click “OK” and then uncheck “Do not replace existing value of filed (if any)”. Click “OK”.

      Create a new record and you will see that only the first repetition is filled (in our case with 1)