Builders Board

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

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 Air

Hi, my company (filestar dot com) offers automated file conversions services for Airtable. For example, we can build a flow where if you upload file X it gets automatically converted to file type Y. We also can do almost any automated image manipulation (like adding a watermark or text, cropping etc). Contact me at niels@filestar.com to get started.

Hi i need help for getting pull data from Airtable directly to show it on website instead of embed ! The objective is to speed up the loading time by spinning something up with APIs. visit https://www.open-source.in/project/index to see what is needed Thanks Ashish

Hello. I’ve created a functional specification for a checklist form that would be used on a smartphone. The checklist is to help me with my professional work, but could be customised for any quality-control process. Would anyone like to help me implement it?

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

A non-profit organisation in Brussels, Belgium is looking for an Airtable consultant for a full implementation. Please contact me if you are available, so I can shere the description of needs with you. Misha

Hi, I’m new to Airtable and I’m trying to learn it to see if it would be the best tool to support our community response team. Our needs may evolve, but we rely on completely voluntary work. It might be best if you just join our Slack space and help advise us along the way. Please feel free to email me at yjlee0824@gmail.com.

Hi, We’re a food and beverage company with several brands that use Airtable for everything. To name a few: Project Management Inventory Tracking Investment Portfolio Expense Reporting Specification System Create a survey/form asking multiple stakeholders to rate an organization. Take that information and use Page Designer block to present the summary information and data to allow a group to assess and vote. Recommending and creating blocks (like pivot tables) to help many stakeholders see summary financial data. A general review of our base to offer suggestions with how to use it better. One-off questions I might have on how to enter and link data. Use zapier to import data from other sources & connect different systems If you have experience thinking through this type of project, please contact me with your rate, background as an airtable consultant, and questions about this. No

In light of these unprecedented times, we’ve been amazed to watch our Airtable community and champions rally, creating COVID-19 related bases in efforts to support individuals, industries, and local communities. To ensure we can circulate these resources as broadly as possible, our team will be creating a catalog of resources for re-use in our Community Mobilization category in Airtable Universe. If you’ve created a base you think others might find useful, you can share that base with us, along with best practices for use, by mentioning @airtable in your social channels (Instagram & Twitter) or by sharing the base directly right here in our community forum. You can also post the base in

Hi Everyone :wave: We tried to look for a good way to edit existing records using forms, and couldn’t find a good one. So, we wrote down all the things we didn’t like about the existing implementations and tried to make the best possible solution, so here we go: miniExtensions

Hello! We’ve all been busy enjoying the holidays, but it’s a new year and it’s the best time to get your finances in order—whether for your business or your household. We’ve seen great things come from the community forum and we want your help make better budgeting tools in Airtable. If you’ve got a great idea, please share it with us! Here’s what you need to know: Show us a great way to use Airtable to create a budget (or anti-budget). You don’t have to be an Airtable expert. Check out this template and guide for a helpful starting point. For extra credit: we’d love to see bases that use linked records,

Hello We have built a system to help our group nunheadknocks dot com deliver community services during Covid 19 pandemic. We are desperate for an airtable guru just to help us on a couple of things including the above question. Hope someone out there can spend some time helping us. Many thanks Clive

Hi! We have been using Airtable for a couple years to host our summer camp student and leader database. We are looking to streamline a couple things like: Write scripts to produce specific reports for printing Consult on our integration with our squarespace site A few other various scripts to streamline the registration process We are a non-profit but are looking to hire a consultant/javascript engineer for the right price. Thanks!

With schools closed and many students switching to school-at-home, it can be difficult for both students and their parents to keep track of all the assignments and live online classes they suddenly find themselves having. This base blends time-tested practices used for years by many school-at-home and homeschooling families with the ease of Airtable’s available-on-any-device technology. It leverages calendar views, search block, summary block, and fun emoji to make it easy to see what needs to be done. Perfect for students who can now get Airtable Pro free for two years. This planner is simple enough that a middle school student has used it independently, yet it is powerful enough for high school and beyond. For elementary students, parents should plan to set up the assignments, but even young students can check off their own assignments. For pre-readers and emerging readers, just use emoji for

The Hidden Side of Script Block Development Script builders are forever optimists. When they hear statements like this, it’s like a red cape to an angry bull. It would be nice if the app did this simple task. We hear these words and our synapses begin to spark. Soon after the request sinks in we fly into action with every belief that indeed, it’s going to be as simple as the user described and it will undoubtedly and magically emerge from our fingers before we can type - this is a complete and utter distraction that I should have ignored. Every human on this planet is able to sing pitch-perfect just like Brittany Spears - in their mind. Likewise, developers have no trouble envisioning and writing an entire BUG-FREE program cerebrally and seemingly in seconds. Your butt hasn’t even touched the chair and you’re already writing the first lines of code, anxious and eager to see your foregone [requirements] co

I have an idea for a large system to track all of our department’s interactions with the outside world, and while we have some pretty good internal resources for executing, I would like someones assistance in designing the overall system and helping with some of the implementation.

Just wanted to say a huge thank you to the airtable team. As an educator, looking ahead to school closure, you have saved the day! My students in 2nd grade are already able to use it by themselves. Now, I can just send home the links and my students can go ahead with their studies and have the comfort that with so many things different they know how to use it! Thank you!!!

Hi Airtable! I made this using using Google Docs template, Airtable and Integromat. I thought I would share this as a bit of a “lift”, considering what’s going on in the world. Mary Kay

We’re starting to highlight individuals and communities who are helping one another. Today, we wanted to share a recent example shared by Chris Dancy who created an Airtable template for neighborhoods to use in conjunction with Nextdoor to mobilize his neighborhood of 800 people. This base was developed by @chrisdancy to help local neighborhoods connect volunteers with skills, resources, and facilities to support people in and around their neighborhood. You can view and copy the template (and related quick-start videos) here on Airtable Universe. We hope you can leverage something like this within y

Hi, I’m trying to generate an automated email that lists all due dates in a content calendar that are today or overdue. I’m using Integromat because it has a time feature you can trigger at certain time intervals. Zapier seems to only trigger when there is change to a table. I’ve been able to pull bundles out of airtable using the Airtable module. I’ve been able to pass those through a filter, to select those bundles with today’s due date that haven’t been marked submitted. I’ve been able to use the Table Agregator module to recombine the bundles into a single table. However, I’m struggling with having the gmail function spit out that Table in a way that makes sense. Does anyone have a template for doing something similar to this that they can share? If not, are there any good tutorials about getting data from a Table and then expressing it in meaningful form in an email? If no one has any answers, are there a

Why these scripts In the scripting block, in order to get cell values from the records returned by the selectRecordsAsync() method, a script must use the getCellValue() method. These two helper functions are designed to make future access to cell values more accessible to other parts of a script by turning cell values into object properties. Record values as object properties Example usage: let records = await getRecordsAsList(table, fieldNames); recordId = records[index].id; recordName = records[index].name; fieldValue = records[index].fields[fieldName]; Here’s the code: gist.github.com

Hello, I need help with the following Adding months onto a “date” The forecast date in DD/MM/YY format Record information broadcast onto a PDF form Hope someone can help.

Greetings! We run a small firm that builds low-code solutions for our clients. Our focus started in Airtable, but has now expanded to include Coda and we’re looking to onboard some new sub-contractors. If you’re interested in joining our team, please fill out this form and let us know a bit about yourself. Our ideal candidate has experience building relational databases, as well as automating processes with Zapier. All work is remote and we’re hoping for candidates with 20 or more available hours each week. We are looking for sub-contractors interested in both Development and/or Project Management roles.