Builders Board

Hi. We are an insurance agency (located in Chicago) with a pricing tool built in Airtable - we want to provide third-parties with a REST API to call the Airtable API and return the correct price. However, we need the response data to omit certain fields. AWS’s API gateway offers this as a feature and it all seems very possible based on my tinkering. We are open to other solutions - we use Google firebase for our current web services. The API would need to be able to pass through Airtable’s API token along with 6 data fields. Airtable would provide all of the data required for the response. We are looking for a developer to contract for this project, but any ideas or advice are also appreciated.

Hi all, We’ve built a software on top of airtable using javascript, and are looking for further support. Please only respond if you yourself are can write javascript, not if you have work with someone that you’re going to subcontract with. Best, Jordana

Hello! I’m looking for someone to help me set up some things in Airtable. I work for the science department in a public school district. Here are some things that I’d like to be able to do: • Products – see all grades where a product is used • Enter prices for products at all vendors, find a unit price, and be able to easily do a price comparison to find the most inexpensive vendor • Get teachers a list of everything that they’ll need at each grade level (main kit) – we’ll be doing an elementary cleanout and I want to be able to say DON’T get rid of these things • Give teachers a refill list for them to do inventory – how much do you have already of these things? Ideally, I’d love to have this be a form in Airtable to collect the data • Be able to pull the information from each teacher’s form to see total numbers needed to order; also, separate by cheapest vendor and end up with a list for each vendor and what I need to order. I’d be paying for this myself personally (not the school

Hi everyone :wave: We’re excited to release a new tool for Airtable: Search Webpage for Airtable Records! This tool is particularly useful if you have clients/students/employees and you only want them to be able to see the records that they are associated with, and none of the other records in your base. Example Use Cases Order status lookup Ticket tracking Search student’s grades And much more! Some of the Features: Generates a unique URL that you can share with anyone. Supports searching with one or multiple fields. Hide any fields you do not want to show in the results.

I love sharing tips to help others learn more about Airtable, and the idea for this YouTube channel has been brewing in my mind for a while now. Even though I’m scrambling to prepare for our cross-country move in a few weeks, I wanted to make this quick tease about the channel: Subscribe now so that you’ll be ready when the “real” stuff starts going up, which will probably be some time in December if things go according to plan.

This is not a show; rather mostly a tell. It’s my experience (which is extremely limited given that the Script Block feature is still a newborn) that for every hour spent developing a block, plan on an equal or greater time implementing the completed block into your solution. There are many reasons this is the case including but not limited to these points: Hard-coded table and/or field references Success-biased data that create testing blind-spots Lack of anticipation concerning the block used in “the wild” Inadequate testing cycles at scale I’m often asked - Hey Bill, can you whip me up a script to do that? My problem is so simple, I’ll bet it will take you a few minutes to bang this out! Um, sure? I guess? On second thought … many of us who may be easily coaxed into the feeling that script blocks are simple little nuggets of goodness may want to rethink committing to [seemingly] effortless and enjoyable ways to kill a few hours. Writing code is never as simple as it seems and so

Hi there, I am currently looking for a developer who can assist me in setting up our Airtable back end for incoming client orders, client profiling, weekly mailers, automated emails, and shipment links etc. I have it set up in the way that we would need it to be already, but need someone to help finalise what I have done and also to link it to the necessary tools we need to be able to start running it efficiently. Many thanks, Bettina

Hi all, just thought I’d share an insight I had about working with lists. Recently, I had a project where we needed to take an email address from a customer-submitted form and check whether the email is from a list of known domains. I could have used an OR() statement, but that would have created a very lengthy formula, because I had to first separate out the domain from the rest of the email, using this formula: LOWER(MID(TRIM({Email}),FIND("@",TRIM({Email}))+1,999)) Thus, if I have to compare that to 5 different domains using an OR() statement, I’d have to repeat that formula snippet 5 times, and that’s not very DRY, is it? What I realized was that instead, I could use a SWITCH() statement. Since a SWITCH() statement allows you to optionally include a final parameter in case none of the cases listed matches the initial text, you can use it as a sort of hack to go through long lists (similar to how, in Excel, you could use a MATCH() statement). This still has a drawback, in that eac

Hello I am looking to build a Front App plugin For Airtable. The plug in should be set up to be able to look for a specified email in a specified table, and do a range of action from there (for example: if email is present in the contact table, display “full name” column) etc. Also should be able to update a found record from the plugin. It should also be able to create new record if the find comes back empty - I am looking to do this soon :slightly_smiling_face: S.

Hello, My name is Ben Bills. I am a public educator for 9-1-1. I educate the community about the appropriate use of 9-1-1. Most of my work is conducted in elementary schools. What I am looking to do is create an airtable that allows me to track what schools we have visited, what program was taught, and create a dashboard that shows our reach rate. It would be even better if it could generate reminder emails to schools prior to our visit and automatically send a survey after our visit. I know it sounds like a big ask, but I have been working on this project and have hit a dead end. Help! Thanks in advance :slightly_smiling_face: Ben

Many future clients often ask me: Should I automate this process? And if so, where do I start? This is not uncommon thinking; we’re over-saturated with tasks and our resources are stretched beyond reason. Of course, the answer is always - yes - automated it all if possible. And while we like the sound of this, the more difficult question to answer is the cost-benefit of automation. Until you can look at a task (or ideally, a collection of dependent tasks) and put a value of making it entirely disappear from your involvement, automation should not be undertaken. My advice is to segment processes with a diagram and then apply some basic metrics concerning effort. Once you see the bigger picture and the effort each step in your processes require, then you can ask if it makes sense to automate that segment of your process. Some processes (when diagrammed) become obvious candidates for automation, but a comprehensive process diagram allows you to also classify process segments as more ben

Seeking AirTable expert to advise and guide in process of setting up Airtable. Need to be familiar with businesses, multiple projects and advise best approach to go. Must be fluent in English and able to communicate via Skype text messages.

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: Airtable Email review links - Airtable Universe This shared based demonstrates the new Scripting Block in Airtable to streamline sending a list of video links out to review to another base collaborator. ​... 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.

Sometimes you want to visualize some metrics. For example, I may want to see the different delivery metrics of email campaigns by different segments across many years. I can do this nicely with blocks if each campaign is delivered to only one segment. However, if I’ve got an email that hits two (or more birds) with one stone…aka one email delivered to multiple segments, this is where my chart gets wonky. I can’t break out the multiple segments while still looking at my chart over time. (Note: You can do this in a pivot table block, but charts are just way more impactful sometimes.) To get a better chart that does break these segments out, I’ll need a Summary Table, which is a nice way of saying I’ll need a junction table to break out this many-to-many relationship. Each record in the summary table will be a single campaign and segment it was sent to. So, if Campaign 2 was sent to three segments, there will be three records. This is great, but it presents us with another problem. If I

Greetings! We are managing a system of ferry transportation routes and require an Airtable expert to build out the reservation interface for us. Details more easily provided via a Zoom meeting where I could walk you through the base we have built and describe our needs. Should be relatively straight forward for an expert. Looking for quick turnaround. Many thanks, Chris Ritter Innovation Arts & Entertainment

Hi, We are looking for some help in three areas: Help translate data in a grid view into a matrix table that summarizes some of the grid data. Automatically add new orders to a reporting field for use in a page designer report. Creating a formula to automatically break down numeric values into specific columns based on a tag in a column. Please reach out to tony@innovationae.com with estimates for this type of work! Thanks, Tony

Using this script with the Content Calendar Template, you will be able to do some common tasks with managing your content calendar. This script will enhance the Content Calendar Base by providing 2 common tasks: Create new Content - this easier approach to creating new content makes it quick to get content added to your table Publish Content - once you have created content, you want to publish it quickly to multiple platforms. This makes it easy to track which platforms you are publishing it to (Twitter, Instagram, or Facebook) and automatically links it back to the primary content. NOTE: This does not actually publish to Social media platforms, it simply tracks where you have published the content to and how. No changes are required to be made, simply run script and select one of the two options. TEMPLATE TO INSTALL: Content Calendar Template - Free to Use | Airtable SCRIPT: gist.github.com https://gist.github.com/on2air/de0a6d3f0b371d73564aba472f4cc01a Sc

Something very often requested is the ability to extract the meta information of a base/table to be used for external use. Now, with the new scripting block, that information can be extracted and shared outside. Simply copy this code into a scripting block and run it. If you wish to publish to a 3rd party endpoint, simply modify the codebase. Full documentation provided inside the code. gist.github.com https://gist.github.com/on2air/ab32b4bb59d02d490be37e28d45daf92 On2Air: Meta Extraction Script /***** * Title: Post Meta Data * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community * * Reach out for all your Airtable needs This file has been truncated. show original

Hi , I am looking for a consultant in Israel , who can help me implement. Thanks , Netta +972-50-5564991 , netta@nettatravel.co.il

I’m looking for someone to help custom design an airtable database. I’m already using the product but want to take it to the next level. Please let me know if you can help. Phoebe

I would like to hire someone to write a script in google’s g-suite to replicate the actions performed by a Zapier task (as described in this post: Update Fields with Integrated Scripting Approach). I have a very simple use case, an existing Zapier task, as well as a simple explanation of what needs to be done, as follows: Every minute, run a script that looks for new records in Table 1 For each new record, identify existing record in Table 2 via linked field ID Update record in Table 2 with field value from new record in Table 1 Update record in Table 1 with status Reply with contact information and I’ll be in touch.

Hi Everyone. Beenform is a simple form backend product that enables you to setup working web forms that works with Airtable in just a couple minutes. With Beenform, you can hook up your static HTML form, with an endpoint that captures form submissions and creates an Airtable record. In addition to collecting submissions, you can enable User Authentication in beenform so that any form submission from your users, an automated email with their unique individual link will be sent to them, which they can always use to update only their individual records. All these changes are made in your Airtable base. Every Beenform form also includes automatic spam filtering, Google recaptcha support etc. We are still currently in beta, so it’s completely free. Let me know what you think. You can check it out here https://beenform.co . Thanks all :slightly_smiling_face:

Hello, I need help building a tool that does several things. I have an interior design business and I want to be able to input projected hours for each employee, by project. I want to be able to then see their bandwidth several months out. Secondly, I want to input these hourly projections by project, and create gaant charts by project, so I can track progress of each project, but hopefully all together in one place. Ideally, there is a place I can input project information, including which employees are on what project and about how many hours we think will be needed by project phase. Then I would love to be able to see this information in different views- calendar, by employee, and by project. The goal being that I can better plan for staffing needs, see when we will be busier and less busy, so that we can take on more or less work as we see fit.

Hi, we are in the midst of building a simple website and would like to include a form connect to airtable and a few customized fields on airtable. Would like to find someone who can help.

Hello everyone. We use Airtable for various things at Unly, and we have always been concerned by the inability to create scheduled backups that really fit our needs. Despite the fact Airtable has its own backups/restore feature, it didn’t fit our needs. And, because Airtable holds lots of business-sensitive data, it was a very big risk for us not to be in control of the backup&restore process. So, we built a tool that is designed to perform scheduled backups automatically, and deal with backups lifecycle (auto-removal, etc.). Today, we’re releasing this proprietary software as OSS under MIT license. GitHub UnlyEd/airtable-backups-boilerplate Configurable automated backups for Airtable meant to be self-hosted, powered by AWS Lambda/S3 with the Serverless framework - UnlyEd/airtable-backups-boilerplate Because backups are very sensitive things, it didn’t make sense to us to build something where we would hold the backups ourselves. T