Auto-calculate entered value. 
Author Message
 Auto-calculate entered value.
Hi,

Does anybody know a way to calculate on a value you enter in a field, and
then when you press Enter (or TAB) FMP5.0 will calculate on it an set the
value of that field?

For instance if I want only INT values I want to be able to enter any value
(e.g. 12.56) and that FMP set the value "13" in that specific field, without
the need of another calculation-field?

I tried, but got circular-errors in the calculation.

Anybody?

thanks



Wed, 09 Feb 2005 18:18:44 GMT
 Auto-calculate entered value.

You can't enter data into a calculation field nor can you reference the same
field in your calculation. Calculation fields as just that, fields that
perform a calculation on another field.
You will need to create another field "text" or "number". Probably "number"
for your example below. Then in your calculation field use the field that
you just created and Round(YourField, 0)

If you want it to appear as ONE field on the layout. Place both fields on
the layout. Make the Calculation field to not allow entry and also make the
field a color by selecting the color palette from the status bar on the left
side of the window. Make both fields the same size. Place the calculation
field on top of the entry field and select move to front from the Arrange
menu. Now select Set alignment form the Arrange menu. Select both center
values and the Ok. Enter browse mode, put you cursor in the field enter a
value. When you exit the field you should see the desired effect. Good luck.

--
Michael Stout

http://www.fmpdev.com/

Quote:
> Hi,

> Does anybody know a way to calculate on a value you enter in a field, and
> then when you press Enter (or TAB) FMP5.0 will calculate on it an set the
> value of that field?

> For instance if I want only INT values I want to be able to enter any value
> (e.g. 12.56) and that FMP set the value "13" in that specific field, without
> the need of another calculation-field?

> I tried, but got circular-errors in the calculation.

> Anybody?

> thanks



Wed, 09 Feb 2005 22:48:13 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Auto Enter calculated value problem

2. Calculated Auto-Enter

3. Beginer Question: auto-enter date value when another field is changed

4. Auto enter from value list checkboxes

5. Help!! Auto enter 2 values over related file

6. Entering a calculated value into a date field??

7. Auto-update a number field w/ Auto-Enter Calculation

8. Using last entered value for default value in ISQL FORMS

9. Using last entered value for default value in ISQL

10. Using last entered value for default value in ISQL FORMS

11. Using values in calculated columns in further calculated columns

12. auto-detecting when user enters the INTERNET


 
Powered by phpBB® Forum Software