Automatically Create New Rows


I am new to app sheet and would appreciate your guidance.

I am creating a app for Landlord and and have a view which shows the rent due for this month.

I want to update that page with all the properties whose rent is due this month. There is another table which shows the start date and end date of the tenancy. So what I want to achieve is that page will show me all the properties whose rent is due for this month/Week .

How can I achieve this.

Thanks for your help

The topic title appears to have no relation to your question.

Your question would be answered with slices:

Hello Steve

Thanks for your reply,

Regarding the topic do you have a relevent list of topic

From what I understand with Slice it will extract the relevant data from the current table However I want to update the table evey month with new record, will slice do that as well