Column created every month automatically

Landlord_Buddy · 02-28-2021 01:09 AM

I want some rows created automatically in a table.

There is a table A which has Start Date and End Date.

In table I want to create some rows automatically on the first of every month.

This is then showed in the view

MultiTech

You’ll want to check out Behavior>Reports - or alternatively the new Automation panel.

Landlord_Buddy

Hello

I do not want a report I want to add the row in the table so can see in the view and when it is completed can mark it

MultiTech

If you follow this link…

You’ll see that a “report” is not what you’re assuming, it’s merely the “term” that AppSheet used to call - things that run on a schedule.

Creating a scheduled event to automatically create the new month record is what you’re wanting to do.

Landlord_Buddy

Hello

Great thanks for your help I will try and let you know

Regards

Chetan

Landlord_Buddy

I have got two tables Tenant and Rent Due

The tenancy end date is in table tenant and I want to update the Rent Due table based on the end date in the tenant table . I am struggling to write the formula, I wonder of you can help.

So the schedule is everyday and checks the date in the end date or I can have another column which says rent due and reports on next month

Steve

What expressions have you tried?

Landlord_Buddy

Hello Steve,

Many thanks for your reply.

I am actually strugling with the expression and hence need your help.

As I said this is what I would like to achieve

I have got two tables Tenant and Rent Due

The tenancy end date is in table tenant and I want to update the Rent Due table based on the end date in the tenant table . I am struggling to write the formula, I wonder of you can help.

So the schedule is everyday and checks the date in the end date or I can have another column which says rent due and reports on next month