Skip to main content
Question

Form Rule Limitation Workaround - (Report Link)

  • April 25, 2018
  • 0 replies
  • 24 views
Forum|alt.badge.img+7
I have over 20 something calendar report links embedded in a form. These are show/hide based on the selection of a case manager (from a table).

Upon saving the form rules, I get an error message saying that i cannot have more than 20 rules on a derived field.

Is there a workaround for this? I would like to display a calendar report for each individual.
    This topic has been closed for replies.

    • MCFNeil
    • Quickbase Alumni
    • April 25, 2018
    If the 'Case Manager' is a user field... I'd suggest just making the report show the data that is filtered where case manager = current user.  

    Then you won't have to have any form rules.
    A derived field is any lookup or formula field.  The only work a around is to examine your form rules to see if they can be based on fields other than lookup or formula fields.

    For example the field  [Related Parent] is not a lookup field and hence is not a derived field, but the field [Parent (lookup)] would be a derived field.
    • MCFNeil
    • Quickbase Alumni
    • April 25, 2018
    If you are trying to make it work no matter the user.  I'd recommend modifying the report link itself.

    You can make a concatenated field that has 'Related Parent' AND 'Related Case Manager' together, then have the same concatenation on the child table, and boom.  Pre filtered for parent and case manager.
    btw,
    In User Voice Quick base is telling us that they are planning to give us 40 Derived fields as a limit quite soon. So double. 

    If you need more than 40 derived fields, then your head will probably explode anyways trying to keep track of the monster you have created.
    Terms & ConditionsAccessibility statement