Alternative to Form Rules
Is there an alternative to form rules to hide/show sections of a form. Alternatively, is there a way to put one form inside another form. I have reached the limit of 40 fields in the form rules and ...
Forum Discussion
The suggestions from Blake and Mark sound much cleaner, but if you must use dynamic rules, instead of having 25 formulas, one for each section, just have one long formula that says "if these conditions are true, "Show Section 1", if these conditions are true, "Show Section 2"....
Then in your form rules you just say, "If [Long Formula] = Show Section 1......"
I believe this means you are only using 1 of your 40 field limit (I'm assuming multiple instances of the same formula only count as 1 of your 40, if this isn't true then this wont work...)
------------------------------
Mike Tamoush
------------------------------
Then in your form rules you just say, "If [Long Formula] = Show Section 1......"
I believe this means you are only using 1 of your 40 field limit (I'm assuming multiple instances of the same formula only count as 1 of your 40, if this isn't true then this wont work...)
------------------------------
Mike Tamoush
------------------------------
Mike,
I think your suggestion may be the closest to handling this situation. I could do most of what I need accomplish without relying on scalar fields. Thank you. I'm tied up on other parts of the app for today, but will revisit this in the morning. I'll let you know the results.
------------------------------
Paul Peterson
------------------------------
I think your suggestion may be the closest to handling this situation. I could do most of what I need accomplish without relying on scalar fields. Thank you. I'm tied up on other parts of the app for today, but will revisit this in the morning. I'll let you know the results.
------------------------------
Paul Peterson
------------------------------
- Mike,
I finally had a chance to try your suggestion and quickly remembered why I didn't use that method. I had tried that approach first but there is one simple reason that it will not work. You will get a warning if more than 1 trigger tries to modify the same field. The same section would appear in multiple categories.
I'm using what Mark stated in the first reply to this post and working to restructure the form rules while minimizing the number of formula and lookup fields.
Thank all of you for your ideas and suggestions!
------------------------------
Paul Peterson
------------------------------- If the same section is to be hidden in multiple instances, then you have two choices, take care of that with the long formula, or take care of it with dynamic rules.
In the long formula, you would write it so every instance that you would want section 1 to be hidden, is accounted for. If this happens, or that happens, or that happens, or that happens = "Hide Section 1"....etc
Or, you would need that all in one dynamic form rule. So think about everything that could hide section one, and use the multiple conditions selection in dynamic form rules. For example:
If any of the following conditions are true:
[Long Formula] = X
[Long Formula] = Y
[Long Formula] = Z
Action
Hide Section 1
------------------------------
Mike Tamoush
------------------------------Mike,
Without digging up my old Linear Algebra textbook (the thought of that makes me want to hide under my desk in the fetal position) I don't believe this can be reduced to one formula. There are currently 26 categories and each of those categories will need to show/hide 1 to 23 sections. Several of the categories will use a section that is used in another category. The numbers will increase in the near future and are not likely to remain static for long. The current state has almost 600 permutations and I don't see this approach being very maintainable going forward.
------------------------------
Paul Peterson
------------------------------