Add New Row automatically to the Table

[Landlord_Buddy]

Hello

I want to automatically update the table.

I am creating a app for landlord.

There is a table which has a start date and end date for the tenancy.

The rent is due every monthly or weekly. I want to update the rent due table every month so that all the properties whose rent is due that month is shown on the view. How can I achieve this

Many thanks for your help