Skip to content
cc-agenda
Coda Template Subscription follow up
Share
Explore

cc-icon02
DB Subscriptions

Your second brain at work for you

info

How to proceed with subscriptions?

Hoe select a doc and data like service type and providers comes with it automatically
You can only select a doc once
You only see docs of the doc type contract recurrent
You set the first invoice date and you select how often the service is invoiced, based on that we return the next renewal date.
Next, you add the notify periods (as many as you want
Last you add the notification intervals and they relate to the renewal date.
The automation does the rest

I left a few columns in the table helping you to follow the set up and calculation. Most importantly however is the data architecture.

DB Subscriptions
0
doc
startDate
i
invoiceInterval
renewalDate
i
interval
i
units
i
noticePeriod
i
getNotified
sendNotification
i
providers
serviceType
mainMessage
i
1
240401 Google Workspace Invoice.pdf - Contract recurrent
2/26/2024
quarterly
6/30/2024
1
year
1 year
The day itself
1 day before
7 days before
15 days before
30 days before
Google
Software
Subscription for 240401 Google Workspace Invoice.pdf - Contract recurrent is scheduled for 6/30/2024, this is today.

2
240301 Coda Invoice.pdf - Contract recurrent
2/27/2023
monthly
5/27/2024
3
days
3 days
The day itself
1 day before
7 days before
14 days before
Coda
Software
Subscription for 240301 Coda Invoice.pdf - Contract recurrent is scheduled for 5/27/2024, this is today.

3
240101 Microsoft Invoice.pdf - Contract recurrent
1/3/2018
weekly
5/21/2024
1
month
1 month
The day itself
1 day before
2 days before
7 days before
14 days before
Microsoft
Software
Subscription for 240101 Microsoft Invoice.pdf - Contract recurrent is scheduled for 5/21/2024, this is today.

4
240224 Proximus invoice.pdf - Contract recurrent
8/19/2021
monthly
5/19/2024
2
weeks
2 weeks
1 day before
The day itself
7 days before
Proximus
Telecom
Subscription for 240224 Proximus invoice.pdf - Contract recurrent is scheduled for 5/19/2024, that is tomorrow.

There are no rows in this table






Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.