Invoice Alert

Ask for Help
1

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 ?

2

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.

3

Can i know when is your estimation date ?

4

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” :wink:

1 Like
5

If you are willing to use external software, I recommend the business plan and 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

1 Like