Walk us through your best script and win $250 + Airtable swag

[Jason]

Hi everyone!

We’re thrilled by all the enthusiasm for the scripting block so far, and are really excited to see what you’ve all been building! To that end, we’re going to have one more scripting block contest (for now :winking_face: ). Unlike our beta contests, which were a little more focused, this one is totally open ended: submit your very best new script. Just one twist - this time, we’d love to see it in action with a short walkthrough screen recording (we recommend free tools like loom, but there are plenty out there to choose from.)

Similar details to last time:

• Create a new thread with your script and video walkthrough, and post the link as a reply here by 5:00PM (PST) on Monday to be considered.

• Everyone who enters will get something for participating, and the winner will walk away with a $250 Amazon gift card and some fun Airtable swag.

• Follow best practices for open sourcing a script as much as possible, including:

  • Include comments to explain what each part of your script does so others can understand and adjust for their own bases.
  • Give any variables or functions descriptive names to make your script easier to read and understand.
  • Use input.tableAsync , input.viewAsync , input.fieldAsync and input.recordAsync to avoid references to specific fields or tables that might be different for other users. If you do reference specific fields or tables directly in your script, we recommend pulling them out into variables and moving them to the top of the script so others can change them to match their own bases.
  • When open sourcing a script, also share a copy of the matching base on Airtable Universe so others can see the script in context. Make sure the “Show code in public shares” setting is enabled for your script in this base so people can read and copy it.

That’s it! Happy building!

[Bill_Carovano]

Scripting: Mail Merge with Lob.com Show and tell

I created a script that takes data from a table to perform a mail merge using the Lob.com service. The share on Airtable Universe includes the scripting block code as well as an instructional video. -Bill

[Matthew_Thomas]

Scripting: Email review links Show and tell

This is an example to take advantage of Airtable’s new scripting block for taking a selection of records and formatting links to send in an email to a fellow collaborator. The sample base is located on Universe: and a brief walkthough video can be found here: The script was developed with a video workflow in mind that will have a batch of videos ready for review each week, but it could be expanded to other fields of work.

[Jeremy_Oglesby]

EDIT: I updated the script to be able to handle more than 50 records in batches, and updated my post and Universe example as well. - @Jason @Zoelle_Egner

Automate the matching of Text values to Single Select values:

Scripting Block: Match Ugly Import Transaction Names to Pretty Single Select Values Show and tell

EDIT: Updated to incorporate solution for batching more than 50 records Why this script I import transaction records into Airtable from my bank on a regular basis via CSV files. Those transaction records have names that are pretty ugly most of the time (like [Amazon.com*6X6AN17G3]) and often there will be multiple transaction names that actually link back to the same company as a payee. I want to know, for example, how much I paid out to “Fry’s Grocery Store” in total, no matter which Fry’s l…

[kuovonne]

Trying to get this in by the deadline for the contest.

I will try to edit my post later to make it sound better.

https://community.airtable.com/t/scripting-block-setup-blank-cells/27737?u=kuovonne

[Jason]

Thanks everyone for your submissions! We’ll review them and announce the winner asap :slightly_smiling_face:

[Jason]

We’re excited to announce that @Jeremy_Oglesby is the winner of this scripting block challenge! We chose this script for a few reasons:

1. It solved a very common roadblock faced after importing large data sets
2. It used batch functions which involves looping through sets of 50 records at a time
3. It created a helper function in a way that can be copied / pasted into any other script and used as is.

Thank you to everyone who submitted a script! And, we’re looking forward to more challenges (HINT: keep an eye out over in blocks madness later today) with this block.