Sorry Sandy, without you willing to share your code Blocks /and or an aia file, no one is able to test your app.
Are you downloading from the sheet every time you change categories?
Here are some ideas that might get you to finish by Christmas.
- create separate apps accessing the same database for each Category rather than one single monster app..
- download the entire data base as separate csv for each category and store on the device in a TinyDB. Do that and you will not be at the mercy of downloading from the cloud. This takes time to query, download and reset your csv appropriately.
- Do you switch Screens? The app takes a while to move to another screen and that might be part of the timing problems. You might use a different way of selecting correct question answers. Here is one method How do you make a quiz in one screen? - #23 by SteveJG
Also look at another example in the discussion it links to How do you make a quiz in one screen? - #60 by SteveJG
Other community members may have other suggestions. Be careful of your timers. You do not want the timeInterval the same on all the timers to avoid 'collisions' for instance.
Merry Christmas.
Steve