# Database for a quiz app **URL:** \ **Category:** Ask for Help\ **Created:** [August 22, 2021, 9:44am UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782 "2021-08-22T09:44:10Z")\ **Posts on this page:** 13\ **Page:** 2
**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:** [August 27, 2021, 6:42pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/24 "2021-08-27T18:42:14Z")
I don’t have a lot of free time to create an app from scratch to show with screenshots. Where in my description are you stuck? ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 6:52pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/25 "2021-08-27T18:52:29Z")
Then create an IF column that will compare that completed question count for the level and compare it to the number 5. If the rollup count equals 5 then return ‘true’. Then you can create a custom action on the level list that contains an If statement and will check that IF column value in the table to see if its ‘true’. If it’s true then the level is complete and you can show a notification. Else you can have an action to Show the Details screen of that level. ---
**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:** [August 27, 2021, 7:00pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/26 "2021-08-27T19:00:07Z")
Did you create an IF column that checks if the rollup column value equals 5? ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 7:05pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/27 "2021-08-27T19:05:03Z")
yes. @Jeff_Hager like this know ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a810bc40ed05a27215050f287bb37058356b90a9.png) ---
**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:** [August 27, 2021, 7:07pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/28 "2021-08-27T19:07:53Z")
yes, but type in ‘true’ the THEN spot. For the ELSE, you can leave it blank or type in ‘false’ if you want. Now if the count is equal to 5, it will return ‘true’, so you will know that the level is complete. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 7:09pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/29 "2021-08-27T19:09:51Z")
Ah ok. I created the column ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 7:17pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/30 "2021-08-27T19:17:22Z")
@Jeff_Hager Then what should I have to do? ---
**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:** [August 27, 2021, 7:18pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/31 "2021-08-27T19:18:58Z")
The next step. Create a custom action on the Level list. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 7:24pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/32 "2021-08-27T19:24:50Z")
I have to create that IF column in questions sheet know? Sorry for disturbing you @Jeff_Hager . ---
**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:** [August 27, 2021, 7:27pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/33 "2021-08-27T19:27:38Z")
No, you create a custom action, like I specified above, on the Levels list. > **[Custom Actions](https://docs.glideapps.com/all/reference/actions/custom-actions)** > > Build multi-step actions and workflows ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 27, 2021, 7:38pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/34 "2021-08-27T19:38:06Z")
@Jeff_Hager can you tell me what has to be included in the custom action? ---
**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:** [August 27, 2021, 7:44pm UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/35 "2021-08-27T19:44:57Z")
An IF condition that checks if the IF column you created in the Levels sheet is ‘true’. On the true branch add a notification action that says the level is complete. On the Else branch, add an action that shows the details screen of the level. Did you go through the documentation on custom actions…especially the Conditions section? It’s up to you what you want to happen when you select a level, but based on your description, this is what I would suggest. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 7, 2021, 5:06am UTC](https://community.glideapps.com/t/database-for-a-quiz-app/30782/38 "2021-12-07T05:06:45Z")
Closed on December 7, 2021, 5:06am UTC This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/database-for-a-quiz-app/30782.md?page=1)