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 1 year 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 1 year ago

  • 0
  • 1
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.
How many report link fields on the form?
24 case managers, 24 report links displaying a calendar report
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,698 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.
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" &?
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.
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
If this was directed at me, I was suggesting to contact me directly.
ok great, contact you via phone via your website?
Yes. Or by email.