Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 06, 2020 04:36 AM
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.
Aug 06, 2020 06:11 AM
Hi @Ryan_McCluskey and welcome to the community !
As you wrote :
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
and the Official Airtable Script Block API Docs :
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
Best,
oLπ
Aug 07, 2020 10:26 AM
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
Aug 18, 2020 04:32 PM
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?