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

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Acknowledged
I have multiple report links displaying calendar based on a selection within a form, however, the form is performing very slow. Any alternatives?
Photo of Steph Curry with the Base

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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.
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
How many report link fields on the form?
24 case managers, 24 report links displaying a calendar report
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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
Hi, I am now revisiting this. Still no luck in deciphering your recommendation
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
If this was directed at me, I was suggesting to contact me directly.
ok great, contact you via phone via your website?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
Yes. Or by email.