Changing data in a calculation field

[Femca]

Hi everyone

We are new users of File Maker Pro 10 and we've got a problem, we hope you can solve.

Lets say: we've got two fields. Field A and field B. We calculate field C, using field A and B in the calculation. Now we want to change some data in field C but filemaker pro shows us "not modifiable field"

How can we nevertheless change data in this field C?

Hope you can help us! Thanks

Femca

[Breezer]

Welocme to the FMForums...without knowing exacly why you would want to do that, you can use "Auto-enter calculation."

You could, however, have an overide field, so that if the overide field is empty, use the calculation, otherwise use the value in the field. For example:

field_c = if (isempty(field_z);field_a*field_b;field_z)

where field_z is the overide and whatever you input in field z will be the value.

[efen]

Make field C a number field with an auto enter calculation of A+B and uncheck Do not replace existing value

[Lee Smith]

Hi Femca, and welcome to the Forum.

Others have suggested the use of the Auto Enter Feature. I posted an Article on this the other day Link. Unfortunately, a system bug caused the screen shots to be posted twice. So, skip the first 4 at the top, and start reading the article about half way down, where you will find the screen shots have been placed properly within the text.

HTH

Lee

[Femca]

Hello,

The reason we asked this is because we have a large database based on a questionnaire where people sometimes filled in wrong information. Sometimes we want to change a calculation result without changing the original data.

If we work with an auto enter calculation syntax, and change several cells manually. How can we, if we realize we made a mistake in 1 cell, recalculate the data only in this changed cell?

Thanks a lot

Femca

[Breezer]

try what I had suggested, ie, adding a new field for manual overide, if this field is empty, calc uses user input, otherwise it will use whatever you have input in the overide field.

[Femca]

thanks for your help