We are a long term rental property management company. There are several properties in which we have equipment such as AC, refrigerators, washing machines which need to be maintained. At regular intervals they will be maintained and I am using airtable to schedule maintenance records.
Each equipment has a table in Airtable which I am using. For eg AC maintenance is done on a separate table, Washing Machine maintenance is on another table, etc and so on.
There would be new properties which would be added which are maintained in a separate table. Once a new property is added in the property table, it should enter into all the maintenance tables automatically. Now it is creating a new record but the contents of the property table are not getting duplicated to maintenance tables.
The fields in property table are different to the fields in maintenance tables except for the property name (let's say this is the property ID)
If the maintenance is done only once, I can have different views in the same table however the maintenance needs to be done more than once in a year and its a recurring task till the property is under our contract.
Furthermore, I have created an automation in a way, if a particular AC in a building is cleaned a new record would be created in the same table for the same AC for the next cleaning cycle.
I am doubtful this can be achieved if everything is in the same table (property details and maintenance schedules) but with different views.
However, if there are ways to do it in a single table I would love to understand how to achieve that. I did figure out a way. Having a checkbox in the property table and by checking a particular room, I am able to get the contents of property table to maintenance tables - of course need an automation rule too. This creates an additional step of checking the box but that works ok for me.
If there is a better/faster/easier way to do it, I would definitely like to know.
