(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.
I see a problem with how you request and process web data.
You have 6 web components, and all you do when they return a response content is to drop it into a global variable for that web component.
But let's look at how you request web data ...
You machine gun out 6 web requests, then immediately within that same event try to process data from those 6 global variables, before they had a chance to be filled from web response events.
While this is not jamming up your app, it is definitely wrong.
There will not be any data there yet in those global variables, or worse, there will be stale data from previous requests.
Processing of responseContent should be done in the web.gotText event that received the responseContent.
Looking through other event blocks, I see you are profligate
in your web requests to Google docs.
You do this regardless of how long ago you made requests of Google sheets,
Google is not eager to act as your remote data base, and they will take their own sweet time responding.
Ask yourself, do these requests pile up?
Could you have requested this data just once, and have kept it longer?
You are heavily reliant on a text box listener extension.
I don't support extensions, and can't vouch for their effects on app memory and app execution resources.
Likewise for eye candy extensions that you use for visual color flickering effects.
You have a number of these Activity Starter requests:
I am unfamiliar with forms.gle
When I tried going there with a web browser, I got a response from Firebase asking what Firebase app I wanted to run.
What mechanism does your app have to keep track of these requests, and how many of them have completed and given up their resources?
Given the language gap, I have reached my limit of helpfulness.
I open this up to others to help.
I would start with putting the app on a web request diet.
Get your six tables at startup, one at a time, asking for the next table after the previous arrives, and don't refresh them unless absolutely necessary.
I have to ask ..
Who or what wrote the web services you are invoking from the activity starter calls?
Your app reminds me of the Wizard character in the old American classic movie The Wizard of Oz.
Seemingly a great and powerful wizard, he was a hidden charlatan running a mechanical wizard prop from behind a curtain.
He himself had no wizardly powers.
Your app does no data manipulation.
(Search the Web for Dorothy Meets the Wizard)
If in doubt
Rip it out
Do not download the data from all those 6 Google spreadsheets eachl time you are looking for something
Use gviz to query the spreadsheets
and understand asynchronous processing as @ABG already mentioned
Taifun
Its too much.
thanks