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
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.
To many, script development comes easily and it’s very much like speaking another language because that’s exactly what it involves. Imagine someone asked you to lecture about something but didn’t give you a clear indication of the topic or objective. Don’t force your consultant to read your mind. “Requirements” is a big fancy word that helps developers avoid mind-reading.
Hey Everyone, We’ve made a lot of significant updates and improvements on our product this month, and those are finally release. Here’s what’s new: :credit_card: New Pricing :star_struck: Custom Domain on the FREE plan :sandwich: Dynamically add more fields in List Detail pages :writing_hand: SEO improvements for Lists and List Details (aka URL slugs) :eye: Form Hidden Fields :new: New Blocks (Features, Pricing, CTA) :heavy_check_mark: New Template - Real Estate Agency :heavy_check_mark: New Template - Maker Profile :new: What’s New Page Performance Improvements Details here: http://bit.ly/3c67Zbc
Is there an easy way to show all “your” records across a base? No, not really. Which is why I’m developing a custom app do help do just that. Problem Say you have a table of [Projects], which has collaborator fields for {Project Lead} and {Project Team}, and another table for [Tasks] with a collaborator field for {Assignee}. If you wanted to look at all records which have “Kamille” in those field values, you could easily make a a filtered view in each table to do so. However, you’d need to repeat this for each collaborator in your base, and there isn’t an easy way to look at both filtered lists of projects and tasks in one place. Solution “My Records” allows you to select all or a subset of Collaborator-type fields (Single Collaborator, Multiple Collaborators, Created By, and Last Modified By) and filters records from Views of your choosing which have the currently selected collaborator included in those field values. By default, the selected collaborator will be the current user, b
Deleting empty records Sometimes a base ends up with empty records - records with no values in any fields. Here is a utility to delete them from a table. A table with several empty records Using the script The script asks for confirmation before deleting. Because there is no data in any of the fields, the record ids are shown. The table with no empty records: Here is the code: gist.github.com https://gist.github.com/kuovonne/8837d4c153ee1d1e4214412763b5c58e deleteBlankRecords.js /******************************************************************************* Title: Delete Blank Records for Airtable scripting block Author: Kuovonne Vorderbruggen Website: kuovonne.com Date Created: March 4, 2020 Version: 1.0 Copyright (c) 2020 by Kuovonne Vorderbruggen Usage License: MIT License ## Description This file has been truncated. show original
Hi everyone - announcing the upcoming launch of my new project - Airguides Airguides offers step-by-step guides to building Airtable bases for common use cases - a CRM/sales pipeline base or a holiday/vacation “request and approval” base for your business for example. The aim with these guides is to get relative newcomers to Airtable from a basic app to one that is humming along :slightly_smiling_face: The first guide - Build a Sales Pipeline App with Airtable - will be released later this week. I’ll post again here when it is launched or sign up here to get a notification for this and other guides. Thanks!
Check out this guide by one of the top Airtable experts on creating client portals using Airtable and Softr:
So I absolutely LOVE using Airtable… but I’m finding that using the browser is a huge CPU + RAM sink. So I’ve been working with a small team of developers on a totally new way to get around this problem. We’re calling it “Fractal”, an it’s a streaming web browser. It looks and feels exactly like Chrome, but it runs on a private CPU in the cloud. Think of it as Netflix for web browsing — your computer is just receiving pixels and doing none of the work. It’s a super lightweight way to browse, and it also takes advantage of the fast internet speeds of cloud data centers. Now that Fractal is in its “beta” phase, I’d love to give out some demos to all the Airtable users who need their RAM back. Feel free to message me if you want to give it a try or chat about how it works.
Hi Airtable Community :wave: I’m Engjell, I’m working on https://nocodechart.xyz/ to create an easier way for no-coders to create and export charts to their websites. An airtable user reached out to me and asked to build an airtable integration and now it’s live on my website. You can create charts and export them to your website with real time data from your airtable database. You paste some data in the required columns and the chart will be generated. You copy a link and paste it to your website and you’ll have the chart on your website. When you change data in airtable database it will automatically update on your website. A quick video Loom | Free Screen & Video Recording Software
Hey awesome Airtable curators! I’ve spent the last 6 weeks working super hard to build my new tool - Curateable, which turns Airtable databases into products in seconds. I was struggling to find a platform to monetise databases securely, without having to custom build an integration with stripe, so I built one. You can now sell secure access to your databases with single payments or subscriptions and get total control of who and for who long customers can access your base. How does it work? 1) Connect your database 2) Customise your landing page 2) Set a price and promote It takes less than 10 seconds to auto-generate a secure landing page and you can start selling right away. We’re currently in public beta and offering free plans on all revenue up-to $150 then it’s $15 p/m to use ongoing. Here’s a detailed guide which explains how our product works and why we created this purpose built tool to help you sell secure access and monetise your databases. Thanks, any questions, we’re pret
Here is my solution for tracking time in my job. Scenario - I’m an owner/field service technician. I use Airtable 90% of the time on an iPhone or iPad and need a way to track time per job and/or the same job with multiple visits. Obstacles - Airtable mobile app for IOS cannot run apps or scripts. Solution - Two check boxes (START JOB & STOP JOB) to trigger two ‘last modified’ columns(Start Time & Stop Time). Then a datetime_diff formula in TIME(MINS) to calculate the onsite job time in minutes. - DATETIME_DIFF({Stop Time},{Start Time},‘m’) There is an Automation for every time the STOP JOB is checked. It creates a new record in the TIME table and links it back to the original TASK #(job). Back on the TASKS table, I have TOTAL TIME rollup the sum of all the minutes. Finally the calculation of hours and minutes is completed in the TASK #, but only if the STOP JOB is checked.
Formulas in Airtable can be as simple or as complex as you need them to be. When writing a formula with many conditions it can get particularly difficult. You may have run into the case yourself where you have written a complex formula and somewhere in that formula a part of it isn’t working as expected. It can be hard to find that part. For example, I had in mind an Event Planning formula that could: Give me the number of days, based on {Start} and {End} dates, that an event is occurring (returned as the value “x days”) If the event is only one day, give me the number of hours instead (returned as the value “x hours”) If the event is only for 1 hour, I don’t want the value to read “1 hours” - I want “1 hour”. This is the formula I ended up writing: IF(DATETIME_DIFF(End,Start,'days')+1 > "1", "📅 "&SUM(DATETIME_DIFF(End,Start,'days')+1)&' days', IF(AND(DATETIME_DIFF(End,Start,'days')+1 = "1",DATETIME_DIFF(End,Start,'hours') = "1"), "🕒 "&DATETIME_DIFF(End,Star
I wanted to share our new Airtable app with you - On2Air: Amplify On2Air: Amplify is a brand new way to view your Airtable data. With custom views, a full-screen viewer, record customizer, and editor, On2Air: Amplify will change the way you use Airtable! :new: New users start with a free 14-day trial, so you can install the app directly from the marketplace today ! For the first 25 new customers, you can use the code AMPLIFY100 to get a $100 discount on any monthly or annual plan for either a bundled plan or a single app. If you’re a current On2Air customer on a bundled plan, you have Amplify already ! Go to your base in Airtable and install the app directly from the marketplace. How Amplify can help you No more scrolling through long tables of records or having to individually open and close each record Create and customize your record views in your Airtable base by displaying or hiding fields, so you see only what matters most View documents, images, text fields, or website
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.