Hi all,
I have a hunch this was discussed before, but I can’t find a solution 😦
I have two tables, A and B, with a one-to-many connection (one A item can have many B items).
I want an automation that when I set a B item status to “X”, a sub-item is created in table A under the linked item. The sub-item will have its own columns and values (taken from what it has in table B).
In human-speak, let’s say Table A is employees, and Table B is Assignments. I want to be able to see a “history” of all past assignments under each employee. I want to see it in the employee table.