Skip to main content
Question

Alternative to Form Rules

  • October 20, 2020
  • 0 replies
  • 76 views
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 need to add a few more sections.

------------------------------
Paul Peterson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Just to be clear, the limit on dynamic form rules is that it has a limit of 40 different non-scalar fields being used in form rules. By that they mean not more than 40 different fields which are either either formula Fields or look up fields.  There is no practical limit to the number of fields which can be used in form rules as long as they are scalar data entry fields and not formula or lookup fields, wich are limited to 40.  

I would suggest that the next step is to review the fields that are being used to see if you can eliminate the use of some look up fields.

For example.

If you have a relationship back to Company where the relationship is based on a field called Related Company, then the field Related Company is not to look up field. But the field Company is a lookup fields.  If you change the form rule to instead use Related Company you will save yourself one of your precious fields of the limit of those 40.

The next low hanging fruit can be to have a look at your formula fields to see if you have form rules that say depend on two or three formula fields. If that is the case perhaps you can make a new formula field that combines the calculation in those two or three fields and then you would be using one formula field which is more complicated as opposed to three different formula fields in your form rules.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+14
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
------------------------------
Terms & ConditionsAccessibility statement