# Invoice Alert

**URL:** <https://community.glideapps.com/t/invoice-alert/63238>\
**Category:** Ask for Help\
**Created:** [June 28, 2023, 3:28am UTC](https://community.glideapps.com/t/invoice-alert/63238 "2023-06-28T03:28:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [June 28, 2023, 3:28am UTC](https://community.glideapps.com/t/invoice-alert/63238/1 "2023-06-28T03:28:23Z")

</div>

I have one glide table which have Rental Data :  
{ Start Date, End Date, Machine ID, Rental Type, Rental Rate }

i also need another one table which consist the accounts details :  
{ Machine ID, Invoice Due Date, Invoice Amount }

I want it to be triggered each day from Rental table to Account table so that Account department will be more alert to invoice each job.

Let say  
Machine 1 rental from 1/5/2023 - 1/7/2023 on Monthly basis (Rental type) with RM500/month

So, the invoices should come out as of today on Account table is:  
Machine 1 | 1/5/2023 | Rm500  
Machine 1 | 1/6/2023 | Rm500

the july one shouldn’t come out yet since today just 28/6/2023 only.

Actually, currently we are using Apps Script. but i decide don’t want to use Apps Script .

Is there any ways to do ?

---

<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:** [June 28, 2023, 3:33am UTC](https://community.glideapps.com/t/invoice-alert/63238/2 "2023-06-28T03:33:09Z")

</div>

No, not really - not with Glide only. Maybe later this year if Glide give us the ability to to time-based automations.

For now, your Apps Script solution is as good as any.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [June 28, 2023, 3:37am UTC](https://community.glideapps.com/t/invoice-alert/63238/3 "2023-06-28T03:37:53Z")

</div>

> [@Darren\_Murphy](#):
>
> Maybe later this year

Can i know when is your estimation date ?

---

<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:** [June 28, 2023, 3:40am UTC](https://community.glideapps.com/t/invoice-alert/63238/4 "2023-06-28T03:40:25Z")

</div>

Nope, I have no idea. I don’t even know if it’s even planned/confirmed. All I know is that Glide said they might provide more powerful actions later this year. That might have all changed by now. That’s why I said “maybe” 😉

---

<div class="post-metadata">

**Author:** ![SamSC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/samsc/32/46936_2.png) [@SamSC](https://community.glideapps.com/u/SamSC)\
**Post date:** [June 28, 2023, 7:52am UTC](https://community.glideapps.com/t/invoice-alert/63238/5 "2023-06-28T07:52:53Z")

</div>

If you are willing to use external software, I recommend the business plan and [Make.com](http://Make.com) for your project. An automation could download your table every day and process all matching records (date = today), then after your action you delete the processed records from the table that is processed every day.

If you are interested, please write me and we will find a solution together.

Best regards,

Sam