The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
Introducing Default Field Values via new Scripting Block Brought to you by the team at BuiltOnAir & Openside/On2Air Overview Airtable’s Scripting block brings a new level of customization to your Airtable bases. The Scripting block will allow you to run scripts to enhance your bases and manage tedious tasks. You can do things such as create templates for records, prompt users, create custom reports, and much more. Once the script is added to your base, you can use it with the click of a button. We are creating a library of scripts for you to use in your Airtable bases. We have many more examples on the way. These scripts will give you an even better understanding of the data in your base and eliminate repetitive data entry. About This Script: Setting Default Values In this tutorial, we will show you how to set a default value for any record or field in your base. With this script, every time you create a record in your base table, it will automatically add the data you set as a
Dear community! :wave: We are super excited to launch the new version of Softr on ProductHunt today ! :tada: - the easiest and fastest way to build powerful web apps and client portals from Airtable, in minutes. No code required. No learning curve. :rocket: It’s now trending #1 and we would love to hear your feedback and get some love on ProductHunt! :point_down: Product Hunt Softr 2.0 - Build web apps & portals from Airtable, no code required |... Softr is the easiest and fastest way to build powerful web apps and portals from Airtable, in minutes. No code required. With Softr, you can build client portals, internal tools, marketplaces, online communities, resource directories and websites.
I’m working on an amateur project that involves outputting nice-looking text. I managed to cobble together something that serves my specific needs and thought I’d share it here in case it helped anyone else (and also so I can save the link for reference later). Many thanks go to @W_Vann_Hall for the sample base demonstrating how to extract the last name from a field, which was a crucial piece in my “finding the last comma” puzzle. Is there a PROPER name formula in Airtable? - #3 by W_Vann_Hall Goal: Given a list of items separated by commas, add an Oxford comma where appropriate My data has a rollup field which returns items separated by a comma and a space. Example: Moonbreaker Mountain Dreamwater Depths, Meltwater Loch Meltwater Loch, Dreamwater Depths, Blastfire Bog In lists containing one item, there’s nothing to change. In lists containing two items, I want the comma replaced with " and". In lists containing three or more items, I want the FINAL comma replaced with “, and” (preser
Hi everyone - excited to announce that I’m running a 1-day Airtable Scripting Bootcamp on Wed 16th June. Info and booking here: http://bit.ly/airtable-bootcamp This is going to be a live bootcamp, hosted on Zoom and it is targeted at any Airtable users who want to get started with Airtable scripting. The introduction of scripting to Airtable has been a big deal and opens up lots of possibilities for processing, automation, integration and so on. But, if you’re not a hardcore coder, how do you get started? This is what the bootcamp will tackle. We’re going to cover: Intro to the scripting block Adding the script app and orientation Getting data from your Airtable base Updating records with a script Deleting records with a script Creating records with a script Filtering your data Transforming/summarising your data Running a script in an Airtable automation We’ll also cover some JavaScript concepts along the way. This bootcamp is open to anyone, but is targeted at new and beginner level
Retool and Airtable make a great pairing. Airtable is great for managing data around almost anything. Retool is a great for building internal tools on that data. For instance, you use this Customer Success Airtable template and Retool to rapidly build a customer success tool (as we do in the video below). Or, you can use this Product Catalogue template and Retool to build a resource management tool.You could even expose a customer portal if you wanted to. While not exactly no-code (you’ll need a little JavaScript / SQL), Retool takes care of most of the hard work so you can just focus on building your app. If you are comfortable with Airtable scripting - then you’ll be right at home in Retool. We created a video tutorial that shows you step-by-step how to build a custom app using Retool with Airtable and our service - Sync Inc. Sync Inc is just an option here. It makes it easier to build your app on Retool. But you can use the Airtable API if you are comfortable working working with
I have just published a blog post about using Integromat to automate processes in Airtable which people may find useful - any question please fee free to get in touch! Link to Post
We at Softr have collected the 10 most used Airtable fomrulas with practical examples for those who want to get into formulas but don’t know where to start. After reading the article, you should be ready to apply those in your own projects. Enjoy!
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
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. :clipboard: New Form Fields Our custom form builder now also supports Date & Time field type, alongside the standard Date type. Add the field and it gets magically mapped to your corresponding Airtable date & time field. Moreover, we’ve added a Check
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. Direct checkout links & customer onboarding improvements If you’ve got your own website, or just a simple landing page somewhere and want to start selling access to an Airtable database, it’s now easier than
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 management: classes, workshops, RSVPs or employee scheduling. For salons, spas, gyms, clinics, catering, tourism, photography…etc. Catalog/directory: a community-curated list of restaurants, recipes, apps, events…etc. Marketplace: for anything where there is suppl
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 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,
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.