Yes, that was very helpful! I did not know about form load rules until now. Thank you!
My current situation is that:
- I save the value of control1 in the form load event to a control1_initialvalue field
- I save the value of control2 in the form load event to a control2_initialvalue field
- I have the formatting Rule of a section (change justification) set to be Hidden, as long as control1 = control1_initialvalue, and, control2=control2_initialvalue
At this point the weird thing is, it works great in Preview mode. I go to control1, for example (a drop down) and it initially says Yes. The hidden section is hidden. Then I change control1 to No, and the hidden section becomes unhidden. I change control1 back to Yes, and the hidden section becomes re-hidden.
However, when I go to edit an item on the list, it doesn't behave like that. The latter part of the logic doesn't seem to execute. if I change control1, then the hidden section becomes unhidden. But if I change it back to what it was initially when the form loaded, then the hidden section fails to become hidden again.
Any idea what might cause a difference like this between preview and live? And is there a way to create a post here that includes line breaks?