Show and Tell

For those of you needing to perform a Standard Deviation calc (STDEV() in Excel), here’s a template you can use for performing this calculation with values across a single row (record): SQRT( SUM( POWER({Value 1 Field} - {Avg of Values Field}, 2), POWER({Value 2 Field} - {Avg of Values Field}, 2), POWER({Value 3 Field} - {Avg of Values Field}, 2), ... ) / (n - 1) ) Where n = the number of fields SUM’d, ie, the number of POWER() statements. You do have to manually enter each field that holds a value which you want factored in to the StDev calculation, and you have to have a field that calculates the averages of those values, so this will not work well for a dynamic data set (new values are constantly being added to the list of values needing to be included in the calculation). I use it quite frequently in calibration specs, however, so I figured I’d post it here as a quick and easy reference for other people who were used to using the STDEV() function in Excel, bu

The inspiration for this script was the many posts that I saw where people wanted to setup default values when they create new records. In that way, it is similar to one of the scripts that has already been shared. However, I believe that there is no one right way of doing things, and I had ideas for a different workflow. This script fills in blank cells in a table based on a template record. It also requires no configuration of the script, and no changes to the existing table/field definitions. This script has the ability to make bulk updates to a lot of records very quickly, and it has several quirks and limitations. I only received access to the Scripting block when it was made public on Friday, so I didn’t have much time to get up to speed. I have many improvements in the works, but they will all take time to implement, and I need to sleep. Here is the base on the Airtable universe. Here is the gist. Here is a link to the walkthrough.

I’ve gotten Car fever and want to start doing research on used cars that fit my price range. I tried some of the consumer sites, but was really left wishing I had a place to look at all my research at once and compare things like average price and milage for a specific Make, Model, and Year. So I hooked Airtable up to the MarketCheck API via the scripting block and made a base that pulls in all available car listings within 50 miles of me within my specified Price and Mileage range. Then, made use of Page Designer and URL preview block. It’s pretty dank if I do say so myself. :star: :star: :star: :star: Overview of How it Works Here Copy of the Base Here Have fun y’all😃.

Have a look at the base here. We are a growing movement of volunteers who have been mobilized due to the current crisis to help the most vulnerable among us - the elderly, the refugees, the domestic abuse survivors, sex workers, single mothers, and others who are not getting their basic needs met. Who’s it relevant for? Mutual aid organizations and non-profits - tweak this base to suit your needs. Our process: We built an operations management system using Airtable. It works as a support ticketing system. Get the general idea by looking at this very high-level flowchart which also appears in the dashboards. We provide support in 4 ways: :phone: Matching people in need with phone volunteers that talk to them every week and check if they need anything :woman_cook: Matching with cooks to provide hot meals :shopping_cart: Sending food baskets :bulb: Helping with general requests - from clothing to fixing stuff at home Base features: Volunteers and people in need manageme

Shows the posts in English. I want to keep the posts in Bengali. How can I keep the posts in Bengali on the airtable?

When using a form, you can pre-fill linked fields in forms by using the Record ID for the record you want into a single line text field instead of the actual name, then use Zapier, IFTTT, or (my personal favorite) Integromat to update the linked field with that record ID. I realize it’s cumbersome, but you just have to have it, it works. I do this for several of my forms.

For anyone interested in Airtable scripting, I’ve added a few new posts to my blog: 3 ways to loop Getting the unique values for a field Creating a record Creating many records Enjoy!

To All The Volunteers: I would like to give a shoutout and a thank you to all the volunteers that go above and beyond, to help the Airtable members. Even with your busy lives, you still manage to find time to help. I, for one, am grateful for the many times that I received such great help. Thank you, Mary Kay

Hi all, Been using Airtable since 2018 and keep discovering awesome things everyday. One of my other ventures is building apps with no code web database tools. One of the new Airtable tools I found recently is a service called table2site (posted here before) which allows you to build websites using Airtable as your CMS. I built a site called NoCodeStudio and I’m really happy with how it turned out. Right now it’s focused mainly on Knack and Tadabase, and web design tools, but I’m planning to add Airtable resources as well. I’ll just stick this here to get it out of the way… NoCodeStudio is a community oriented collection of resources, tools, tutorials, builders, and more - specifically for no-code web database apps like Knack and Tadabase. Visitors can also submit new resources via an Airtable form. Thanks for checking it out - https://nocodestud.io And don’t forget to look at https://table2site.com No affiliations with table2site, just sharing.

I’m looking at learning more about Airtable and using it for my small business. This platform seems promising however a sales rep from another company (Quick Base) had pointed out the following limitations of Airtable. Airtable Limitations (according to a Quick Base rep) Limited Data Set Support: Airtable has a data limit of 50,000 records (rows) that organizations can quickly outgrow. Basic User Permissions Means Weak Data Security: Airtable has a basic user permissions security model that allows anyone invited to a workspace to view all of the info in that workspace. In addition, anyone needing to add or modify records requires Editor access which includes the ability to change and delete tables and views that may be needed by other users Lack of Reporting: Airtable lacks the ability to create reports that can be shared with management and others. Viewing tables with records grouped together provides very limited data summaries in the workspace. Are these statement accurate ab

I’ve seen a few posts in recent weeks from people asking about how to get started with Airtable scripts (e.g. here and here). I think people are, rightly, seeing the scripting block as a powerful piece of functionality and for non-coders it can be a struggle to know where to start (I know from bitter experience!). It is all there on MDN, but even the first sentence is putting up barriers: ==== JavaScript ( JS ) is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions. ==== What?! My small contribution to this is to start an Airtable scripting blog with some practical walk-throughs of how to get to what you want to do with an Airtable script: Airscript Home An introduction to scripting on Airtable bases for new coders The aim is to provide an introduction to scripting on Airtable. It isn’t the definitive resource on JavaScript code and standards (not by a long shot) and, even within the Airt

With the recent launch of the Scripting Block, we’ve been excited to see all the handy things created with it (and cool to say that @openside won a contest with this nifty script also!). So we made a central resource to host ALL the user-created scripts (code + description + source) for the scripting block and put it here. It had to be done. :woman_mechanic: Here are a few screenshots: You were wishing for a central place to find all the script-block goodness, admit it. :slightly_smiling_face: See the Scripts Library Have a script to add? Click through on the link above to submit it. Hope it’s helpful!

I use tags to highlight some characteristics of records in my table. In this dataset I want to highlight whenever I have a “Stale Deal” and/or a “New Customer.” I want to use multi-select options because they’re easy to filter and chart. However, I don’t want to manually tag each select option, because there’s a formulaic way I can assess these characteristics: ‘New Customer’ = Deal Count is one ‘Stale Deal’ = Time since last inquiry is > 30 days. I’ve tried to do this via a formula and isn’t pretty to write, read, filter, or chart by. So, why not replace that formula with a script? Works like a charm: Link to the base here. Happy Scripting! /* Calculations: 'New Customer' = Deal Count == 1 'Stale Deal' = Times Since Last Inquiry > 30 */ // Load Records let table = base.getTable('Data'); let query = await table.selectRecordsAsync(); let records = query.records // Create an Array of tags when a record matches the criteria let check = records.map( c => ({id:c.id,t

Hi everyone, I’ve a request, my situation is : I have a table with my customers database with name, phone number, etc. I attribute to each of them a partner. And I have a table for each partner. So I would like to know if it’s possible to put each customers in the right table of the corresponding partner automatically (using only the customer’s table) and how? Thanks a lot in advance!

When a record has multiple date fields, sometimes you’d like to know which date is the earliest. In the below example, each record is a social post that has different live dates for different channels. I’d like to know the earliest live date across all three channels. I could do this in a formula, but the ‘LIVE DATE’ field is also used by other teams, so I’d rather calculate the date with the below script (plus the awesome batchAnd script to do this for more than 50 records): Example Base Here // 🌸🌸 👇Add all the date fields you need here 👇 🌸🌸 let fields = ['Instagram Date','IG Stories Date','Facebook Date','LIVE DATE'] // Let Airtable know which table and views records you want to use let table = base.getTable("Content"); let view = table.getView('All'); let query = await view.selectRecordsAsync({fields:fields}); let records = query.records; // Find the Earliest Date let dates = records.map( c => fields.map( x => (c.getCellValue(x) != null && x != 'LIVE DATE') ?

It’s a quiet Saturday in my office and while I should be working on a client’s project, I found myself intrigued reading the various responses to Airtable customer requests for help from consultants. Some of them had me chuckling and others were simply boring. A few even triggered yawns from time-to-time despite being hopped up on Black Rifle Coffee. This post is yet another tell, and no show. Just a few tips from an old dude who’s written about 41.8 million lines of code. I’m an analytics guy, so yeah - I pretty much know how many lines of code I’ve written since 1978. Being this old and this “seasoned” in the fine art of crafting software, I get away with saying stuff that might come off as crude or insensitive. But, my candour might also help you avoid some blind spots. Feel free to push back on these highly opinionated perspectives and know that if these were considered crimes, I would be on death row. :winking_face: That said, here are some tips to pick winners - both consultant

Hello All, I am looking for a good article that explains what a Airtable base is? When I look at https://airtable.com/pricing Records per Base seems to be the main difference between Free, Plus and Pro? That leads to the question, what is a Base?

Hi Is it possible to add a condition to trigger an action (like hyperlink redirection, e-mail, …) after changing the data from a specific field? Cheers, Marcelo

Just posted a 7 Wonders scoring app built in Airtable to Airtable Universe. Airtable 7 Wonders Scoring App - Airtable Universe This base is for those 7 Wonders fans who are looking for a scoring solution that can account for ALL the expansions (including the most recent, Armada)! ​ ... Let me know if you have any feedback! Thanks to @bdelanghe for helping with the scoring algorithms.

Hi everybody, I use Airtable as a CRM to track all my contacts and interactions. It is pretty neat that I am able to open up a contact in expanded view and view a list of interactions I had with this contact. However, I had to manually click into each individual interaction to view the information I needed. The entity-relationship is as follows: Each Contact may have multiple Interaction Each Interaction has 4 key fields namely Date, Method, Notes, Next Steps My objective was to put all my interactions for each contact into a single column for quick viewing. To set this up, I did the following steps: In the Interactions table, create a new column named “Interaction Summary” with ‘Formula’ as the column type. Create your formula as follows and customise according to your needs: Formula: “\n” & CONCATENATE("[",DATETIME_FORMAT({Date},“DDMMYY”),"-",{Method},"]") & “\n” & “=== Notes ===”& “\n” & {Notes} & “\n=== Next Steps ===” & {Next Steps} & “\n” T

If you’re like me, you like to catalog things. Like, perhaps, your movies. And you’re going to want to sort them by title. Which is no big deal… until you get to all of those movies that start with “The.” You don’t really want all of them in a lump in the T section, right? You’ve gotten spoiled by programs like iTunes that somehow ignore the word “The” when sorting. Thanks to Airtable’s formula columns and string-handling capabilities, you can achieve the same effect. Let’s say you’re storing your movie titles in the Name column. All you need to do is: Look at the first four characters of the title. If the first four characters are "The " - chop them off, then add “, The” to the end of the title. Otherwise, just return the title as is. This function: IF(LEFT(Name, 4) = "The ", RIGHT(Name, LEN(Name) - 4) & “, The”, Name) does just that. Sort on this column, and you’re all set. Hide the column if you don’t feel like looking at it. Be sure to look at the first four characte

With all the live-streaming meetings that my family currently has, I wanted a one week rotating calendar, where I could enter all the events for a week and the events would always show up for the current week indefinitely, without creating any new records. Then everyone could subscribe to the shared calendar in their favorite calendar app. Here is a simplified version of the base that I created. Airtable Templates Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. This base lets you create a rotating one week calendar of activities. Enter your activities, select the day of week for each activity, and enter the start and end times. Formulas will calculate the dates for the current week so you can see the activities on in a calendar view and subscribe to the calendar in your favorite calendar app. When you view the calenda

Hey everyone, Just wanted to share with you a base that I have been working on that would match between volunteers and cases during the COVID-19 Pandemic. Please check out the video below. This base can be used by any organization/community that is looking to automate a part of there efforts to help their fellow humans during these hard times. There is still a lot that can be done and Im sure you guys with much more experience than me in Airtable would have many useful insights on how to make it better. One of the things that I cannot solve is when someone wants to use the base they would have to redo all the zaps. Maybe it would be better achieved by Script Block ? Looking forward for your feedback. BR, Mo

Hello all! Wanted to share something we’ve been working since early last year: the first and only (so far!) Airtable-themed podcast in the world. :world_map: The BuiltOnAir podcast in a sentence: we get amazing people on the show to talk about what they’re making, why they use Airtable, then demonstrate actual databases they’ve built. In addition to meeting a fellow enthusiast, as the audience you get to see real examples of Airtable at work or play, demonstrated by the creator themself. While many of the examples are actual use-cases from internal systems in their businesses, you’d be surprised how many guests share a database they built to keep track of their house plants. It’s fun. Each episode dives into the following :woman_mechanic: Who the guest is and what made them attracted to using Airtable :writing_hand: What they’re working on professionally or in personal projects :desktop_computer: A “show and tell” section where the guest does a screen share and walkthrough of

Here is a strategic vendor selection tool that I created a while back. Some of you might find this useful when comparing a number of potential vendors for a project or as a supplier of goods. Enjoy! Airtable Vendor Score Card: Template - Airtable Training and Overview Tutorial: http://ior.ad/6W4P Overview This Vendor Scoring system was adapted from Dr. Carter's 10c Supplier Evaluation Model. Which evaluates potential vendors based upon the follow Criteria: Competency Capacity Commitment... Here is a walk through, this was created using Iorad, another tool that I find extremely helpful! This Vendor Scoring system was adapted from Dr. Carter’s 10c Supplier Evaluation Model. Which evaluates potential vendors based upon the follow Criteria: Competency Capacity Commitment to Quality Consistency of Performance Cost Cash and Finance Communication Control of Internal Processes Corporate Social Responsibility Culture Many of the questions