I have 4 sections that i want to show or hide based off an answer.
Answer = 1
shows sections one. (or hides 2, 3 & 4..)
answer = 2
shows sections 1 and 2 (or hides 3 & 4)
answers = 3
shows sections one, two, & three. (or hides 4)
answer = 4
Shows all or hides none.
i have other sections on the form as well, but only want to hide these based on the answer. It keeps telling me "Show Form Rules Warning"
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.
Then write down on paper when you want to show section 2 and make a separate form rule for that.
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.
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.
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.
I have a form and on that form based on lookup field need to show various sections. I need to write dynamic rules to show sections. As we know that we can not use derivative/lookup fields more than 20 times. If we use then we would get popup as below:
Can you please suggest solution for this?
The alternatives are to combine situations where you use multiple "Derived" fields in a rule where you could have 1 derived field. For example combine two formula fields into one formula field and then change the rule to just use that 1 field, thus saving 1 of your precious 20 rules.
Also, note that if you are using a lookup field in a rule (e.g. [Customer name] , and you could instead use the field [Related Customer], that is not a derived field as it is not a lookup nor a formula field.
Other than that, post a request in User Voice and then solicit for votes on the forum to allow more that 20 derived fields being used in forms. That limit has been there a very long time, and browsers and computers are stronger now.