Discussions

 View Only
  • 1.  Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:32
    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.


  • 2.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:44
    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.


  • 3.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:47
    The Case manager is a parent table (Dropdown selection). 


  • 4.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:48
    The user updating this form is not the Case Manager in which they select.


  • 5.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:50
    Use [Related Case Manager] instead of Case Manager.  That is not a derived field.


  • 6.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:46
    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.


  • 7.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:58
    Wow, this works! I needed to use the "Related Case Manager" in my rules. Awesome, thanks


  • 8.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 04-24-2018 20:48
    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.


  • 9.  RE: Form Rule Limitation Workaround - (Report Link)

    Posted 09-25-2018 21:45
    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.