gcatnine

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

Discussion created by gcatnine on Sep 30, 2016
Latest reply on Oct 5, 2016 by TSGal

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)

Outcomes