I've made a rather complicated app (a trivia game) for my family to enjoy (not for commercial application). My test data at first was incorporated into the app (6 categories, 4 questions each). I wanted to add more Q&As but didn't want to do it the hard way by adding one line at a time within the app for the answers (in csv format). I was very successful in getting the questions properly imported to the app and then I did get the answers to finally work the way I wanted them to work (my program randomizes the questions so the correct answer is not always in the first button choice.
After that success, I felt confident to add the rest of the Q&As (still only 6 categories and 4 answers each) to import them from Google Sheets. It worked perfectly. Now, however, it suddenly will load all the questions from all 6 categories, but randomly only upload some of the answers (6 files for questions, 6 files for answers). It'll work one time for 5 out of the 6 and I'll run it again and it'll pick up only 4 out of the 5 answers. The questions work every time so I know it is reading the files correctly.
I thought it was a problem with too much too fast so I tried putting in some timers to slow down the import. That worked once, but again the random importing of answers started again. Can anyone help with this? Is this a bug that needs to be fixed? I ensured that I am up-to-date on API2 (Oct 19, 2022, version nb190b, and I am using Companion Version 2.65). Why does it work one time for 5 or 4 out of 6 categories but then not work for a category that was working and stop pulling data for another that was just working?
I'm pulling my hair out--I was really hoping I could have this app ready for us to all play for Christmas. We always play games but my oldest son is autistic and he doesn't really play the ones his brothers and I play so I created this app to quiz on all the categories he loves (everything Hollywood, movies, TV, etc.). HELP PLEASE!! I'd REALLY appreciate it, thanks!