# Schedule

**URL:** <https://community.glideapps.com/t/schedule/33706>\
**Category:** Ask for Help\
**Created:** [October 28, 2021, 8:08pm UTC](https://community.glideapps.com/t/schedule/33706 "2021-10-28T20:08:06Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 8:08pm UTC](https://community.glideapps.com/t/schedule/33706/1 "2021-10-28T20:08:06Z")

</div>

Hello! I hope you are super well, I come here to see if what I have in mind can be done, look at I have a list where the user writes down data, so I want that list to have a limit of information entry, for example 5 minutes before the user does not I let you write down more information

Eg In the first photo you can see the schedule  
In the second photo you can see the current time of my country so that is to say that time has passed so I do not want people to be seen I do not know if I explain myself, what I want is when it is 5 minutes before the time so no can edit the person more Is that possible here in glide

![dsads](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d5c785e017760b0bbde884d43b666e3b0c7a411.png)  
 ![dsawwa](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd742dbd9ba97f67f83cac11d0ce0c41dbd0beb1.png)

---

<div class="post-metadata">

**Author:** ![JuanM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juanm/32/33666_2.png) [@JuanM](https://community.glideapps.com/u/JuanM)\
**Post date:** [October 28, 2021, 10:04pm UTC](https://community.glideapps.com/t/schedule/33706/2 "2021-10-28T22:04:24Z")

</div>

it occurs to me to play with this plugin and condition the edit

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f47534486aa927f51df1ae5392607b7bbc36488.png)

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 10:20pm UTC](https://community.glideapps.com/t/schedule/33706/3 "2021-10-28T22:20:06Z")

</div>

Ohh it might be a good solution but how would I implement it to my glide? with experimental code?

---

<div class="post-metadata">

**Author:** ![JuanM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juanm/32/33666_2.png) [@JuanM](https://community.glideapps.com/u/JuanM)\
**Post date:** [October 28, 2021, 10:40pm UTC](https://community.glideapps.com/t/schedule/33706/4 "2021-10-28T22:40:29Z")

</div>

Yes in experimental column. the steps go!

1.- Copy the link of the plugin and paste it in that column  
2.- In Data, select the column where you have the initial date registered  
3.- In Now, you select a mathematical column showing the now  
4.- In style, you write round

and ready

you only create an if with the condition you want

---

<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:** [October 28, 2021, 11:02pm UTC](https://community.glideapps.com/t/schedule/33706/5 "2021-10-28T23:02:00Z")

</div>

Create a math column and minus 5 minutes from the starting time, let’s call it “Locked time”. The formula will be something like:

S - 5/60/24

Then don’t allow editing when “Locked time” is on or after now.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:09pm UTC](https://community.glideapps.com/t/schedule/33706/6 "2021-10-28T23:09:04Z")

</div>

Apply the formula you told me but I don’t understand what those 663 are due to. Are they minutes?  
 ![Captura](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb006a26e66380621fd76d7559fdcc70d9eb106d.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:** [October 28, 2021, 11:16pm UTC](https://community.glideapps.com/t/schedule/33706/7 "2021-10-28T23:16:41Z")

</div>

What type of data do you have for the starting time?

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:19pm UTC](https://community.glideapps.com/t/schedule/33706/8 "2021-10-28T23:19:37Z")

</div>

It is that for example I will show you what it is like when it is 7:25 pm so that I no longer let it edit, then that is daily but what I want to achieve now is that 5 minutes before that time it does not allow it to edit the spreadsheet this in colombian time then, would you be taking the colombian timetables?

![Captura](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bf076a4d83f4a502f33986b1894bfbae5b14a36.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:** [October 28, 2021, 11:27pm UTC](https://community.glideapps.com/t/schedule/33706/9 "2021-10-28T23:27:11Z")

</div>

So are all the times you have in the same timezone? Do you have the date attached with each starting and ending time or do you only have the time only?

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:30pm UTC](https://community.glideapps.com/t/schedule/33706/10 "2021-10-28T23:30:37Z")

</div>

Exactly I have each date attached with the final start time something like this looks in google sheet

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:31pm UTC](https://community.glideapps.com/t/schedule/33706/11 "2021-10-28T23:31:28Z")

</div>

Then when it is 5 minutes before the start time that the user cannot edit the list that I have that is for editing

---

<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:** [October 28, 2021, 11:31pm UTC](https://community.glideapps.com/t/schedule/33706/12 "2021-10-28T23:31:34Z")

</div>

Can you show me how you’re setting your data up in Glide Tables? I assume you already did the math column as I said via your screenshot?

If you have the right data type for starting time, which has both date & time, then I believe it will work.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:34pm UTC](https://community.glideapps.com/t/schedule/33706/13 "2021-10-28T23:34:20Z")

</div>

> [@ThinhDinh](#):
>
> If you have the right data type for starting time, which has both date & time, then I believe it will work.

Of course I did the steps as indicated

![sdfs](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b6dcb374aa6285b47c2a960ca59d7f86f02f704.png)  
 ![dfsefsdd](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e5c3a72032e51f8dd6bcecb7b4b96fb1536531f.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:** [October 28, 2021, 11:34pm UTC](https://community.glideapps.com/t/schedule/33706/14 "2021-10-28T23:34:59Z")

</div>

But your Inicio column is time only, and is in text?

Do you have a column that contains both the date & time? That’s what I was asking for.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:38pm UTC](https://community.glideapps.com/t/schedule/33706/15 "2021-10-28T23:38:27Z")

</div>

Oh I had not understood what you mean but of course there is a part of the date, start, finish but it appears in text because when I put the date and only the time it is as if the function did not work

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:39pm UTC](https://community.glideapps.com/t/schedule/33706/16 "2021-10-28T23:39:54Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0f2cb0ddd7a46ba642d490872d7f1e504bcc5be.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:** [October 28, 2021, 11:42pm UTC](https://community.glideapps.com/t/schedule/33706/17 "2021-10-28T23:42:48Z")

</div>

Is there a reason you don’t store them together but dividing them into date only and time only, in Google Sheet columns?

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:43pm UTC](https://community.glideapps.com/t/schedule/33706/18 "2021-10-28T23:43:42Z")

</div>

That is separated more than anything by order but what do you recommend that this all together?

---

<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:** [October 28, 2021, 11:44pm UTC](https://community.glideapps.com/t/schedule/33706/19 "2021-10-28T23:44:59Z")

</div>

What do you mean “by order”? Like how are you inputting the data in there? I would suggest keeping them together because later on you can use Glide’s computed columns to display just parts of it for displaying purposes.

---

<div class="post-metadata">

**Author:** ![CARLOS1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos1/32/86364_2.png) [@CARLOS1](https://community.glideapps.com/u/CARLOS1)\
**Post date:** [October 28, 2021, 11:56pm UTC](https://community.glideapps.com/t/schedule/33706/20 "2021-10-28T23:56:32Z")

</div>

Wow entiendo pero en este momento puedo hacerlo como usteded me dice para limitar esa edicion 5 minutos antes de la hora?

[Next page](https://community.glideapps.com/t/schedule/33706.md?page=2)
