Lookup & Copy Field With Script

Topic Labels: Scripting
839 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

It should be possible I suppose.

See ya!

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