I'm working on the school database. We have a counseling team who works with a list of about 60 students per team, and every day they go through the list of students and look at things like attendance. I originally did the attendance as repeating boxes with some complex calculations, but it got VERY slow, even when cached, and had to basically recreate it on every screen, so instead I turned it into a web portal and every night I cache prior attendance in a field as pre-written HTML so all we have to do is put a web portal on the screen and bob's your uncle (see screenshot below).
It's much faster and much more flexible, which is good because the schedule changed and some students have half-block classes which couldn't be represented before.
This works sparklingly on Macs, but on Windows when this web portal is on the screen popovers hard crash Filemaker (doing too many resources I imagine).
What ideas do people have for making this smoother? The options that come to mind for me are:
- Turn the entire list view into a single HTML portal (gulp but maybe the best option)
- Leave it as is, and don't use popovers (this is not ideal, but certainly preferable to having the report screen have less data for the staff to work with)
- Go back to using some sort of repeating fields to dynamically draw the attendance within Filemaker
- Maybe find something where I can run a routine nightly which basically snapshots the attendance as an image and stores it in a container field and display it that way. This seems convoluted, but maybe?
Other thoughts or ideas?
NOTE: I actually simplified the HTML portal to be "hi" and it still crashed, but I included the HTML file that I want to run there in case someone wants to see it.