Good evening (from NZ). Is there a way to display an action button in a table view, where the action effects a different table?
I have several tables, with “Properties” table be the central Ref table. Branching off are tables such as Tenant Info, Property Issues, Maintenance, Income etc. I am trying to account for all rent received against each property.
What I am trying to achieve is a quick way to set rent received / not received against a property. My ideal would be to use an expression where, every Sunday the action triggers to say rent was received, which would create a new row showing Property Name(Ref), Date (Change), Rent received TRUE, Rent amount (ref) - there would need to be a condition that checked there was not an entry in the last 7 days for this property. I would check to see if rent payment was made on Friday and if not, I would manually set to Rent Received FALSE.
The view below is overall how I would like it to look, but currently each row is its own entity, rather than a single Property and all associated rents. Ideally I would just see a list of each property name, so I could select several and use a bulk action to create the appropriate row.
Are there any suggestions to point me in the right direction??