Show and Tell

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

A bunch of new features we’ve just released on Softr.io: :mag: ‘Search By’ - control which list fields are searchable :paperclip: Embeddable Blocks :writing_hand:t2: New & Better Rich Text Editor :heart_eyes: New - Community News! :rocket: 100DaysOfNoCode by Max Haining :headphones: Softr Tutorials by Gareth Pronovost More details here: http://bit.ly/3q6Z0tZ

Airtable Turn ugly formulas into pretty ones - Airtable Universe If you write formulas for Airtable Bases you might want to check out this tool, packaged as an Airtable Base. ‘Orc’, a formula ‘Pretty Printer’ will format... This is the second release of Orc – V0.2 – prettier and greener. If you write formulas for Airtable Bases you might want to check out this tool, packaged as an Airtable Base. ‘Orc’ , a formula ‘Pretty Printer’ will format a complex Airtable formula into a standard set of uniformly spaced code. Orc changes this: DATEADD({NextMonWeekMonth(2)}, IF({OnWeekdayDOW}<WEEKDAY({NextMonWeekMonth(2)}), SWITCH({RecurrenceType}, ““Weekly””, {WeeklyDate(2)} , ““Monthly:ondayofthemonth””, {Monthlyondayofmonth(2)} , ““Monthly:onacertainweekday””, {Monthly,certainweekdayDate(2)} , ““Monthly:onlastweekday””, {Monthly,lastweekdayDate(2)}, 1+{OnWeekdayDOW}-WEEKDAY({NextMonWeekMonth(2)}) ) +7*({WhichWeekas#}-1)-1, ‘days’) I

Some nice additions to Softr.io that I’d like to share with you: :mailbox_closed: Personalized Lists (aka Conditional Filters) ↔️ Automatically Sync Softr Users to Airtable :crystal_ball: Multiselect field type in forms :heavy_check_mark: New template - Paid Online Courses Platform :heavy_check_mark: New template - Travel Destinations More detailed overview available here: http://bit.ly/3sphpUz Cheers, Narek

Hello, my clients use airtable forms on mobile all the time . but if they wait too much before validation, the form reloads and data are lost. i found ways to block reload but this is too complicated for my clients. any solutions ? waiting for an airtable offline solution… ?

Are you tired of juggling multiple Calendar views to look at your records across multiple tables? Check out this Custom Block which can display records from multiple tables in one calendar interface! Video Demo: Interested in gaining access? Use this form: https://airtable.com/shr8KDRmzY3LcLEw1

Hey everyone! My team at Unito just wrote a piece on how we use Airtable to create a competitor ecosystem, and I thought it might be useful to people here! Essentially we create a base with fields titled ‘name’,‘type’,‘description’,‘pricing model’, and so on. Additionally, there are some tips to building your own competitive landscape on Airtable. This really helps us keep an eye on the competition. Do you use Airtable for the same thing? Are there any other fields you use that helps you accomplish this? Let me know if you found this useful, our team uses Airtable for many things, and we’d love to share the other ways we use it!

Hey there, If you’re looking for a way to set up an educational platform on Airtable to share your knowledge and skills, here’s a brief guide explaining how that can be done using the Softr no-code platform. Cheers, Narek

I tend to work in the Kuiper belt of complex and challenging integration projects at scale but I’m not isolated from occasional simple problems where I can learn something while helping others. I also advise many investment groups and companies concerning the bets they place in no/low-code systems and vendors. With vast experience in fishing woefully architected systems from a cesspool of low/no-code Airtable Goldbergian buffoonery, I feel compelled to offer this advice if you are seeking the right person to lead the development of your future Airtable tech stack. An appeal to candidates who are low/no-code “experts” is risky because it will entice and attract people who have many skills that have done some amazing things with Integromat, Zapier, and other platforms. But there’s another side of no/low-code power-users that may result in the creation (or expansion) of costly, unreliable, and largely unsustainable processes. Some of these candidates seeking work will be ideal; most will

Using your Airtable bases, now you can easily create client portals, paid member-only community, sell digital services, content, courses, using Softr.io as the frontend! :rocket: Softr now supports: :money_with_wings: :bust_in_silhouette: :lock: Login / Signup functionality - Authenticate users using your Airtable bases :credit_card: Paid Content (Stripe Checkout) - Request users to pay recurring fee or one-time payment to get access to content from Airtable :eye: Conditional Visibility based on Payment, User Email & Domain - Restrict access to entire page or sections of a page, depending on user logged in status or payment conditions :robot: Dynamically connect Softr frontend to Airtable - now 10x easier :busts_in_silhouette: Manage registered users in your Softr application - no need to store passwords in Airtable :mag: Search, Sorting, Pagination on your Airtable data - all out of the box :arrows_counterclockwise: On the fly support of any Airtable changes (n

Hey there! I work for Unito, a company that creates integrations between tools, like Airtable. We recently wrote an article about how we use our own product to bridge Airtable and Asana! When we decide what our next integration will be, we keep track of information, like API availability and user demand, in an Airtable base. Then, to send this information to other teams, we track it in Asana. You can read about our use case, and learn how we’ve been loving Airtable, here! I’d love to hear everyone’s thoughts, and how your team is using Airtable. :slightly_smiling_face:

I’ve been collecting interesting AirTable plugins, integrations and helpul how-to articles. Enjoy! Airtable AirTable Research - Airtable Explore the "AirTable Research" view on Airtable. Feel free to add to this list! Airtable AirTable Add-ons - Airtable Fill out the "AirTable Add-ons" form quickly and securely on Airtable.

Hello, I am new to the community. I am trying to setup a database for our acquisition company. I have leads that own multiple products and need to be able to sum up all the products in one place. This works perfectly with grouping. However, my issue is assigning a caller to these leads. I want to link all the lead records with the same names to each other and my caller have a summary of all the products, values and one lead contact field. With grouping I can assign a collaborator but they have to be assigned to each one and it breaks the summary. Can anyone tell me how to complete this correctly? I was hoping another table named leads where it listed the owners once and rolled up the values of all the associated records to that owner.

Simple version (so you can cut and paste, and put to use) Link to demo base:TestLab Status Airtable TestLab Status - Airtable Explore the "TestLab Status" base on Airtable. Table 1: Latest Status LEFT( RIGHT(status_&"", LEN(status_&"") -FIND({Last Updated}&"",status_&"")-23 ), FIND({Last Updated}&"", RIGHT(status_&"",LEN(status_&"") -FIND({Last Updated}&"",status_&"")-23) )-1 ) Last Updated is just pulling the latest date for the linked records in Status Update Records. TheStatus_ is looking up all of the status-helpers for the linked records so they can be searched through by the Latest Status formula. Table 2: Helper-status field is simply {Status Date}&Status&{Status Date} Its easy enough to repeat for multiple fields, I recommend using notepadd++ to copy the Latest Status formula to find&replace old field name the new one. . . . . Detailed Version broken down version

Need to know what type of data is being returned to a formula from a field? What if that field is a lookup field? The common answer for the latter is, “It’s most likely an array,” but there are times when it’s a single value, and the correct type for certain fields is not always obvious. To help save myself (and, I hope, many others) a lot of desktop head-banging, I dove deep into every field type to figure out what’s what, and captured my findings in a table, naturally. :slightly_smiling_face: You can find the results of that effort here: Airtable Airtable Field Reference - Airtable Explore the "Airtable Field Reference" view on Airtable. I plan on updating this table regularly as new field types are added, so feel free to bookmark this shared view, as it’s gonna be around for the long haul. On a side note, this table is the first resource added to my brand new site: AllAboutThatBase.tips. It’s pretty bare-bones at the moment, but mor