Show and Tell

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.

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

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!

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:

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

Hi there :wave: If you’re interested in learning how to create airtable charts with real-time data and add it to your website, I have created a quick tutorial for you. Main benefits include: Interactive charts, so your visitors can play with the chart. Real time data, whenever you update your airtable database it will automatically update the chart. Looks better than having an image chart on your website. Try for free, no sign-up required https://nocodechart.xyz/

https://jrosendesign.medium.com/10-days-til-launch-paytable-io-my-side-project-turned-labour-of-love-f8fbc49eb4fd

Hey Everyone, I recently shared here our introductory guide to Airtable that opened our Learn Airtable series. Here’s the second article that discusses the pros and cons (what we wish it had) of the Airtable API from our perspective. Would love to hear your feedback. Cheers, Narek

Hey Everyone, Our platform Softr.io is powered by Airtable, and we’ve been receiving a lot of questions from our users on different aspects of Airtable. So, we thought it would be useful to have an introductory guide that discusses what is Airtable, what it does and can be used for. We plan to cover other, more advanced topics as well. So, looking forward to feedback as well as topic suggestions . Cheers, Narek

Airtable is an amazing tool for quickly prototyping ideas. After working helping many teams build prototypes or production applications that use Airtable as a database, we compiled the six best practices that we see make these projects not only faster to build, but easier to maintain and scale. For instance: Setup a Dev Environment: Things can break as you build new features or adjust your base schema. So duplicate your base to create a “Dev” environment in case you need to revert back. This allows you to build with confidence. Use a naming convention to delineate lookups and calculated fields: Lookups and calculated fields can make it hard to maintain a clean data model and understand how your data is changing. So use a naming convention that helps identifies these field types (like and underscore → _) Create a quick README doc: It’s surprising how many

We’ve added some nice features to Softr.io with our latest release: :bulb: List Conditional Filters based on Role and User’s other attributes :key: Page/Block Level Conditional Visibility by all the user’s attributes :busts_in_silhouette: Bulk import your existing users Now you can pre-filter the lists and define block/page visibility based on the user’s role and any other attributes like name, company name, status etc. And it’s now possible to import a list of users at once from a .csv file. Details here: https://bit.ly/3rZvpna

Heya Community! :wave: A little while back I did a show and tell about BuiltOnAir, a podcast and website we created to bring together and highlight people building amazing things with Airtable. Some of you reading this have probably already been featured as a guest on the podcast, a service provider/product maker in the Airtable resources section, or a guest poster on the blog. We plan to keep featuring more in the future, but that’s not why I’m posting this… Airtable Universe metrics every month?! One of the most popular aspe

Introducing Paytable - paytable.io We’ve spent the last 4 months working on a new tool that helps your build a simple one-page membership site to connect your audience to your airtable bases. You can also embed the check out and log in to your own site easily. Our solution is an iframe reader where you shared view url is hidden. You can also optionally add us a collaborator to any of your bases and we will auto generate new shared view urls for you, on the regular meaning only logged in paying customers see your updated database views. Simple and secure. We’re currently in waitlist as we put the finishing touches together but you can learn all about the new tool and what’s to come here here - paytable.io

Hey Community, I’m hosting a FREE live master class next Thursday on how to query Airtable using SQL. Sign-up and learn the best tools to use (plus some basic SQL) to derive proper insights using your Airtable data. Click to register… :nerd_face: ! techiechic.co

Hello everyone :wave: AWS Lambda is a killer Airtable integration. With a little code, you can build integrations that are endlessly customizable, incredibly reliable, and economical at scale. So I wanted to share a tutorial that walks step-by-step through setting up a Lambda: docs.syncinc.so

Get freedom from being glued to your desktop and fuddling with the mobile app. Create and Assign Project Tasks using Voice with Airtable

For the Airtable scripters out there, here’s a few recent posts that you might be interested in :slightly_smiling_face: Scripts and Automations Import a CSV file A nice way to find duplicate values/unique values

First they replicated your base. Now they can write changes too! docs.syncinc.so