Simply put this calculation in the auto-enter option of that field:
Evaluate ( Self )
I put hise equation "Evaluate ( Self )" in the "Calculated Value" under Auto-Enter option.
But nothing happened.
Is there anything I did wrong?
Also uncheck the box: Do not replace existing value for field ( if any ).
Now, if you write 2+1 into that field, clicking outside it will show: 3
I have another question about this matter.
Since I put the equaiton "Evaluate (Self)" in the auto-enter option, when I type 1+2 in the field, the result is 3.
Here is my question:
Can I keep the formula visable when I go back to the field? Just like excel. When I enter a formula in an excle's cell, I can go back to that cell to check what formula that I entered.
Can I do that in FMP?
You'd need to use two fields. Enter the expression in field 1 and use Field 2 to evaluate it. Field 2 would use Evaluate ( Field 1 ) instead of Evaluate ( self ). It can be a field of type calculation or it can be a number field with an auto-entered calculation.
...or you can try this calculation:
Self & " = " & Evaluate ( Self )
or even this one:
p = Position ( Self ; " =" ; 1 ; 1 ) ;
e = Left ( Self ; If ( p ; p - 1 ; Length ( Self ) ) )
e & " = " & Evaluate ( e )