Only get alerts when you want them
We all deal with important dates we don’t want to forget, but also dates we don’t want to put in our calendar. For example the dates your subscriptions are renewed. In this blog I show a few basics on how to make an automation work for you.
The context
We have a table referencing docs representing subscriptions, their starting date the invoicing logic (each week, month, etc) and we can define the logic we want receive a notification. It looks like below and the essential info is in the column ‘getNotified’.
As you can see the user selects per contract how often and when she wants to receive un update. In this blog we assume that the renewal date is self evident and thus we have a reference we can relate to.
The list of dates
We start with the generation of dates and that is based on values living in the table we reference.
