Discussions

Expand all | Collapse all

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

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

    Posted 05-02-2018 20:20
    I have multiple report links displaying calendar based on a selection within a form, however, the form is performing very slow. Any alternatives?


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

    Posted 05-02-2018 20:51
    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.


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

    Posted 05-02-2018 20:57
    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.


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

    Posted 05-02-2018 20:59
    How many report link fields on the form?


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

    Posted 05-02-2018 21:05
    24


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

    Posted 05-02-2018 21:05
    24 case managers, 24 report links displaying a calendar report


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

    Posted 05-02-2018 21:08
    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.


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

    Top
    Contributor
    Posted 05-03-2018 03:57
    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.


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

    Posted 05-03-2018 17:17
    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" &?


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

    Posted 05-03-2018 21:08
    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.


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

    Posted 05-03-2018 21:17
    If you want to contact me off line I can look at your app and let you know if my method will work for you.  QuickBaseCoach.com


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

    Posted 05-16-2018 15:36
    Hi, I am now revisiting this. Still no luck in deciphering your recommendation


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

    Posted 05-16-2018 15:40
    If this was directed at me, I was suggesting to contact me directly.


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

    Posted 05-16-2018 15:45
    Yes. Or by email.


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

    Posted 05-16-2018 15:45
    ok great, contact you via phone via your website?