Show and Tell

Hello Airtable Community! If you are an active consultant/power user with Airtable, this announcement is for you! The team at Openside is opening up a new class of our Opensiders Expert Group starting in September. We ran our inaugural class over the last few months and its been a huge success for those who participated (see testimonials below). We do deep dives into all things Airtable and how to be better consultants/Airtable users. Many of the popular names you see here in the Airtable forums participated in this first class. If you are a consultant and/or power user of Airtable, we want to hear from you. Its free to join and participate - we only ask you commit to joining as many virtual sessions as possible (we meet 2x/month) and sharing your knowledge/experience with the group. We are capping the class at 20 people, so be sure to sign up ASAP. Full details, video intro, and sign up form can be found here: https://form.jotform.com/92659069504163 Here is what members of our f

Hey Everyone, Softr has lots of news and updates this month, which I’d like to share with you: :2nd_place_medal: #2 Product of the Month on Product Hunt :blush: And we couldn’t have been more excited to have Ryan Hoover use Softr to build one of his projects: https://lnkd.in/gTFX2FMi New Features and Improvements :busts_in_silhouette: Global User Groups (for view & edit rights) :rocket: Clone a template with 1 click - see the magic instantly! :gear: Easier & faster Airtable setup flow :gem: Theme - new name, new look & feel :heart_eyes: Settings - new look & feel :sparkles: Table block :bust_in_silhouette: Redesigned My Account area Community News :gem: MadeWithSoftr - showcasing our user’s apps: Made with Softr :heart: Softr < > OnDeck Partnership: https://lnkd.in/gxrXikr4 :rocket: Connect Airtable to any API with Data Fetcher: https://datafetcher.com :spiral_calendar: What’s Next? Edit data in Softr app (Airtable records) New templates

Hi Airtable! I was wondering if anyone has an example of an Airtable base embedded into a website. I wanted to see how it works in a website. Thank you, Mary

Hey Everyone, If you’ve thought of building a client portal for your business, check out or new article that explains the benefits of a client portal and in which cases it’s applicable as well as how it’s possible to build one using Airtable. Cheers, Narek

The other day a friend of mine watched as I imported 7,000 support tickets from Jira into Airtable and then auto-tagged them in less than a minute. He was amazed; I was yawning. I suppose it’s a pretty cool thing, but we often get good at something(s) and forget about how much time they save and possibly how much more useful the data becomes when we attend to the seemingly little things like consistent keyword tagging through automation. I use my Airdrop framework to do this - it’s a simple script management system that allows me to use ordinary javascript functions in Google Apps Script (or in Airtable) to perform acrobatics on Airtable data and all without setting up a new API app every time I need a new API process. But I think you can also do this through Zapier, Integromat and your own API code of course. Airdrop allows me to frame an API process in a pseudo-code script like this: Once this script is made “active”, Airdrop will run this function passing the support Titles field

Hey Everyone, The Airtable community is among the most dynamic and fast-growing communities in the no-code space, and there are many members producing and sharing educational content, tips, or news on Airtable or just offering related services. We have selected the top (in our opinion) experts in the field who are worth following. Check it out and let us know who else would you suggest to be included in the list. Cheers, Narek

Hi everyone. I’ve just released Air Publisher, a free RapidWeaver stack that can be used to Web publish data stored in Airtable databases. With Airtable, RapidWeaver, and Air Publisher, you can easily create modern, responsive, database-driven Web sites without writing a single line of code. A demo video and other resources are available here: https://timdietrich.me/stacks/air-publisher/ Please let me know if you have any questions or feedback. Thanks, Tim

Hey AT family! Joel here from Paytable - the membership platform for Airtable. I’ve been making some exciting changes to the Paytable product page & widget, mostly an improved UX, a slicker horizontal layout and direct to payment links that use our new simplified pre-checkout page for improved conversion: Selling Airtable access has never bene slicker or more secure and you can embed this widget into your custom domain and test out how it will look in the new improved live edit builder: Embed the new members area login and access onto your domain​ As part of this recent upgrade you can now easily embed the widget, login and members area into your own domain in seconds. It literally is just a case on inputting the url into your settings in Paytable and embedding the widget with one line of code. You can also use this on 1 page sites like Carrd too with clear setup instructions of course. Things are ALOT clearer in the brand new dashboard if you fancy giving it another spin.​ I’ll

Hi Everyone, The no-code community (and the Airtable community in particular) is evolving fast, and there are already a lot of established experts writing on no-code trends, technologies, news, etc. Therefore, we thought it would be useful to compile a list of the most interesting (in our opinion) experts in the area that are worth following on social media: 100+ Top No-Code Experts You Should Be Following Should be helpful if you’re just getting into the no-code space or if you’re simply looking for new sources of inspiration and expertise. Cheers, Narek

There’s a ton of excellent tools for turning data in Airtable into websites. But how about the reverse - scraping data from websites into Airtable? After some good community feedback I’ve launched a direct Airtable integration on Simplescraper to help you do that. Choose a website to scrape, enter the details of the base and table where you want the data to appear, click run, and your data instantly appears in Airtable. Here’s a tutorial that scrapes jobs listings directly from Indeed into a base and it should work similarly on almost every website. I know people mentioned scraping LinkedIn leads and real estate listings and I’m sure there’s more use cases. Check it out and hope it adds value :v:

There’s probably an easier way to do this, but I was quite pleased with the solution I came up with. I’d be interested to hear what you think… I’m building an auditing tool composed of a large number of questions that can be answered Yes, No, or N/A. This needs to give an overall “score” as the final output, as a percentage, where questions for which “N/A” is selected aren’t counted towards the overall score, i.e. the score is calculated by the total number of questions answered “Yes”, divided by the total number of applicable questions. I set up a test version of this tool and filled in some results here. The “Score” field is worked out as follows: {Yes} IF({Q1}="Yes", "1", "") & IF({Q2}="Yes", "1", "") & IF({Q3}="Yes", "1", "") & IF({Q4}="Yes", "1", "") & IF({Q5}="Yes", "1", "") {Yes or no} IF(OR({Q1}="Yes", {Q1}="No"), "1", "") & IF(OR({Q2}="Yes", {Q2}="No"), "1", "") & IF(OR({Q3}="Yes", {Q3}="No"), "1", "") & IF(OR({Q4}="Yes", {Q4}="No"), "1", "") &amp

Hey Everyone, As an active member of the no-code community, we at Softr always closely follow the developments within the no-code movement. Therefore, we’ve started a series of articles on no-code to share our thoughts and observations on different aspects of the no-code universe. The first one explores the evolution of no-code, its current developments, and future perspectives: The Past, Present, and Future of No-Code Let me know if it’s helpful and if you’d be interested in reading more similar content. Cheers, Narek

My new app “Ready-Made Formulas” is now available on the Airtable marketplace. This app includes over a dozen “ready-to-use” formulas for common tasks such as formatting numbers and dates as text strings to include in reports generating urls for prefilled forms and prefiltered shared views extracting attachment filenames and urls manipulating dates consolidating data from multiple fields into JSON format Simply choose your formula, pick your table and fields, and select your options. Then, copy and paste the formula into your formula field. Most formulas require a premium license.

The last time I looked at Coda and I put my suggestion about improvements for the Gallery view in Airtable: Suggestions for Gallery view (see Coda gallery view) Product Suggestions Here is a gallery view I would like to offer as an example of how Airtable could improve its gallery view design. The gallery view in Airtable looks great, don’t get me wrong, but there are at least a couple of things that need to be looked after e.g. Multi-line title (or other fields) Clean look (the less colours in the template the better, I want the content to stand out, not the template I know Airtable gallery design is adaptive and reduces number of columns depending on the screen size. H… Now I looked at Knack. I didn’t spend a lot of time because I found it’s not what I need, but here are my impressions. It’s a relatively new company I never heard of but seems interesting. They are taking similar approach as Coda in terms of the initial database design and and focus o

Hey Everyone, It’s been a busy month for Softr, and we have lots of new exciting stuff for you. Check out all the news, new features, and improvements below: :1st_place_medal: #1 Product of the Week & Day on Product Hunt :jigsaw: Softr 2.0 Use Cases - Client Portals, Internal Tools, Marketplaces, Communities, Resources & Websites New experience for you :tada: New branding, logo and a redesigned website :rocket: New dashboard area :gem: Redesigned Softr editor navigation New Features :bust_in_silhouette: Sign in and Sign up via Google (for your app users) :sparkles: Sign in via magic link (for your app users) ↔️ Define items per row in lists :label: Dropdown filter type for lists :rocket: Performance Improvements :date: What’s Next? Edit Information in Softr app (Airtable records) New Table view list block Payments in forms New redesign rollouts More performance improvements Details here: bit.ly/3gZW2or

After working with all sorts of Airtable users to get their bases connected to PowerBI, I wanted to provide a quick tutorial to the community in case you might be looking to connect Airtable to PowerBI as well. There are two ways to connect Airtable to PowerBI The Airtable REST API Using a service like the one I’m helping with → Sync Inc I’ll cover both here briefly: REST API These instructions pull together information across several posts here and here. Thanks to @Oscar_Diaz for getting this started - hope pulling this into one place can help. Retrieve your API key from your Airtable accounts page. Retrieve the your Base ID from the Airtable API Docs. Generate the API request to pull the data from your desired Airtable base and a specific table. Here is the basic format: https://api.airtable.com/v0/[BaseID]/[NAME_OF_THE_TABLE]?Api_key=[API_KEY] In Power BI, select Get Data and enter the properly formatted URL you just created Now, set up pagination so you can pull in more t

Hi! So I recently noticed that if I am creating records in a filtered view that all NEW records added in that view will automatically get the same values that are required by that filter. This is pretty AWESOME! Ive been itching to get new records to auto-fill and this helps me get toward that goal. Feature request… If you could attach a form view to create records in a specific view, that would ROCK! However, I do also use the ‘prefill’ in the URL option to do that.

He creado la tabla de novedades Airtable en castellano para mis amigos de España! Airtable Las novedades Airtable updates en español - Airtable Explore the "Las novedades Airtable updates en español" view on Airtable. Esta tabla te da todas las novedades publicadas por el equipo de Airtable desde su creación por orden cronológico y te traduce al español todas las funciones en automático gracias a Google. Disfrutar!

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!