# Daily Quiz App

**URL:** <https://community.glideapps.com/t/daily-quiz-app/2471>\
**Category:** Project Showcase\
**Created:** [November 28, 2019, 7:41am UTC](https://community.glideapps.com/t/daily-quiz-app/2471 "2019-11-28T07:41:16Z")\
**Posts on this page:** 1\
**Showing post:** 30

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [June 16, 2020, 4:27pm UTC](https://community.glideapps.com/t/daily-quiz-app/2471/30 "2020-06-16T16:27:30Z")

</div>

Hi, I come back with my pending issue of “recurring challenges” for kids at school (for which I had fruitful exchanges with @Robert_Petitto @ThinhDinh @Jeff_Hager).

The objective: display daily a calendar with the challenge of the day, per kid  
(requires several columns to be “user specific”).

The approach: upfront, the user sets it up by:  
1/ selecting the challenges he is interested in \>\> done in DataEditor with a “check” | “user specific” column  
2/ defining the recurrence per challenge (ex. each 1, 2, 3 days) \>\> done in DataEditor with a “nb” | “user specific” column  
3/ setting a start-date \>\> done in DataEditor with a “date” | “user specific” column

**4/ calculate if the challenge is to be displayed according to the frequency & starting date** \>\> I ‘found’ a formula for GSheet, but it’s much beyond my newbie skills to build it in DataEditor, which is required since its again a “user specific” date: (=IF(C6\>TODAY();0;IF(MOD(TODAY()-C6;B6)=0;1;0)))

Summarized illustration: [https://docs.google.com/spreadsheets/d/1sf8QcoBf9iK0sVSkWJbjx3FAECj1-pwlAT7soWYmRq4/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1sf8QcoBf9iK0sVSkWJbjx3FAECj1-pwlAT7soWYmRq4/edit?usp=sharing)

Many thanks in advance if you know how to write this formula in Glide!  
Cheers

---

_[View the full topic](https://community.glideapps.com/t/daily-quiz-app/2471)._
