Show and Tell

Indeed, views provide a very powerful way to scope and optimize access to data. However, they cannot be dynamically altered to achieve what I consider hyper-performant script processes. Here’s an example… Imagine a table (a) with a view and when a record enters that view, search another table (b) that has 45,000 records in it for a single matching key so that a linkage can be established in (a) to (b). I’m not an expert in all manners of Airtable scripting, but I think the only way to do this is to iterate across the 45000 records in table (b) to locate the record ID such that the linkage can be updated in table (a). Ironically, searching for discussions about this place me in the commentary mix here. And even then, I’m not sure I expressed the issues succinctly. Two ideas come to mind when presented with this quandary - Ideally, there should be a searchRecordsAsync() method that uses the internal search capabilities to return a record (or record collection) given a field or record

I’m really proud to have worked on this and I hope that it brings some of you the joy it has brought me. So if your Labour Day resolution was to stop spending so much time pressing ctrl+c and ctrl+v migrating Google Sheets and Notion files into Airtable then you might want to check out Unito, our new 2-way integrations were designed specifically to save you time so you can seamlessly connect to all the other apps where work happens. Unito.io

Hey Airtable community, Today we officially launched our new Chart blocks on Softr. The new chart blocks work seamlessly with Airtable, allowing you to turn a table of records into stunning, interactive charts which can be created in a matter of minutes. To provide you with a quick example of what can be done with the new Chart Blocks check out this example of a building in public page to share your metrics. This template is now available to use today. We are continuing to iterate the new chart functionality and will be releasing a number of further improvements in the coming days. You can learn more about Charts in today’s update found here. We can’t wait to see what the Airtable community will use this new functionality for.

Hello, I just made my first Script app writing my own custom code :tada: and wanted to share :blush: Context: I am working with a base that has gone through several iterations of development and am trying to resolve some contradictory data sets. Specifically, for a directory of people who get assigned a “level.” There are five different fields to compare and resolve so as to make a single source of truth for each person. My fiirst step is to identify where there are mismatches across the five fields (a rollup, two lookups, and two single-select fields). My first thought was to use a nested IF() ƒormula, but I found it difficult to construct the matching logic for the fields values and for when any them are without values (i.e. blank). My next thought was to use an array formula to make an ARRAYUNIQUE() out of an ARRAYCOMPACT() values (i.e. remove the blank values, then look for unique values). To my surprise, the Array functions are only applicable in Rollups or when the field

Hi, sometimes button format is not convenient, when you have to assign scripts, related to table, not records. i think that buttons needs at least be possible to show/hide in different records. And change label. And color. And script assig… okay, that could be done by “Switch” in single script :grinning: Well, I’m not with a complain or proposition, just want to share example of using Singleselect for UI. Triggered by automation, returns to default state “CHOOSE ACTION” (other records default is ‘inactive’)

If you find yourself collaborating with your team in the same base, it can be helpful to see the latest updates and when things were modified to make sure everyone’s on the same page. In this video, Airtable’s Becky Mak jumps into a base to show you how you can surface those updates. Additional resources: Support article: Last modified time field Support article: Use automations to timestamp status updates Support article: Record-level revision history overview Support article: Last modified by field If you know of other resources that come to mind, drop them in the comments below! We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved… :eyes: )

Hey everyone! It’s Luannie from Pory. We’re super excited to kick off our how to build series using our favourite tool Airtable! Our first tutorial is on creating a members portal where I’ll be covering how to: :hammer_and_wrench: Navigate Pory (we’ve given it a lot of love) :electric_plug: Connect and manage users via Airtable :love_letter: Generate invitation links to existing members Let us know what you think and what you would like to see next!

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled up a number of new features this week we would love to share with you. New Templates Firstly, we have two stunning new templates. The first one is an inventory tracking template created by our partner agency VisualMakers.de. This template is perfect for a small business to track and manage all your products, orders, manufacturers and purchase orders. Next up is our out of the box community template. This template is packed with advanced functionality and is perfect for anyone looking to create an online community. It includes a modern, minimal design aesthetic, community directory, a list of events and spaces and the members attending each event + loads more. Transfer Ownership You can now transfer ownership of a Softr application from your dashboard. This is something a number of agencies and creators have asked for. Now you can create Softr apps and transfer them to new owners in a matter of seconds. Th

Need to build a CRUD app on top of the Airtable database? UI Bakery handles it. Development takes minutes. Check it out https://uibakery.io/airtable-crud-builder

Looking to dial up your executive summary email process? In this video Airtable’s Head of Content, Margaret Jones, showcases how you can create send off emails summarizing all the content that’s shipping in the following week. Margaret uses this email to let stakeholders know about what’s coming in the pipeline (and share the amazing work her team is accomplishing)! Additional resources: Support Article: How to create email digests with automations Template: Content Calendar From the Community: Airtable Automation: How to Automate Email in Your Base & Save Time Support article: How to automatically send approval emails without leaving your base We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved…)

Hey Airtable community, We have a major update on Softr to share with you today which i think you will love! You can now allow your users to edit Airtable data from with your Softr application. You can set up this ability in a matter of seconds starting today. The new editing functionality opens up an infinite amount of new possibilities with Softr and we can’t wait to see what you come up with. To give you a quick overview of this new functionality we have put together two short tutorial videos which you can check out below. We will be continuing to roll out the edit functionality to other block elements on Softr over the coming weeks so keep an eye out for future updates. • Softr editing Airtable records (all logged-in users) • Softr editing Airtable records (One user group can edit, the other can’t) Lastly, the edit permissions functionality is currently available on Softr’s Professional and Business plan members. However, we think everyone should have the opportunity to try this ne

-moved- to Products Suggestions.

Interested in creating an org chart with Airtable? You’re in the right place. In this video, Airtable’s Dana Frederick will walk you through how to build - and customize - your next org chart with Airtable. Additional resources: Support Article: Org Chart App Template: Corporate organizational chart Template From the community: @Gareth_Pronovost Features of Airtable’s Gantt Chart How-to Video: How to use the org chart block Support Article: Org Chart Block Universe Base: KasPer Lite Human Resources We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos here or on social using the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There may be swag involved :eyes: )

Hey folks :v: Super excited to share with you that we launched Heep on Product Hunt today! We want to make it the best place to hire experts in modern no-code tools whether it is building your app, website or workflow automation. Power users of no-code tools use Heep to monetize their expertise by creating a portfolio and getting discovered by new customers. Your thoughts & support matter a lot for us, and we really would love to hear your feedback on Product Hunt today :eyes:

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 first

Hey Everyone, We are shortly launching a template marketplace, where you can build and monetize Softr templates. Excited to see the creativity from all the Softr makers and creators! :slightly_smiling_face: Makers! Submit your interest today for early access to the Softr template marketplace here - Template Marketplace Survey

I have a new app on the Airtable Marketplace! Have you ever wanted to prefill a form will data that already exists in your base, but found building the url to be difficult? My new marketplace app, Prefilled Forms, creates a formula that calculates a prefilled url for a form for each record in a table. You don’t have to write any code–just point, click, copy, and paste. Use case 1: Create prefilled links for clients You already have a table of client information, and you have an onboarding form, questionnaire, evaluation survey or other form for them to fill out. You want a to email each client a link to the form prefilled with the client’s name and other details. Use the Prefilled Forms app to build the formula to for each client. Use case 2: Click a button to create records with defaults New records tend to have several fields that always have the same combination of values. For each combination, use a button field with the url for the form prefilled with that combination. Click the b

Hey Everyone, We’ve some nice updates on Softr, which I’d like to share with you. What’s New :chains: Softr API :jigsaw: 5 new templates :gem: Single Sign-on for your app (SSO) :email: Email Signature :rocket: Fast page loads +saving + publishing Community News :yellow_heart: Softr Customer Case Studies page launched :trophy: Boat marketplace built with Softr got featured as the no-code Project of the Month Detailed overview of the release here. :spiral_calendar: What’s Next? Edit Information in Softr app (Airtable records) New & improved membership setup process New redesign rollouts More performance improvements

Heyo! Aron here. I’m on the education team at Airtable but in my spare time (even before joining Airtable), I would stream no-code workflows on Airtable on my Automate All the Things Youtube channel. I stream every week on Wednesday at 1PM EST. Tomorrow, I’ll be streaming how to use the Page designer app to auto create invoices, scripts, its limitations and workarounds (and much more :slightly_smiling_face: ). All details are here. If you’ve got ideas for what I should cover next, let me know!

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