# Time Base Exam/Quiz

**URL:** <https://community.glideapps.com/t/time-base-exam-quiz/62597>\
**Category:** Ask for Help\
**Created:** [June 9, 2023, 1:56pm UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597 "2023-06-09T13:56:54Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [June 9, 2023, 1:56pm UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/1 "2023-06-09T13:56:54Z")

</div>

Hi Gliders,

I need some advice and guidance or if achievable this using glide.  
Exam form with time limit.  
I use the custom action (attached screenshot) - with Wait command, but the wait notification is still showing even after I close the Overlay. Attached video.

What I want to achieve is to close the the overlay once the time limit expires (this is happening) however the Wait notification still on screen even after I close the overlay exam window., upon reevaluating the custom action, I realize that the custom action should have an If conditional before the “wait” action.

![Timed exam ss](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b921c61b6737bbefa2b274d3ff5589d45252c61.png)

---

<div class="post-metadata">

**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:** [June 9, 2023, 11:54pm UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/2 "2023-06-09T23:54:25Z")

</div>

Firstly, seems like your video isn’t playing, at least on my end.

The wait notification shows regardless of you closing the overlay or not, it’s not programmed to not show when you leave the window where the action was initiated.

I’m not sure what the “add row” action does here and why you need a set column action right after that.

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [June 10, 2023, 12:50am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/3 "2023-06-10T00:50:01Z")

</div>

Hi Thinh,

Yeah, thanks for confirmation that wait is not design that way. The add row is to let me add record if I will use command new screen (I use this instead of new form screen as the close command only with new screen action), if not it will just overwrite the current record, the set column value is to set my condional row.  
Do you know if this is achievable? Now searching if there is a loop function within glide.

I’m trying to explore another possible solution to a time quiz/exam. Can you guide me how to Add time (like 10 mins) to date/time (start time)  
I’m thinking to have a start time then add the target time as the mark to close the overlay screen. Hopefully it will work.

---

<div class="post-metadata">

**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:** [June 10, 2023, 11:50am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/4 "2023-06-10T11:50:08Z")

</div>

To add 10 minutes to a date time, use this in a math column.

`DATE+10/1440`

---

<div class="post-metadata">

**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:** [June 10, 2023, 11:14pm UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/5 "2023-06-10T23:14:03Z")

</div>

It’s easy enough, as Jeff stated above, to calculate the 10-minute mark, but I don’t believe you would be able to close the form with that approach.

I believe you can use what we call a “custom form”, set a timestamp value on entry to the form, calculate the “10-minute mark” as stated above, then don’t allow submitting when the current time is after that mark.

> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [June 11, 2023, 12:59am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/6 "2023-06-11T00:59:57Z")

</div>

Thank you so much Jeff, Im not aware with the math functions. Do we have a list or something a referrence so I can just check it myself next time. I dont find it in the documentation.

Appreciate it.

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [June 11, 2023, 1:09am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/7 "2023-06-11T01:09:13Z")

</div>

I manage to accomplish what I wanted though it is just a workaround. I just hide the questionnaire container once it hit the target time and then the user can submit it.  
At this moment it look like I cannot automatically close an overlay or form base on a target time.

Thank you so much for helping new gliders.

---

<div class="post-metadata">

**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:** [June 11, 2023, 1:19am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/8 "2023-06-11T01:19:56Z")

</div>

This is the documentation for the math column. It contains most of the mathematical functions that you can perform.

> **[Glide • Math Column](https://www.glideapps.com/docs/reference/computed-columns/math-column)**
>
> Perform instant calculations using the data in your project.

As for date math…by default Glide handles calculations in days. So in the case of adding minutes, you need to figure out how many minutes are in a day. There are 24 hours in a day, and 60 minutes in an hour, so 24\*60 is 1440 minutes in a day. 10 minutes divided by the total number of minutes in a day gives you 0.0069444, which the the fractional equivalent of 10 minutes in 1 day. That’s the number we are adding to the date to give you 10 minutes in the future.

---

<div class="post-metadata">

**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:** [June 12, 2023, 1:20am UTC](https://community.glideapps.com/t/time-base-exam-quiz/62597/9 "2023-06-12T01:20:30Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
