Reset Field value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jono - 31 Jan 2007 22:51 GMT

I have a field that normally shows the sum of a couple of other fields. I
also have a check box that when TRUE sets that field's value to "0"
overriding the formula's sum.

If the checkbox was selected in error and I uncheck it the original sum does
not return. How do I get it to return?

Reply to this Message

S.Y.M. Wong-A-Ton - 01 Feb 2007 09:04 GMT

If you're using rules, add a rule on the checkbox to set the sum field, but
then add a condition on the rule so that it will only fire when the value of
the checkbox is FALSE.
---
S.Y.M. Wong-A-Ton

> I have a field that normally shows the sum of a couple of other fields. I
> also have a check box that when TRUE sets that field's value to "0"
> overriding the formula's sum.
>
> If the checkbox was selected in error and I uncheck it the original sum does
> not return. How do I get it to return?

Reply to this Message

Jono - 01 Feb 2007 13:56 GMT

O.K. if I understood you, I had a rule on the checkbox that when selected
(TRUE)set the value of the sum field to "0". I added another rule to the
checkbox that when the checkbox is not selected (FALSE) runs the sum formula.

What happens now is that if I put values in the fields that are summed the
sum field shows nothing. If I then select the checkbox the sum field displays
"0". If I then deselect the checkbox the the sum field displays the result of
the formula.

How do I get the sum field to display the result of the formula without any
action on the checkbox?

> If you're using rules, add a rule on the checkbox to set the sum field, but
> then add a condition on the rule so that it will only fire when the value of
[quoted text clipped - 8 lines]
> > If the checkbox was selected in error and I uncheck it the original sum does
> > not return. How do I get it to return?

Reply to this Message

Jono - 02 Feb 2007 14:23 GMT

Never mind. I put the formula back into the sum field. No when the form opens
the sum field runs it's formula then if the checkbox is selected it sets the
value to "0" then if unchecked it runs a copy of the sum formula.

Thanks for your help.

> O.K. if I understood you, I had a rule on the checkbox that when selected
> (TRUE)set the value of the sum field to "0". I added another rule to the
[quoted text clipped - 20 lines]
> > > If the checkbox was selected in error and I uncheck it the original sum does
> > > not return. How do I get it to return?

Reply to this Message