Form Rule Limitation Workaround - (Report Link)

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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.
Photo of Steph Curry with the Base

Posted 7 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
The Case manager is a parent table (Dropdown selection). 
The user updating this form is not the Case Manager in which they select.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,466 Points 50k badge 2x thumb
Use [Related Case Manager] instead of Case Manager.  That is not a derived field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Wow, this works! I needed to use the "Related Case Manager" in my rules. Awesome, thanks
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.