Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Copy linked connections between tables

Topic Labels: Automations
516 0
cancel
Showing results for 
Search instead for 
Did you mean: 
PeterJNCK
6 - Interface Innovator
6 - Interface Innovator

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

0 Replies 0