Imagine this scenario - I want to create an invoice line. I have a product table of product_code and sales_price. I have the product code and quantity in the invoice line table and want to lookup the sales_price and copy it into the invoice line table field sold_price_each. I can do it with a lookup but that has a problem. If the price of the item changes in future, then the invoice will change after it’s been issued, which is no good at all!
I am new to Airtable and cant see a way forward on this one. Any help appreciated.
I was actually just going to type up that I like your solution on this one as well! Very clever! And with the new conditional linked fields, you could even limit the invoice’s selection of items to just the ones that are in the most recent price book.