Can anyone tell me why this calculation is adding a date on creation of a record instead of on entry of an Amount?
Evaluate ( "Get ( CurrentDate )" ; Amount )
I would use the following as an auto-enter calculation:
if ( not isempty ( amount ) ; get ( currentDate ) ; self )
clear the "do not replace..." check box.
for testing change the calc to:
Evaluate ( "Get ( CurrentTimeStamp )" ; Amount )
what happens when you edit Amount?
I would predict that the calculation will return the newest timestamp.
Creation of a new record is finalized by commit.
Editing a col value also needs a commit before is it saved to the row.
(loosely as there are more specifics than stated herein) Commit also causes the calculation engine to fire.
It does the same thing.
yep it does. You have a state change that causes the calc engine to fire.
State of: the row does not exist to the state: row exists and the value of the col is empty must cause the calc engine to fire among other things.
So how do I fix it?
all depends on what you want to have happen in these cases:
1. new record ( where amt is empty)
2. user deletes contents of amt.
I want the date to be empty until an amount is added in the amount field.
Retrieving data ...