with some external help, i was able to update the function and other blocks like so, along with inserting a pivot table from the original spreadsheet to reduce the amount of rows the app reads:
it loads a little quicker than normal, but now a new issue arises, and it’s loading into a different class (which is the same class screen, but displays different data). when trying to access another class after going back to the home screen, the code seems to hang for a while.
to detail the class loading issue, say i load into class 1 (er64Hz) from the home screen after logging in, and everything loads fine including the specific quickchart data. however, if i go back to the home screen, and try to load into class 2 (fg45Wg), the code just hangs and it’s stuck on the loading screen. there may be an issue with trying to load class 2’s specific data, but i’m not sure what it is.