Forum Discussion

PhelanSanders's avatar
PhelanSanders
Qrew Assistant Captain
8 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?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
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
    8 years ago
    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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    How many report link fields on the form?
  • PhelanSanders's avatar
    PhelanSanders
    Qrew Assistant Captain
    8 years ago
    24 case managers, 24 report links displaying a calendar report
  • PhelanSanders's avatar
    PhelanSanders
    Qrew Assistant Captain
    8 years ago
    24
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Ya, so it�s runing 24 reports.

    It would be nice to have dynamic filters on Calendar reports.

    If the problem is important enough for you to solve, I do have an alternative. I would have to work with you to set this up it would probably take an hour and a half of consulting time to get it working but the user would be able to click on a case manager and have the form ready display with just one report link field for the focus case manager.