Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
7 years ago

I have multiple report links displaying calendar based on a selection within a form, however, the form is very slow. Any alternatives?

I have multiple report links displaying calendar based on a selection within a form, however, the form is performing very slow. Any alternatives?
  • I'm guessing that you have lots or calendar report links on the form, perhaps dozens, so the form needs to actually calculate the results for each even though maybe they are in separate tables or hidden by form rules.

    An alternative is to have buttons on the form to flip between alternate forms (ie, Re-Display the record on a different form), and each form would have a different calendar or at least a small set of Calendars.
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      The form displays a calendar based on the case manager field (from another table) selection. The user is checking for their availability, so this means the user may click through several case managers (in which their calendar will be displayed on the form) before they save the record.
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      24 case managers, 24 report links displaying a calendar report
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    I feel like we talked about this a week ago, maybe that was somebody else...

    I'd suggest changing the report link field to use the value of the "related case manager".

    If you need it to filter by both the case manager and the record, then you can create a concatenated field that puts both values together.

    24 Report links is no bueno.
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      Yes I believe you responded to me last time. I cant seem to wrap my head around this concept.


      What fields are we concatenating? "Related case manager" &?
    • PhelanSanders's avatar
      PhelanSanders
      Qrew Assistant Captain
      This looks like it will only work only after the record is saved. I want the calendars to display for each case manager when the record is being added.