Let's say i have a library of questions and answer choices (for survey purpose) in mysql online accessible by a php webserver. The questions are in the following format:
id question choices
1 What is it? robot, car, table, paper
2 Who am I? Joe, Ana, Carl, Pete
....
What i would like to do is when a screen initializes, it dynamicly generates an unknown number of questions (meeting certain criteria) in the following format:
Who am I?
(radio button) Joe
(radio button) Ana
(radio button) Carl
(radio button) Pete
(a submit button)
.......
I would imagine i will need to inquire mysql database to get the entries in list with question and choices in sublists, it will also need to use the dynamiccomponent extension and radiobutton extension, but generating such dynamic components seems too much of a daunting task with a huge chunk of block in app inventor. I would think that such tasks are very common, just wonder whether there is a specific extension or sort of tool already out there for such purpose in App Inventor. Thanks!
maybe to better formulate my quesiton, the number of questions is unknown (as long as they meet the criteria) so they need to be generated dynamiclly. Though the example is somewhat relevant, it is quite different. The main difference will be dynamic generation of components. I am not sure the dynamiccomponent extension can generate radio buttons (for multiple choices).
You need some way to generate right and wrong answers to questions.
That requires some corpus of knowledge (math, geography, history, food, biology) and some way of identifying plausible alternatives.
The current reincarnation of the quiz show You Bet Your Life (no, not the Squid Games) might give you ideas for how plausible multiple choice answers would be generated.
Selection of random items from multiple lists is very straightforward.
I reiterate,
Not everything that is calculated needs to be stored.
Not everything that is stored need to be selected.
Not everything that is selected needs to be displayed.
Not everything that is displayed needs to be read.
Selection is not much of an issue, I can inquire the mysql db with certain conditions to retrieve entries. The tricky part is to display them with dynamic components (particularly radiobuttons)
Sounds a good idea to replace radiobuttons with listpicker for choices, now the cumbersome part is to display components dynamiclly. Not complete solution yet, but give you a
Aside from your firm belief that every photo needs a frame for it, there is the question of how to track the questions and answer choices in your database.
Your app sounds like your own version of Google Forms, which allows users to define their own forms and let other users enter data into those forms that would end up as rows in that Form's Google Sheet.
A Google Form is a form of schema, which you can represent in a dictionary.
the number of test questions are not certain because as long as the questions in db meet certain criteria, all questions should be retrieved. Also the number of choices for each question are not always the same (this is intentional, sorry that this is not reflected in my question, cannot edit it anymore).
