Jump to content

How to get a auto-enter calc to update


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

Recommended Posts

I have a field that is an auto-enter calculation. When I create a new record, it automatically calculates it. The problem is that the calculation is based on info that will be added to the record. How can make sure that the calculation gets fired again?

Thanks!

John

Link to comment
Share on other sites

Nevermind. I should have looked in help before posting. Here is what I found:

If you select Calculated value, you can edit the field value in Browse mode (if Prohibit modification of value isn't selected). The value is calculated when you create a record, or when one of the referenced fields changes and the destination field is empty.

However, if you select Do not evaluate if all referenced fields are empty in the Specify Calculation dialog box, the value isn't calculated when you create a record and all fields referenced by the calculation are empty. Instead, the value is calculated when one of the referenced fields contains a value

I just had to uncheck the do not evaluate option and it worked. Hopefully this will help someone else.

John

Link to comment
Share on other sites

This topic is 7205 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
×
×
  • Create New...

Important Information

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