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

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.

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

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

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

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.

thanks for your help