Hello,
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 - https://airtable.com/apphUNbqkv8pDYRGS/shrdfftFVSqakQLaw
Thank you very much
