Creating a Challenge app for kids to find 108 examples of 10 tasks

Hi there, I am very new to this, although I have some experience adjusting websites in Joomla, so am not a complete novice to online backends.
I want Users of the app to be able to click on each of the 10 tasks and list 108 different answers to the task questions. Eg. Spot 108 different creatures.
So basically I want them to add to a vertical list of 108 numbered fields/rows where they can write in a different creature on each row. There are 10 different tasks, so they need to be able to type in unique item answers to each row/field of each task (although they may write the same item more than once in some tasks). The 108 rows could be fixed on the page already, or each numbered item could manifest as the User adds the next answer/finding. How do I do this?? Do I have to make 108 columns in the data table?? Thanks for any help!

Do you need to validate that afterwards?

As an admin, do you need to see each userā€™s answers?

Do you plan to have a leaderboard if you validate and give points?

There will be no wrong answers. Itā€™s all about getting people (kids and adults) to be aware of their surroundings. It would be interesting to see everyoneā€™s answers but Iā€™m not sure if that wouldnā€™t be a Data Protection issue (Iā€™m in the UK).

Initially, we were just going to make Excel/Word worksheets for participants to print out and use with a clipboard (very old school) but then thought an online way would be better and found GlideApps could be a way for people to record and count their answers.

Iā€™ll have to check with my team colleagues about whether the answers should be: a) only visible to the User; b) visible to the User and to us as Admin; or c) visible to everyone using the app.

Perhaps when they reach 108 there can be a ā€œCongratulations!ā€ message and when theyā€™ve completed all 10 Tasks another ā€œCongratulations!ā€ and we (Admins) get notified that someone finished.

You should record each answer in a new row, with the user id or emailā€¦ make user email as a row owner if you wanna protect data. Then count answer for each user, if reach 108 send notification.

Where do I make these rows? In a new table or is there a component I can use?

How do I make it so that each Task has its own set of 108 rows and then each User can put their own answers in each row?

Yes, open a new table for answers, with columns:

  1. User ID (email)
  2. Task ID
  3. Answer
  4. Other columns like timestamp, ratingā€¦

You need two other tables:

  1. Users table with Users IDs
  2. Task table with task IDs
1 Like

Ok, thanks. Where do I put 108 rows? Do I use the ā€˜Notesā€™ component? I tried ā€˜Fieldsā€™ but it doesnā€™t look right. But I donā€™t really know what Iā€™m doing!

Noā€¦ use an inline list that will populate tasks from the task tableā€¦ and in the detail view, have a text entry component based on the user-specific column to collect answersā€¦ plus a button to add a new row in the answers tableā€¦
Then, create relations between the task table and the answer table to see which task is answeredā€¦
In the answer table, add an IF-ELSE column to check if the User ID is the signed-in user and return the task IDā€¦ you will use that column for relation.

I will have a go and see if I understand your instructions. Thank you.

1 Like