Here is what I'm trying to accomplish. Basically using Airtable as an estimating tool for construction. I've created a "catalog" of parts and services that I need to pull from the catalog into an estimate table. I've tried this several ways including a junction table but the problem with that is I need to be able to overwrite the catalog price at times when the price of something spikes but doesn't merit being changed in the catalog table.
My solution is to create a field in the Estimate table that runs a script to look up and copy a record from the catalog table to the estimate table.
I've got the record look up working but is it possible to copy a record over with all fields?