Lookup & Copy Field With Script

[Clayton_Chase]

Hey All,

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?

[Maski]

It should be possible I suppose.

[TheTimeSavingCo]

Hmm any chance you can solve your problem with repeating groups instead? 

Pretty much anything's doable with a script really, but if you don't know scripting I'd advise against it unless you want to pick up JavaScript