I need to automate links between a table full of User records, including a unique user ID field, and a table full of Invoice records, each Invoice also includes a user ID field. New Invoice records get created more frequently than User records.
For each new Invoice record that gets written to my Invoices table, I want Airtable to recognise the User ID and use this to auto-link to the corresponding User. A single User will have multiple Invoices, and each Invoice uniquely belongs to a single user.
I need to be able to open a User record and have access to all the invoices that correspond to that user, and perform rollup calcs etc on the various fields in the Invoice records.
I can do all this by manually linking each new Invoice record to a User record, but have not figured out how to automate this.