Form Rule Limitation Workaround - (Report Link)

Question

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.

mcfneil · Answer

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.&nbsp;&nbsp;Then you won't have to have any form rules.

quickbasecoachd · Answer

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.

phelansanders · Answer

The Case manager is a parent table (Dropdown selection).&nbsp;

phelansanders · Answer

The user updating this form is not the Case Manager in which they select.

mcfneil · Answer

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.

Forum Discussion

Form Rule Limitation Workaround - (Report Link)

Related Content

Calculation/Performance Limits Inquiry

Restful API Report digesting JSON

Workaround for Mobile limitation?

Summary Reports

embedded reports