# Please Help! Need your advise, due date on billing

**URL:** <https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630>\
**Category:** Ask for Help\
**Created:** [November 16, 2021, 11:16pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630 "2021-11-16T23:16:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![therom632](https://avatars.discourse-cdn.com/v4/letter/t/f08c70/32.png) [@therom632](https://community.glideapps.com/u/therom632)\
**Post date:** [November 16, 2021, 11:16pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630/1 "2021-11-16T23:16:56Z")

</div>

To my fellow glider’s can you give me some idea how to do this kind of project.

I’m thinking, of like a billing with monthly due date, and when the due date comes it will automatically pop up on their phone and remind them about the due date

Can you please help me.

Thank you in advance.

---

<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:** [November 16, 2021, 11:31pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630/2 "2021-11-16T23:31:06Z")

</div>

Since iOS do not support native notifications for PWAs, I think your best bet is to use Integromat to check your Google Sheet every day and send an email to the billing owner.

It goes like this:

1/Construct a billing Sheet with columns for owner’s email and due date.  
2/Add an Integromat scenario that runs 7AM every day to check that specific Sheet for days that are the same as today. Make sure it matches the date/time format.  
3/Send email(s) to the owners about the due bills.

---

<div class="post-metadata">

**Author:** ![therom632](https://avatars.discourse-cdn.com/v4/letter/t/f08c70/32.png) [@therom632](https://community.glideapps.com/u/therom632)\
**Post date:** [November 17, 2021, 1:15pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630/3 "2021-11-17T13:15:44Z")

</div>

thank you!

I will do it.

---

<div class="post-metadata">

**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\
**Post date:** [November 17, 2021, 2:22pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630/4 "2021-11-17T14:22:45Z")

</div>

What @ThinhDinh said you can do also via Googlescript (if you are using googlesheet), without using any further service. Both options are pretty the same, but if you think you will reach an high volume of emails in a month, then via googlescript you can do this for free with Integromat or similar after a while you should pay.

---

<div class="post-metadata">

**Author:** ![therom632](https://avatars.discourse-cdn.com/v4/letter/t/f08c70/32.png) [@therom632](https://community.glideapps.com/u/therom632)\
**Post date:** [November 18, 2021, 2:30pm UTC](https://community.glideapps.com/t/please-help-need-your-advise-due-date-on-billing/34630/5 "2021-11-18T14:30:49Z")

</div>

thank you @MIKAHEL. I will remember that.