# Creating a Database to Keep Quiz Results For Multiple Users **URL:** \ **Category:** Ask for Help\ **Created:** [July 15, 2023, 6:55pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953 "2023-07-15T18:55:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Tagrenine](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@Tagrenine](https://community.glideapps.com/u/Tagrenine)\ **Post date:** [July 15, 2023, 6:55pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/1 "2023-07-15T18:55:30Z")
Hi everyone, I’m currently working on an app that uses a variety of quizzes to test user content knowledge. I’d like to keep the individual quiz scores for each user in one table. Ie, John’s scores were 6 for Quiz 1, 10 for Quiz 2, and 15 for Quiz 3 while Katie’s are 17 for Quiz 1, 5 for Quiz 2, and 7 for Quiz 3. The quizzes are each their own tab. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 16, 2023, 12:06am UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/2 "2023-07-16T00:06:07Z")
You should be able to add a row to that table every time a user submits their quiz attempt, or do you have any other problems with the flow? ---
**Author:** ![Tagrenine](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@Tagrenine](https://community.glideapps.com/u/Tagrenine)\ **Post date:** [July 16, 2023, 1:40pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/3 "2023-07-16T13:40:18Z")
Hi, Thank you for your reply. I am having a problem getting the values in the row for each user. So for each “Case” there are 3 quizzes. I have the individual results of each quiz under their respective table. I want to take those individual quiz results and compile them in one table for easy reference and have it broken down by User and Quiz respectively. ---
**Author:** ![Laurent\_Maleville](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laurent_maleville/32/8643_2.png) [@Laurent\_Maleville](https://community.glideapps.com/u/Laurent_Maleville)\ **Post date:** [July 18, 2023, 1:14pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/4 "2023-07-18T13:14:34Z")
Hey @Tagrenine, Maybe you can affect the result to your user with the “user profile row” with the increment number. Then, in your data Users, you can create 3 Columns, 1 by Quizz. And Use Rollup to Sumarise the result ![Capture d’écran 2023-07-18 à 15.10.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e1cb564ff918a0c8e784207d449703e6fc11cda.png) ![Capture d’écran 2023-07-18 à 15.12.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/bae304f6472b326b193759841152cb31f0b44929.png) ---
**Author:** ![Tagrenine](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@Tagrenine](https://community.glideapps.com/u/Tagrenine)\ **Post date:** [July 18, 2023, 6:22pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/5 "2023-07-18T18:22:24Z")
This will work thank you!! The only problem I am running into is that I can’t see anyone else’s numbers unless I am viewing the data set as that user. Is there a way I can see everyone’s results? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 18, 2023, 6:38pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/6 "2023-07-18T18:38:30Z")
Turn off row owners in the table that contains those numbers. ---
**Author:** ![Tagrenine](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@Tagrenine](https://community.glideapps.com/u/Tagrenine)\ **Post date:** [July 18, 2023, 6:41pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/7 "2023-07-18T18:41:50Z")
Thank you so much! ---
**Author:** ![Laurent\_Maleville](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laurent_maleville/32/8643_2.png) [@Laurent\_Maleville](https://community.glideapps.com/u/Laurent_Maleville)\ **Post date:** [July 18, 2023, 7:26pm UTC](https://community.glideapps.com/t/creating-a-database-to-keep-quiz-results-for-multiple-users/63953/8 "2023-07-18T19:26:55Z")
Yes, delete the row owners and you can see all results See you