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 const TABLE_NAME = config.TABLE_NAME; const INCREMENTED_FIELD_NAME = config.INCREMENTED_FIELD_NAME; // Query all records, sorted by number descending (biggest numbers

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 products, galleries, job boards + more. Hidden Airtable shared view urls Users don’t need Airtable accounts Add to your site in under a minute No additional Airtable fees Revoke access, grant access. Import sub

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 Master Calendar - Apps - Airtable Marketplace Manage events from multiple tables with ease on Airtable with the Master Calendar app. Register for a KamillionaireApps account to unlock all the features!

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 using the REST API, but it takes a bit of wrangling and time :cowboy_hat_face: We wanted to simplify the problem and completely skip the tedium of working through the nuances of the API. So we wrote up a tutorial on how to easily read fro

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 Rating Button Divider Check out other updates and news here: https://softr.io/whats-new

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! :boom: New Feature: Search Dashboard and Filtering Welcome to the brand new Search panel! Now when you search, every field and every value in the field will be searched automatically. Example: ‘in progress’ will find any record with the Status of ‘In Progress’ ‘quad’ will show any record containing ‘quad’ or ‘Quad’ ‘63’ will show any record with and amount containing ‘63’ or ‘63,000’ You can also configure your search to refine and search only specific fields. Then, you can choose you how you want the search displayed by choosing a primary display field, how many records are displayed, and how many fields to display. :boom: New Feature: Navigate between tables seamlessly You can now switch tables from the Amplify da

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 Set cell as ‘unticked’ to remove the companies I have already contacted You can use this script to do anything however,

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 teams don’t know about all the automations and integrations that are changing data within their base. So take a moment after each

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 aspects of BuiltOnAir has been the Universe Metrics, where we post all the new creators and bases in Airtable Universe each month. We also list the top 10 creators with new followers, and top 10 bases with new copies or likes (screenshot below). It’s been super fun for us to see what’s happening in Airtable Universe and find all the useful bases shared there each month, and hope it’s a valuable tool for you also! You can check out the Universe Metrics here. I plan

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 Easily charge subscriptions for Airtable access Build a subscription business based around your curated Airtable content. Customisable and simple one-page sites Add your own branding, colours and fonts. Or… embed the checkout and log in to your site with just one line of code.

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 How to Query Airtable Using SQL During this free live online master class, we’ll explore 5 tools that will add limitless query abilities to your Airtable base using SQL. Giving you the ability to explore beyond the base and discover Airtable’s true database capability.

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 AWS Lambda | Sync Inc Sync Inc replicates Airtable to a Postgres database, giving you the best of both worlds. The tutorial uses our service, Sync Inc, as an example - but it’s really a jumping off point for any server-less integration. With Airtable’s scripting block now supporting fetch, Airtable integrations with Lambda are easier than ever. Of course, would love to hear any questions and feedback. How are you using Lambda with Airtable? Cheers, Eric Goldman

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 Reference | Sync Inc Sync Inc replicates Airtable to a Postgres database, giving you the best of both worlds.