Forum Discussion
You may be way too young to know about this movie reference , but the solution is in this post here. Basically you need to make a rule per field and not per situation.
https://community.quickbase.com/discussions/quickbase-discussions/dynamic-form-rules-and-or/81433
- RSohan2 months agoQrew Cadet
I'm not sure I understand, but I'll check out the link you shared. Thank you.
- RSohan2 months agoQrew Cadet
I just tried the suggestion in the link you posted and it still didn't work properly. I wrote out a form rule for each specific scenario like instructed, and I was still having the same issue.
I tried keeping the Ownership Percentages section visible and all of the percentage fields visible and then hiding the ones I didn't need to show depending on what was selected in the Type of Ownership field but the same situation kept happening with the Ownership Percentage 3 field showing up.
I tried keeping it visible and then hiding what wasn't needed depending on what was chosen, and that didn't work.
I tried the inverse and keeping it hidden and only showing what was needed depending on what was chosen and that didn't work.
I even stripped out the change values part of the formulas just to simplify things and that still didn't work.
Not sure what to do now.
- MarkShnier__You2 months ago
Qrew Legend
You said in your latest post that you wrote a formal for every scenario. That is opposite of what you need to do. You need to write a form rule for every form element that you want to control.
so your first rule, for example, might be to control when ownership percentage 1 shows
Then the second rule would be for when ownership percentage 2 shows