Hi all

I can't figure why it is possible to check both DATA and CALCULATED VALUE...

If I enter something into DATA, no calculation will be performed !

Or am I missing something ?

For example:

My field's name is: AutoEnter

Into Data there is: 1+3

Into Calculated value there is: Evaluate ( AutoEnter )

I was thinking that when a new record is added, that field contains: 4...but no.

BTW: I'm attaching a file to better explain what I mean... it is the neverending story of AE a repeating field :

AutoEnter.zip

Here I wish to say that the calculation:

Extend(AutoEnter) is a strange use of the function Extend(), born to be used with normal fields, not repeating ones.

But that is the lonely manner to obtain that FileMaker put the data into all repeatitions...

... lonely I said ?

No, it isn't true; I discovered that also Last(AutoEnter) works...and even GetRepetition ( AutoEnter ; 20 )

True madness !!

It is like if FMI puts this calc for this situation:

Case(

PatternCount ( calculation ; "Extend" )+

PatternCount ( calculation ; "Last" )+

PatternCount ( calculation ; "GetRepetition" )≥ 1

and

PatternCount ( calculation ; FieldName )≥ 1;

Put data into all repeatitions ;

Put data into first repeatition

)

Infact this calc works too:

Last ( AutoEnter ) & Extend ( AutoEnter ) & GetRepetition ( AutoEnter ; 0 )