Skip to main content

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!

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:

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

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

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.

Reply


Terms & Conditions