Copy field data (Mailing Address) from one table to another (Shipping Address)

[Ryan_McCluskey]

Hey all,

I have a table called “Contacts” which contains the following columns:
Mailing Address 1
Mailing Address 2
Mailing City
Mailing State
Mailing Zip Cod

I have another table called “Leads” which contains the following columns:
Lead Address 1
Lead Address 2
Lead City
Lead State
Lead Zip Code

I want to create a button that runs a script to copy the address info from the related Contacts row to the Lead Address, in cases where the lead and mailing address are the same. I have no experience using the scripting block.

[Olpy_Acaflo]

Hi @Ryan_McCluskey and welcome to the community !

As you wrote :

Ryan_McCluskey:

I have no experience using the scripting block.

I could copy you what I did appreciate very much to start:

AIRSCRIPT - Learn to use Airtable scripts helped me a lot to start and to improve myself.
(thanks to airscript’s Author @JonathanBowen ! )

l also like this one by @VictoriaPlummer

The Scripting block is a powerful game changer for Airtable, though you don’t need to be a developer to use it. Before using the scripting block, the most experience I had was writing a couple of Macros in Excel (but even that isn’t necessary knowledge.) Now, I mostly use scripts as complex formulas that can also create or update your records on a base. I encourage you to get into scripting if you. Like building formulas Kinda sorta know what variables, arrays, objects are Understand how loops…

and the Official Airtable Script Block API Docs :

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Best,

oLπ

[kuovonne]

Welcome to the Airtable community!

Others have already recommended great resources for learning how to use Scripting block.

You can also check out this script that I wrote copying field data from one field to another. It could be adapted to copy data from one table to another.

https://community.airtable.com/t/scripting-contest-using-newly-launched-button-field/31386/8

[Mike_Pennisi]

Hi there, Ryan.

It sounds like you want to copy data from one record (aka “row”) in the “Contacts” table into the “Leads” table, but I’m having trouble understanding the exact behavior you’re looking for.

Do you want a new record (aka “row”) to be created in the “Leads” table? Or do you want an existing record to be updated? If you’re looking to update an existing record, how should the script choose which record to modify?