I have a table with a list of tenants, in there you have their monthly rate, what building they are located and some other details. I want to 100% automate a process of making entries monthly using an Event Type. Is it possible to automatically add new entries for all the tenants using the details from the tenant tables and create a parent and child record every first day of the month? I feel like its impossible but before totally giving up on the idea maybe I'm just missing something?
So the form itself would be like...
Date:
Name:
Building/Branch:
Total: (Based on the summary of all the items in the child record)
(child record)
Rent Value:
Electricity Value:
Water Value:
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |