Builders Board

Hi Everyone, Many of us have faced a situation when Airtable suddenly goes down. Since our platform Softr is also heavily dependent on Airtable, we’ve prepared a brief guide on what steps you can take when faced with such a situation. Hope it’s useful. Cheers, Narek

I have a very small business … but big dreams. I set up my base with the help of a few people, but I don’t think I can accomplish all I need all myself. Backstory: I have a small bed and breakfast, and I use a Booking system called Hostaway to track reservations, the Hostaway API is connected to my base with a script that’s hosted on AWS. I need a lot of help with the functions and automation of this data, CRM and Financials (which are mostly coming from stripe). I was hoping to create a Junction table (I don’t even know if I"m using the term right) to combine the Hostaway data and the Stripe data, so that I can tell which booking is paid in full and which are not. I also wanted to track gift certificate purchases and link them automatically to the booking used with the gift certificate and the consumer who purchased the gift Certificate (guest vs. customer). I have this part almost done … but it’s not connecting automatically.

Lots of exciting updates and news in Softr’s May update: :link: Linked Lists You can now display linked records in your Softr app. If you have two (or more) tables linked to each other, now you not only can show data from one table but also all the related data from other tables on the same page. Check out the documentation to see how that works on a specific example. :heavy_check_mark: Custom Form redirect on completion Your forms just got superpowers! Until recently the form submission would only change the Submit button color to indicate success. Now on form completion, you can either show a success message to your respondents or send your respondents to another page in your app. Check out our documentation for more details.

Hi guys, Joel here :wave: Over the last two weeks I’ve been working away on new features, updates and lots of improvements for Paytable.io. A membership platform and secure reader for Airtable. I recently dropped a thread over at twitter all about this, you can follow me on my journey over there if you want to keep in the loop with product progress as it happens. ​ Paytable is now becoming the perfect way to monetize any of your curated bases including research products, info databases, lead-magnets curated galleries, jobs-boards, tools lists, checklists and whatever it is that can provide value to your audience. Monetizing Airtable data has never been easier and Paytable resolves the issue of sharing actual airtable shared view urls which means no more leaked access links.

Hey all, We’re a small company selling a very wide range of products with very shallow depth of inventory. We have buying / production / ops teams based in different locations, and they all need to be able to upload / access / update information regarding products, inventory, etc. In the past, because so many people have been involved with that buying data, we’ve had issues “baked in” so we’re looking at setting up Airtable to validate and verify data, and prevent mistakes from being created. We also use Shopify as our main inventory management system, but their IMS (Stocky) is very limited in terms of functions, and doesn’t really support inventory movements very well. Ideally, we’d like to set up an integration where Airtable holds all inventory, and records all inventory movements (deliveries, transfers, write offs, etc.), as well as uploads and updates Shopify products (inventory quantity, out of stock, new product uploads, etc.). We’d like to find a

I have a cool table that collects all the trade opportunities that i get. I can also do a calender view on it. the only thing i need to figure out is how to showcase the calendar view by points missed instead of event. Any ideas? I am using the free version so far.

miniAppMaker is a tool that allows anyone to make a mobile app without coding by using Airtable as the backend. Here’s how it works: Design your app in Airtable Add your Airtable IDs (API, base, tables, fields) to miniAppMaker Test your app. Wa-lah! This project is inspired by Airtable’s mission to “democratize software creation”. People are already doing amazing things with Airtable. We believe its power can be magnified if we allow people to turn their creations into mobile apps to share with the world. Especially when an entire app can be made in 30 minutes! Examples of apps that can be made: Internal business tools: operations manager for workflows, processes, tasks, inventory, delivery tracking…etc. Appointment/event mana

We were thrilled to work with James Q Quick to make a video to show how to easily write Airtable queries. Had to share it with this awesome community: In the video, James shows how to replace complicated filterBy statements with SQL using Sync Inc. It’s just another great way to work with your Airtable data in scripts and other apps.

Hey Everyone, Airtable date formulas is a powerful tool that lets you perform date-related calculations, set deadlines, apply timezones and locales, and much more. But sometimes dealing with formulas can be a bit intimidating. So, we’ve prepared a list of most commonly-used date formulas with concise explanations and examples that you can review and start using right away. Enjoy!

Hello everyone, I recently saw a topic in this section about the “Autonumber” field. Some of the problems mentioned are not relevant in my opinion. Here are my requirements : Auto-increment a field Always take the last generated number + 1 Never change a generated number It does NOT : Recalculate numbers when a record is deleted Recalculate any number when record is moved … I use this to generate invoice/quotation numbers. I made a very basic script to handle this, feel free to copy and use it on your Airtable base. /*********************************/ /* A better Autonumber */ /*********************************/ /* Author : Florian VERDONCK */ /* Website : airtablefacile.fr */ /* Version : 1.0 */ /*********************************/ let config = input.config(); // Script configuration cons

I’m working on a Squarespace site right now for a friend, and they want to collect information on the site. Squarespace’s abilities with forms are better than nothing, but not by much. Luckily, I’ve already turned my friend into a huge fan of Airtable, so he’s excited that we can collect the data in Airtable. Squarespace gives you the ability to embed code in a page/post, so this is incredibly easy. They give you an example of embedding a Wufoo form, but you can use the exact same strategy to embed an Airtable form. Create your form in Airtable. Click the button to get the Embed code (use the adjust height checkbox to make the form look better). Create a Code block in your Squarespace page/post. Copy the form’s Embed code into your Code block.

Working with a friend, and we are looking to build a project management type solution on-top of airtable. I am looking for the following: Someone to help me structure my base/tables in the best manner Someone who can visualize our data into a spider graph in real time (will provide an example of what I want it to look like). I have some specific use cases in mind. Please, just book some time in my calendar (calendly.com/booksam) so we can chat. I want to deliver this potentially by the 3rd week of May. Thanks!

I joined Aron on the Automate All The Things stream to show how no-coders & low-coders can get started with APIs by pulling any data into using https://datafetcher.io/.

Hey awesome folk of Airtable!! For the last 5 months I’ve been working on a membership & subscription management tool to sell secure Airtable access directly to your audience. I had some bases I wanted to sell read-only access too but was struggling to find a tool to do this. I love Airtable’s UI and it’s sortable, searchable features. I didn’t want to use an Airtable to website type of builder, because let’s face it. It’s never as good as how your Airtable bases look fresh off the press. So I set out to build a tool that would basically ‘host’ your readable Airtable bases and build a membership platform around it. Super happy to announce it’s now live! Introducing Paytable An all-in-one tool to monetise your curated resources, checklists, lead magnets, research p

Well, after all this time, its finally here: my custom app Master Calendar. What it does: Master Calendar is an app for Airtable that allows you to display and even edit records from multiple tables in one calendar interface as labeled, color-coded events See it in action: Get it from the Marketplace: Airtable

When you want to build custom tools or websites on your Airtable data - then you’ll be using the Airtable API and almost certainly some JavaScript (in this case Node.js) to work with your data. Soon you will probably start asking questions like: How do I paginate through the Airtable REST API? How do I manage the 5 calls / second rate limit in Airtable’s API? How can I find specific records using filterBy? How do I use the API to return linked data from several tables? TL;DR - the answers were just as tedious to build as we thought. So we built a tool and wrote a tutorial on how to skip the API and use Airtable as a database. You’ll find many iterations of answers to these same questions here in the Airtable community. Yes, all of this is possible

Softr’s (a no-code platform for building web apps powered by Airtable) latest release has significantly improved the List & List Details blocks. Until recently, our List & List Details blocks that pulled data from Airtable had a fixed layout and a limited number of fields to choose from. You can now dynamically add as many fields as you like with as many types as you wish! We now support the following field types : Simple text Simple text (markdown & HTML formats) Email Heading 1 Heading 2 Heading 3 Tags File Video Audio Image Gallery Embed (e.g. Calendly) Google Maps

We a are commercial construction subcontractor. We are looking for an Airtable Dashboard expert who can help us pull data based on certain criteria to create visual decision making tools.

Hey Everyone, Our latest article in the “Learn Airtable” series explains how date formulas work and how to use them. We’ve provided detailed explanations and practical examples, so it will be helpful for both beginners and those looking for a refresher. Cheers, Narek

Hey Airtable fanatics, We’ve made some big updates to On2Air: Amplify! Start a free 14-day trial We’ve revamped the layout and made it even easier to quickly create view types, change layouts, search records, and switch tables. Check out these new features!

Part A – build one or more base(s) of 3rd party architectural product information (lighting and electrical equipment for commercial architectural projects) that we specify on a regular basis. This may have 10 to 20 data points for each entry. Part B – Create a template that allows my team to create a unique schedule for an individual project that will draw information from that master base. When we need to add something new, I want to add it into the project, but have that information propagate back into the master database also. we will have PDF files associated with each entry, but any PDF may be usable across several base data fields. ie product A has a PDF data sheet, and we carry 10 versions of that product in the master base, each entry needs to have that PDF tied to it. Initially, we should sync up on a zoom call for 15-20 minutes, I can demonstrate how we do this with Google Docs (and why it has serious faults). thanks Mark

Hey everyone! My team at Unito just wrote a Beginners Guide to Airtable! It covers the dashboard, workspaces, bases, and more. I thought it would be helpful to anyone who’s new to the community. Let me know if you found this useful, or if there’s anything to add :slightly_smiling_face:

Hello! We have recently created a base on Airtable to track the students our nonprofits serve. We also just added the Send SMS app so we could, for example, text all the students that hadn’t completed a particular milestone. We realized, however, that the app doesn’t support incoming messages. Airtable Support shared that it’s possible to get those messages back into Airtable either by using the public API or using an integration platform such as Zapier. We’re needing someone to help with this integration. Ideally, the outgoing and ingoing text messages could all be viewed by student record within Airtable. Additionally, we’ve created a few forms via Airtable and would like help switching the links out on our custom app. The previous forms were feeding into Salesforce which we were using before Airtable. Thanks!

I made this script which allows you to compare two lists based off a field value, then modify a checkbox when matches are found. My use case example: I create a custom list of contacts to email about a product by selecting a checkbox next to who I want to send to. I save this list of contacts as a view in Airtable by filtering where contacts have a ticked checkbox. I make another list of contacts to email about yet another product, however, I want to make sure that I’m not sending this to the previous contacts and their companies I sent to previously. In this case the script works as such: Table is my database Reference view is my first contact list view View to Modify is the second list I want to compare to the first Match field is the ‘Company’ field (string in airtable) - this could be anything Field to modify is the checkbox which is ticked for my second view

:speech_balloon: Actual Scenario: When a member of the team (there are 5 members) makes a question about a certain proyect (we have many at the same time, around 100) the related client receives the question automatically in its email. But in order to answer he has to go into our portal (we use miniextensions.com) log in, find the question and answer it. Which is quite a slow process. :star_struck: Desired Scensario: When a client receives a question he can directly reply the email, and his answer will be updated to the related record. Looking for quotes. If interested write me to t.vacanarvaja@andexgroup.com Thanks