Builders Board

This question caught my eye on OpenSide’s Slack channel this morning. It’s a common question for anyone doing anything serious with Airtable. I’ve written about this subject many times including here and here. Does anyone know if Airtable can support more than 100k records per base on enterprise? I generally try to reframe this topic to suggest a more important question you should be asking - Is there a way to optimize the data model to accommodate the equivalent of at least a years worth of transactions? High-volume record requirements are generally indicative of transactions; data flows that are increasingly less relevant as ti

I created a script that takes data from a table to perform a mail merge using the Lob.com service. Airtable

Hello! I’m a part of a volunteer mutual aid group called Mutual Aid LA and we organize a free produce giveaway in a park every Thursday where we hand out produce to the community and also stock several LA Community Fridges (Login • Instagram). We need someone to help us build a base and sign-up form to sign-up to deliver to specific fridges each week. I’ve spent hours trying to do this myself but really just need someone proficient in airtable and automations to help me out by building it or even just giving me some pointers. Please let me know if you are available and interested in doing this. This would impact so many people because it would allow us to get food to so many more people. Thank you for considering!

Hello! I’m consulting with a nonprofit and this is the requirement: Use Maddie’s University LMS (No API possible - proprietary) - export data in .xls Certifications are managed through BadgeCert - API is accessible. Less than 25 columns of data. Three test rows of data. I’m interested in knowing how much a custom-build API would cost for Airtable to BadgeCert. I can be reached at awwdorablepets@gmail.com Thank you, Julia

Hi everyone I’ve posted previously about making a simple “to do” list that generates a new task with the same name, due a week later, whenever you tick the task complete. Here’s a slightly more sophisticated version of the same idea, where you can specify when you want the task to repeat, e.g. 1 week later, 2 weeks later, etc. Hope this is useful to someone out there. I’m just getting started on making simple instructional Airtable videos, so appreciate any feedback. Cheers!

Hey there,If you’re looking for a dashboard layout to view multiple tables in your Airtable base at one time or to edit and create records and Linked records, check out On2Air Forms for Airtable.You can create sections with your various Airtable fields and what’s most useful for you to see. We have a free plan, so you can try it out. Get started hereOn2Air Forms Features:Update existing Airtable recordsCreate new Airtable recordsCreate linked recordsEdit linked recordsView linked recordsDisplay data from your basePre-populate form fields with dataAdd SubForms inside of your form to update multiple table

Hi everyone. It just occurred to me that you could use a formula and a couple of automations to make yourself a simple recurring tasks list. All you need is a date field to set the initial due date of your task, a checkbox field for when you mark the task as “Done” and a formula field that adds a specified length of time to the due date using DATEADD when “Done” is ticked. Then your automation will take the date generated in the formula field and replace the original date in {Due date}. A second automation then takes a last modified field set to monitor when “Done” was ticked, and a formula that shows how much time has passed since “Done” was last ticked, and unchecks “Done” after that length of time has passed (I set this to 2 minutes, i.e. 120 seconds). This final step is to ensure the two automations do not interrupt each other (so to speak). Here’s the full set up… Fields {Name} - Primary field, single line text. The name of your task.

Memorializing this since I spent entirely too much time and bugged @Justin_Barrett @Bill.French and @openside to get this output. I needed to output the US date format into an email, but I needed “tomorrow’s date” to be output. The use case was an email that goes out through automations every Wednesday, but they needed a reminder in the email to follow up by Thursday, (Tomorrow’s Date). Here’s the outcome. It works, so we don’t try to make it more elegant in these parts :slightly_smiling_face: let someDate = new Date(); someDate.setDate(someDate.getDate() + 1); let dateFormatted = someDate.toLocaleString('en-US', { year: 'numeric', month: '2-digit', day: '2-digit'}); output.set('thisDate', dateFormatted); You can add whatever number to the second line to add, haven’t tried subtracting. Also, the toLocaleString() without any modifiers outputs a date and time.

Generate random users in an Airtable base Simple workflow: Input required number of random user records. Push Go! 22 pieces of random information per record: Full name, Gender, Title, First name, Last name, Street, City, State, Country, Postcode, Timezone offset, Timezone description, email, UUID, Username, Password, Date of birth, Age, Phone, Picture large, Picture medium & Picture thumbnail Custom script gets randomuser.me data and creates records Works with free Airtable plan Full instructions with videos https://marcfletcher.gumroad.com/l/ixmfa

We are happy to announce the Java Client for Airtable. We created for educational purposes. Have a look at GitHub: https://github.com/Sybit-Education/airtable.java The client supports automatically object mapping. All CRUD-Operations (including Attachments) are already supported. But it is a very first version. Any feedback or pull requests are welcome.

What is Data Fetcher? A tool people use to import data into Airtable (Airtable is similar to Google Sheets). Used by hundreds of customers globally to automate their businesses. 100% remote. Profitable & fast-growing. What will you do? You’ll write blog posts for the Data Fetcher blog like this one and record YouTube videos like this one. You’ll learn to write search engine optimized marketing content for Google & YouTube. You’ll also learn how to use Airtable & Data Fetcher. You’ll be given the topics, e.g. ‘How to Import Google Analytics Da

Hi all - Airtable has officially launched a beta of the new consultant directory, where you will have the ability to get matched with a consultant or reach out to one yourself directly. We are thrilled about the potential of this program and its ability to help anyone accelerate their time to value with Airtable by making it easier to find the right solution for your specific needs. You can check it out here. The first cohort of consultants was selected based on an application and review process by the Airtable team. Consultants were invited to apply based on engagement data and community activity. Although applications are currently closed, those interested in getting added to the directory in the future can sign-up here to be notified when we’re accepting new applications for the next cohort. Huge thank you to those of you who helped to bring this to life - we ho

These are static tables I find myself using frequently when building bases for clients, so I keep a copy of them on their own in my account so I can easily copy-paste them into bases when needed. I’m creating this wiki to share them in case other people might want to use them, or contribute their own reusable pre-mades. To make use of these, open the base through the links below, then use the “Copy base” button (top right corner) to add a copy of it to your own workspace. Then, you can copy (⌘/ctrl + a → ⌘/ctrl + c) and paste the table desired into other bases as needed. US & CA States/Districts/Territories Includes Country, Capital City, and Postal Abbreviation.

Hi, I am looking to hire an airtable consultant to help me set up a (little complicated) insurance CRM. Who can help?

Here’s what I want to do. Export our entire CRM database (a subset of the data) to Airtable In Airtable, I want to monitor the DB for specific birthdays (e.g. 30th, 55th) When a DB member is within 30 days of one of those (or other) specified birthdays, using Zapier, I want to create an activity in our CRM. (I already have built and tested a Zap that will do this, but it may need some fine tuning.)

Hey Everyone, We at Softr.io have prepared a simple how-to article about creating a job board on Airtable. As we see more and more niche job boards popping up, we wanted to share this with a wider audience so that more people without tech skills can build projects like this. The article covers the following steps: How to create a job board from a template; Setting up a form to receive job posting submissions from users; Restricting submissions to logged in users only. Check it out here. Would love to hear your feedback and ideas! Cheers, Narek

Airtable has just released my latest app: My One Record. I wrote this app because I wanted a quick way to access linked records in a grid view without the distractions of other unrelated records. I have been personally using this app in my own bases every day ever since I wrote it, and it is such a mental timesaver when you need to jump between parent and child records. Here are some links: watch a video demo install the app from the marketplace purchase a premium license. To setup this app, your base needs … a collaborators field (that allows adding multiple collaborators) in the parent table a button field in the parent table to call the app a lookup field of that collaborators field in the child table a filtere

I wasn’t entirely surprised today to learn about the carnage over on the “Make” Facebook group, soon to be the former Integromat group. When Cleonis acquired Integromat I predicted there may be turbulence in its future. I tried to tell you. This is what big companies that get bigger through acquisition do best. There are some really angry customers because they apparently rototilled the framework, adjusted the terms and pricing, modified some long-understood concepts, and gave it a new name that even a Google PhD couldn’t find using the most advanced search queries imaginable.

Thought I’d show off a project that I use very often in my life as an Airtable administrator. GitHub

Hey everyone, Sharing an article I wrote on how we mange our entire community on Airtable and how it powers our community site. I’ve tried to keep the article short and sweet, hope you enjoy reading it as much as I enjoyed writing it! :grinning_face_with_smiling_eyes:

Have you ever wanted to display the information you have stored in an Airtable field on a form? Maybe you want to display an image from your base on your form? Your Airtable base :point_down: Your Form :point_down: Or maybe you want the form user to choose a specific record from your Airtable base in the form? Then,

Looking for a consultant to design a full marketing project management system that is currently using a lot of google sheets

Our nonprofit Association has an open Request for Proposals that may be of interest to Airtable specialists based in Canada. Please read the full RFP here. Interested parties should contact the email address included in the RFP. Thanks!

We are looking for a customized Airtable template/design to organize and streamline our client data. In addition to the usual contact info, we are keeping track of specific interactions, requests, needs, and observations. We would like to run any number of reports based on the data entered. Here is a google sheet that shows some of the types of information we are tracking: docs.google.com