Skip to content
Gallery
cc-agenda
Coda Template Subscription follow up
About this template
DB Subscriptions
DB Docs
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
DB Subscriptions
⁠
helping you to follow the set up and calculation. Most importantly however is the data architecture.

DB Subscriptions
doc
startDate
i
invoiceInterval
renewalDate
i
interval
i
units
i
noticePeriod
i
getNotified
sendNotification
i
providers
serviceType
mainMessage
i
2/26/2024
9/30/2025
1 year
Google
Subscription for 240401 Google Workspace Invoice.pdf - Contract recurrent is scheduled for 9/30/2025, this is today.

2/27/2023
8/27/2025
3 days
Coda
Subscription for 240301 Coda Invoice.pdf - Contract recurrent is scheduled for 8/27/2025, this is today.

1/3/2018
8/18/2025
1 month
Microsoft
Subscription for 240101 Microsoft Invoice.pdf - Contract recurrent is scheduled for 8/18/2025, this is today.

8/19/2021
8/19/2025
2 weeks
Proximus
Subscription for 240224 Proximus invoice.pdf - Contract recurrent is scheduled for 8/19/2025, 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.