# Best way to show attendance

**URL:** <https://the.fmsoup.org/t/best-way-to-show-attendance/2567>\
**Category:** Questions\
**Tags:** crashing, education-sector\
**Created:** [November 11, 2021, 12:23am UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567 "2021-11-11T00:23:20Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![JasonMark](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@JasonMark](https://the.fmsoup.org/u/JasonMark)\
**Post date:** [November 11, 2021, 12:23am UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/1 "2021-11-11T00:23:20Z")

</div>

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.

Processing: sample.html...  
[sample.html.zip](https://the.fmsoup.org/uploads/short-url/6v7lvDcsKYZCCuVg3M9o8yQ8w71.zip) (2.2 KB)

![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/2/22990bc4e4f653c3d1f9cd8ae087c83c54433c5c.png)

---

<div class="post-metadata">

**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\
**Post date:** [November 11, 2021, 3:35am UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/2 "2021-11-11T03:35:18Z")

</div>

if you remove the webviewers from the layout, does FM stop crashing?

---

<div class="post-metadata">

**Author:** ![planteg](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/planteg/32/627_2.png) [@planteg](https://the.fmsoup.org/u/planteg)\
**Post date:** [November 11, 2021, 4:24am UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/3 "2021-11-11T04:24:59Z")

</div>

What is the version of FMP/FMPA ? Until very recently FileMaker was using Internet Explorer technology to implement WebViewers, incompatible with recent JavaScript. Then, if my memory serves me well, this spring FMP 19 had an update which use (Chromium) Edge to implement WebViewers. That may explain your issues.

---

<div class="post-metadata">

**Author:** ![JasonMark](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@JasonMark](https://the.fmsoup.org/u/JasonMark)\
**Post date:** [November 11, 2021, 2:37pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/4 "2021-11-11T14:37:27Z")

</div>

Sorry should have posted... fully patched, not the old IE:

**Technical details**  
Server: Windows 19.3.2.203 hosted with [fmphost.com](http://fmphost.com)  
Mac client (which has no problems): 19.3.2.206  
Windows clients (which don't work): 19.3.2.206

---

<div class="post-metadata">

**Author:** ![JasonMark](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@JasonMark](https://the.fmsoup.org/u/JasonMark)\
**Post date:** [November 11, 2021, 2:45pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/5 "2021-11-11T14:45:17Z")

</div>

Here's things I tried:

- Changed web viewer to just be - "hi" as above - still crashes
- Created a new layout, and copy-pasted EVERYTHING into it - worked at first, but stopped working a few days later.
- Removed web viewer - doesn't crash
- Added a new web viewer with default thing in it (Google Maps?)- doesn't crash at first
- Changed that to my code - crashes

Again ALL these work fine on Mac, it's only a Windows issue.

---

<div class="post-metadata">

**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\
**Post date:** [November 11, 2021, 8:58pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/6 "2021-11-11T20:58:27Z")

</div>

Since your "hi" webviewer crashes FM too, it sounds like something out of your control. Maybe it's a memory leak in FM's implementation of the new Webviewer. I believe Claris is close to releasing a new FMP version, so you could try that version soon to see if it's resolved the issue.

Otherwise I like your idea of using a schedule to save an image of the webviewer or maybe ditch the webviewer altogether for the sake of stability.

---

<div class="post-metadata">

**Author:** ![JasonMark](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@JasonMark](https://the.fmsoup.org/u/JasonMark)\
**Post date:** [November 11, 2021, 10:22pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/7 "2021-11-11T22:22:42Z")

</div>

Good advice. I think I'll wait for the new version and see if it makes it better instead of banging my head against it more.

---

<div class="post-metadata">

**Author:** ![KyleWilliams](https://avatars.discourse-cdn.com/v4/letter/k/ecccb3/32.png) [@KyleWilliams](https://the.fmsoup.org/u/KyleWilliams)\
**Post date:** [November 13, 2021, 8:32pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/8 "2021-11-13T20:32:19Z")

</div>

My suggestion would be to simplify he html. You should be able to utilize a table and CSS to accomplish this. Some prebuilt JavaScript libraries may not work well in all browsers which I’m guessing might be the issue?

Instead of storing all of the HTML code, only store the data. You can load the data into the web viewer in a couple different ways. One way is to use the data to have your scripts generate the HTML. Another way is to create some custom JavaScript to create the table after the web viewer has loaded. Storing the data in JSON format would be ideal with either method.

PS: You could try using card windows instead of popover windows. On Windows, there is an object layering issue where the webviewer is always the topmost object. While on a Mac this is not an issue, on Windows, it has always been an issue. popover windows can get stuck behind the webviewer on Windows PCs. There are many tricks to positioning the card window to have it mimic a popover window.

---

<div class="post-metadata">

**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\
**Post date:** [November 13, 2021, 10:10pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/9 "2021-11-13T22:10:46Z")

</div>

> [@JasonMark](#):
>
> 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.

Simpler than just "hi"?

---

<div class="post-metadata">

**Author:** ![JasonMark](https://avatars.discourse-cdn.com/v4/letter/j/a9adbd/32.png) [@JasonMark](https://the.fmsoup.org/u/JasonMark)\
**Post date:** [November 13, 2021, 10:25pm UTC](https://the.fmsoup.org/t/best-way-to-show-attendance/2567/10 "2021-11-13T22:25:22Z")

</div>

Well technically it's "hi" so it's a _little_ more complicated than "hi"... but yeah I don't think I can get much more simple.

Interestingly the repeating popover in the body of the list work fine, but the two popover buttons in the header crash.

I think just waiting for the latest Windows version of FMP to come out makes the most sense. Seem like definitely a memory problem in Filemaker...
