Jump to content

calculated field- overwrite or work-around


This topic is 5704 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am having a hard time finding a solution to overwriting a calculated field. For the majority of records, summer salary + fall salary + winter salary + spring salary =Total salary… but there is a handful of records that don’t follow that rule and the “total salary” needs to be inputted manually.

Can you overwrite a calculated field?

Your assistance is greatly appreciated. Thanks in advance

Link to comment
Share on other sites

There is an option in the field definition dialog, which you can check off. When it is checked, it tells filemaker to not write over anything in the calculated field if there is something there.

so for example fall_salary and winter_salary = total_salary

then if a number is directly typed into the total_salary field, then even though it is a calculated field, any changes to the fall_salary or winter_salary will not result in the total_salary field being overwritten.

maybe this option might help?

hope so,

sincerely,

J__

Link to comment
Share on other sites

This topic is 5704 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.