Forum Discussion
- QuickBaseCoachDQrew CaptainYou need to scrap those rules.
Just have 1 rule per section.
If any of the following
Answer = 1
Answer = 2
Answer = 3
Answer = 4
Show Section 1
Then another rule for section 2 and another rule for section 3 and another rule for section 4.- GeneStrelkovQrew CadetTook me 2 days of thinking, before coming across this thread, and I was thinking same as OP. I had to do the same, write on the paper, to figure out the logic.Thank you for this post.
- QuickBaseCoachDQrew Captain:). That was a very funny thread when I re-read the whole thing.
- GeneStrelkovQrew CadetYour first response makes so much sense, yet for some reason It was so confusing, I had to continue reading, until I wrote it out on the paper lol
- MarkMark3Qrew MemberI am not following where I would implement this in dynamic form rules. I have the same issue. I have a multiple choice field that i want to trigger show/hide specific sections based on the value in the multiple choice field. The dynamic form rules doesn't seem to allow this. For example, I have a field called Milestone type. It has 3 values (A, B, C). If value A, show section 1, hide section 2 and 3. If value B, show section 2 hide section 1 & 3. If Value C, show section 3, hide section 1 & 2. This would seem to be simple logic in an if/then logic test, but dynamic forms only has a when statement. Please help...how do I achieve this desired functionality? Thanks, Mark
- QuickBaseCoachDQrew CaptainYou have to reverse your thinking. Write down on paper when you want to show section 1, and make a single form rule for that.
Then write down on paper when you want to show section 2 and make a separate form rule for that. - MarkMark3Qrew MemberI appreciate your suggestion and I have done that and still no bueno. I have tried to set up a multiple choice field [Milestone Type] with set of values ("Charter", "Budget", "Inventory") then in the dynamic form I created 3 rules. The first is When [Milestone Type] = "Charter" Show Section "Charter information" Hide Sections for "Budget" and "Inventory" This rule works great. But when I add Rule 2, which is When [Milestone Type] = "Budget" Show Section "Budget" and Hide sections for Charter and Inventory, I get the form rule error message because QB only looks at the last rule and sees duplicate rules on the same field. Alternatively I set it up so that my Milestone Types were individual checkboxes and then created a rule on each individual checkbox, but that doesn't work either because QB looks at the show/hides in each rule and sees duplication. This is utterly frustrating as the logic is simple and this should not be that difficult. I appreciate anyone's insight...feeling thwarted by something so basic. Thanks, Mark
- QuickBaseCoachDQrew CaptainWell, What can I say. You really need to reread my previous post.
Take out a piece of paper. Seriously. Write down in words under what conditions section 1 should be open. Never mind thinking about any other sections, just think about section 1. Then build the rule for that section only.
Then take out another piece of paper and write down in words when section 2 should be open. And then go into your four rules and make a second form rule specifically dealing with section 2. - MarkMark3Qrew MemberAgain, thank you for the quick reply. I believe I did and that's what I posted above. Rule 1 is When [Milestone Type] = "Charter" Show Section "Charter information" Hide Sections for "Budget" and "Inventory" Rule 2 is When [Milestone Type] = "Budget" Show Section "Budget" and Hide sections for Charter and Inventory. I get an error message.
- MarkMark3Qrew MemberLet me reiterate I greatly appreciate your help. I'm just not understanding what I am doing that is different from what you are suggesting. The dynamic rules won't allow me to have multiple rules.
- QuickBaseCoachDQrew CaptainNo. You're still not doing what I said. I want you to write a rule that only deals with one section. Rule number one can only refer to one section. And rule number two can only refer to a different section.
In the example you just wrote above, your rule number one deals with two sections. It refers to both section called Charter and section called Budget.
You need to have rule number one definitively state ms when do you want section Charter to show. And nothing else. Just when section Chater should show.
Rule number two needs to definitively state when you want section budget to show. And nothing else. - MarkMark3Qrew MemberSo I can't have it work in an accordion style? What I am trying to do is only show the section pertaining to the choice selected in the Milestone Type field. So if someone selects Budget, that's all they see on the form and if they select Charter, that's all they see.
- QuickBaseCoachDQrew CaptainTry this.
Rule 1 is When [Milestone Type] = "Charter" Show Section "Charter information"
Rule 2 is When [Milestone Type] = "Budget" Show Section "Budget".
Then make a rule for when Inventory should show.