Populating another table is what I am really looking for as well.
If there are any new information on it, would really love to.
I tried using your concept and run it on automation. In short, it fails. In long, here’s what I did and the result.
![image image](/t5/image/serverpage/image-id/2962iCADBF3BEDD344BE0/image-size/large?v=v2&px=999)
This is the base.
And then I make a new ‘View’ (on the left side) called View - Place A only. In this case, I use 'Filters" so that only [Place A] is shown.
![image image](/t5/image/serverpage/image-id/2964iBA19D461D9B2BC90/image-size/large?v=v2&px=999)
Then add automation, with ‘When record enter View’ as the trigger. Select the View - Place A only.
![image image](/t5/image/serverpage/image-id/2967i6EBFE06A8A657A10/image-size/large?v=v2&px=999)
And then the Action is ‘Create Record’ in Table 4
![image image](/t5/image/serverpage/image-id/2966iD0AEC29BC1788602/image-size/large?v=v2&px=999)
And this is the result …
![image image](/t5/image/serverpage/image-id/2968iA60FCAB680FCA369/image-size/large?v=v2&px=999)
In short: Scribbles.
The logic should be right, it’s just some implementation problem. If you find out how to do it, please post it. Very interested to know as well as I am looking for similar things.