May 18, 2024 03:27 AM
I have table A and table B.
When a record in table A is created, I have an automation that creates the same record in table B. However, the primary column in table B stays blank. How can I fill the primary column in table B with the primary column value of table A?
May 19, 2024 09:55 PM
Are the 2 records linked? I have tables that use a formula to populate my primary field with the name in the linked field...
May 22, 2024 04:32 AM
No, its not linked.
I work in property management company.
I want to have "tasks" table for general tasks and "faults" table for faults in the properties. When I create new record in the "faults" table i want it to create the same fault in the "tasks" table and if I change the status for that fault in the tasks table it will change the status in that record in the faults table as well.
Is it possible?
May 22, 2024 01:45 PM
I'm sure there IS a way to do that, but I'm wondering if it might be more complicated than it needs to be? This could maybe be done in as little as 2 tables, allowing for a complete picture of everything that needs doing using views. This would prevent needing to duplicate records and potential errors.
Threw this together as a quick example: https://airtable.com/appqpn8HdoLV8opeM/shriZx2HEdJYc2zcT