Copy linked connections between tables

Topic Labels: Automations
103 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I would like to ask whether is possible to copy linked connection between two tables with automation?
I have three tables:

1. Summary - here I would like to collect prices from Payment and VAT from Invoices
2. Invoices - here are list of invoices, each has at least one connected Payment.
3. Payment - list of payments with specific prices

In Payment table I manually connect each payment to specific Summary.
What I would like to do is automatically create/update Summary field in Invoices table with same linked connection as I do with Payment, so in Summary table VAT can be calculated. I tried it with automation, but probably I have mistake somewhere in the action..

Hope I explain it clearly, here is link to my sample base -

Thank you very much

0 Replies 0