Hi Community,
Relatively new with Airtable (6 months or so) and struggling to create an automation that in theory seems quite simple, but I've tried everything and can't seem to crack it...
Context
I have a table for invoices, where each invoice can be set as either an "Invoice" or "Additional Invoice". the invoices table also has fields called "Original Invoice" (Linked to other records) and "Additional Invoice" (Linked to other records).
Desired Automation/Example
I create a new record in the invoices table (Record B) and set it as an "Additional Invoice", and then, in the "Original Record" field, I link to Record A. (In other words, I am setting that Record B is an "Additional Invoice", and it's "Original Invoice" was Record A)
When Record A is linked to Record B as above, I want Record A's "Additional Invoice" field to be populated (linked with) Record B automatically. - Rather than having to go into Record A, and linking it with Record B manually.
If anyone could work out the way to achieve this without any testing issues arising within the automation, I would be so so grateful, this has given me so many headaches!
Thank you!
George
