# Action trigger and Push notifications when a date arrive❗

**URL:** https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336
**Category:** Ask for Help
**Created:** [October 27, 2023, 12:49pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336 "2023-10-27T12:49:15Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 12:49pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/1 "2023-10-27T12:49:15Z")

</div>

Hi,

I m working on a application and on part of it is for holiday management  
So basically what I m trying to do is to receive a notification when the date arrive  
Example:

Driver name. Start date Status  
Mihai Toma 27.10.2023. Holiday

So when the Start date is today I need to receive a notification and to set column value to status Holiday to not have this driver on Active so I can have a better overview of my employees

If is any solution also I try with integromat but I don’t know how to do it.

Thanks a lot🙏🏻

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 27, 2023, 12:52pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/2 "2023-10-27T12:52:40Z")

</div>

Glide does not support time-based actions or triggers. If you have a Pro plan or better, you could do something with the Glide API and Make/Zapier.

BUT… if the only reason for the notification is so that you can log into the App and change the drivers status, why not just change the effective status automatically based on the current date?

It would be trivial with an if-then-else column.

---

<div class="post-metadata">

### Author: ![Connor\_Finlayson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/connor_finlayson/32/79079_2.png) [@Connor\_Finlayson](https://community.glideapps.com/u/Connor_Finlayson)
#### Post date: [October 27, 2023, 12:52pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/3 "2023-10-27T12:52:56Z")

</div>

This doesn’t exist at the moment, but would be great.

Alternative hack: if you are using Airtable as a source you can use Airtable automation to trigger a post request to glide.

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:22pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/4 "2023-10-27T14:22:23Z")

</div>

Ok that was working I just made it I didn’t think about this 😅  
I m still new in this I will let a photo in case someone need it  
Regarding notification it should be an alternative  
I have pro version but glide API is just for Buissines

 ![Screenshot 2023-10-27 at 16.21.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/12f9f4e929e46b7b62f6d811baff4b6b40df7276.png)

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:23pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/5 "2023-10-27T14:23:31Z")

</div>

Unfortunately all my data is on google sheet and to move now all sound complicate for me.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 27, 2023, 2:29pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/6 "2023-10-27T14:29:47Z")

</div>

The way you have that setup, when it gets to the day after the first day of their Holiday, it will return whatever is in your Status column. I’m not sure if that is what you are intending?

I would do it like this:

- If First Day Holiday is after Today, then Active
- If Last Day Holiday is before Today, then Active
- Else Holiday

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:34pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/7 "2023-10-27T14:34:48Z")

</div>

I didn’t t do it like this because I have 4 status of the drivers  
Active  
Sick  
Holiday  
Inactive

You have a better way for this?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 27, 2023, 2:38pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/8 "2023-10-27T14:38:28Z")

</div>

So would the rule be that if they are not on Holiday, then you want to use whatever is in the Status column?

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:38pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/9 "2023-10-27T14:38:53Z")

</div>

Yes exactly

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 27, 2023, 2:41pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/10 "2023-10-27T14:41:27Z")

</div>

Okay, then the following will work:

- If First Day Holiday is after Today, then Status
- If Last Day Holiday is before Today, then Status
- Else Holiday

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:44pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/11 "2023-10-27T14:44:35Z")

</div>

Great Thank you 🙏

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 27, 2023, 2:45pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/12 "2023-10-27T14:45:20Z")

</div>

Any solution for the notification?

---

<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, 2023, 4:08am UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/13 "2023-10-28T04:08:12Z")

</div>

What plan are you on at the moment? If you’re on Business/Enterprise, you can query the table at the same time everyday to check for rows that match your condition, and trigger emails as needed.

---

<div class="post-metadata">

### Author: ![Toma\_Mihai](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toma_mihai/32/61788_2.png) [@Toma\_Mihai](https://community.glideapps.com/u/Toma_Mihai)
#### Post date: [October 28, 2023, 11:10am UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/14 "2023-10-28T11:10:49Z")

</div>

I have Pro version fro the moment

---

<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 29, 2023, 1:23pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/15 "2023-10-29T13:23:02Z")

</div>

Then I don’t think there’s a way to do time-based triggers like you want. Glide mentioned at the start of 2023 that something like that might be a built-in feature in the future, but there’s no further news thus far.

---

<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: [November 5, 2023, 1:23pm UTC](https://community.glideapps.com/t/action-trigger-and-push-notifications-when-a-date-arrive/67336/16 "2023-11-05T13:23:31Z")

</div>

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