
1. Re: Can I create a nonfixed equation field?
raybaudi Jun 15, 2011 12:13 AM (in response to leonhart1981)Yes.
Simply put this calculation in the autoenter option of that field:
Evaluate ( Self )

2. Re: Can I create a nonfixed equation field?
leonhart1981 Jun 15, 2011 12:39 AM (in response to leonhart1981)I put hise equation "Evaluate ( Self )" in the "Calculated Value" under AutoEnter option.
But nothing happened.
Is there anything I did wrong?

3. Re: Can I create a nonfixed equation field?
raybaudi Jun 15, 2011 2:13 AM (in response to leonhart1981)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

4. Re: Can I create a nonfixed equation field?
leonhart1981 Jun 15, 2011 3:16 AM (in response to leonhart1981) 
5. Re: Can I create a nonfixed equation field?
leonhart1981 Jul 26, 2011 11:49 PM (in response to leonhart1981)I have another question about this matter.
Since I put the equaiton "Evaluate (Self)" in the autoenter 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?

6. Re: Can I create a nonfixed equation field?
philmodjunk Jul 27, 2011 10:19 AM (in response to leonhart1981)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 autoentered calculation.

7. Re: Can I create a nonfixed equation field?
raybaudi Jul 27, 2011 11:49 AM (in response to leonhart1981)...or you can try this calculation:
Self & " = " & Evaluate ( Self )

8. Re: Can I create a nonfixed equation field?
raybaudi Jul 27, 2011 12:05 PM (in response to leonhart1981)or even this one:
Let([
p = Position ( Self ; " =" ; 1 ; 1 ) ;
e = Left ( Self ; If ( p ; p  1 ; Length ( Self ) ) )
];
e & " = " & Evaluate ( e )
)