Show and Tell

Hey there, Wanted to share an advanced base and extension we’ve built for the large multi-tasking creative department of an enterprise airtable customer. The app is used to easily identify the best qualified person for the job, availability wise, using personnel workload heatmaps: and workload charts: The solution we’ve built includes many advanced features, including: Weighted tasks Custom capacities per person (i.e. part-time capacities) Timescales, similar to the airtable timeline view Generation of batch tasks from template projects Support for multiple synced in project bases Automations to generate tasks from synced in project data Relinking of records that are linked in

I have a table whose user entered fields are susceptible to errors arising from invalid conditions between two or more fields. For example: Start and end dates are optional but if both start and end date are filled out the end date must be AFTER the start date. If the value of the Type field is ‘Underwriting’ then the Underwriter field must be non blank. Depending on the value of a certain status field, the total count of linked record in another field should be just 1, or 0. I want the user to be alerted to a lot of error conditions as they enter data or view records, but I don’t want a whole bunch of formula fields alerting the user and cluttering up the users’ views or interfaces. To keep things simple for the user I created just one formula field to concatenate together all possible error checks. Each term in the concatenation returns a descriptive message if the error check l

As developers, we get roped into codifying a vast and seemingly endless escalation of conditional processing to find and filter records and related tables. Where does it end? Apparently, it doesn’t because as soon as you create the perfect script that loops across many filtering constraints, the client (or management) is going ask for a “slight” modification or you will invariably discover an unanticipated case where you’re standing in a corner holding a paintbrush without egress. This and vastly many of our script projects are fundamentally based on two essential tasks - Filter out the data that we need Perform computations on the filtered data Typically, we use loops to achieve #1. #2 is easy if we get #1 right. But #1 is never simple and rarely performant given enough conditional complexity and records. What’s better

Hey everyone! Feels weird to be writing from the other side again but I wanted to share last week’s stream with Airkit where we built a flow to let users update their information in Airtable with Airkit. The flow Ismaen showed off doesn’t use the usual trick of adding the record ID as a hidden parameter and instead passes it through the API on form submission. Additionally, I thought it was interesting that Airkit “remembers” the session letting the user start off where they left off when filling out the information and has fields like autocomplete addresses. Let me know what you think! Excited to be back posting as a regular user :slightly_smiling_face:

In this tutorial, we’ll learn to build a system that automatically creates QR Codes for every record in an Airtable base. You’ll be able to print QR Codes for each product and attach them to your inventory shelves for easy scanning and updating information on every record. Part 1: Generate QRCodes for every row in Airtable using a formula We’ll use the QRCode API in an Airtable formula to automatically produce barcodes for each record (row) in Airtab

:wave: Hey everyone. I’m Lizzie from Stacker and I wanted to drop by to let you know that we’re launching a couple of exciting improvements today. First, we’ve introduced a new and improved Admin experience. Here are some highlights: See all your data in Stacker — you can now view & edit data from Airtable within Stacker. This saves you having to jump back to your Airtable bases to get a full view of your data. Access all settings from one place — all your admin controls have been neatly arranged in a floating side tray so you can easily jump from editing your pages to accessing the Data Grid, and then to managing your users and adjusting your app settings. Preview As in one click — with a single click you can now see your app as your users do, right from the side tray. Secondly, we’

Let’s say you have a large set of data in Airtable that you want to display in list format on a WordPress website. Tables have rows and columns to organize your data and make your collection easy to read. In this article, I showcase an example of pulling data out of Airtable using the API and displaying it with a JavaScript library to make it look good and super fast. Create a Beautiful, Highly Functional Data Table Take a look and let me know what you think.

Hi, if you’re looking to compress images that users upload into your app to save on storage space and make your app or site load faster, this tutorial might help. I’m using this to compress multiple images that are uploaded via a form to my Airtable I’ve recorded a video and made an article, you can access both on this post I made on nocodeshare.co Tools you will need: Integromat/make Airtable (obviously) Mallabe account (used inside

I put together a bunch of hotkeys to make my own life easier, and figured I might as well clean it up and post it in case any one else found them useful!This all works via a Tampermonkey script, and installation instructions can be found belowDemoChange Log7 Oct 2022 Updated to handle new field menu items 24 Mar 2023 Updated to handle new field option layout Firefox now uses MetaLeft; script updated to use it 28 Mar 2023 Updated to handle new formula field HTML 29 June 2024 Updated to handle new create button selector ID Shortcut List⌘/Left Alt + ⇧ Left Shift + ' Add a new field

Hi there I’ve built an extension for airtable (Charts Like https://convertkit.baremetrics.com ) I might launch it to the marketplace if you are interested :slightly_smiling_face: )

Movie Analytics [23k+ Movies] - Airtable Universe Hello Community, I have been working with Airtable Designer for a while. With elements and rearrangeable surface area possibilities are endless to drive the use-case. I made some effort into extracting popular movies. With Zapier, Script Block, Triggers and Automation - here is my small attempt to giveback. Checkout the interface and try putting various constraints. You can do many things such as: Avg movie length of hindi movies in 90’s Marvel Vs DC Comparison Avg profit in % made by movie Which categories are more successful (Action vs Drama) Does spending more money increase the rating Correlation between revenue and rating Revenue, Profit, Budget comparisons by different parameters and much more!! Updated Date fie

Add the “User CSS” chrome extension (free) and then paste in the following: /* add extra margin to top*/ /* so filter popup does not hide first record*/ #viewContainer { margin-top:120px; } /* hide annoying view popups*/ div[id$=“tooltip”].dark{ display:none; } /* restrict height of long text fields in form view*/ /* and add scroll bar */ .contentEditableTextbox{ max-height:200px; overflow-y:auto; }

Hi Everybody! I’ve started a new series of YouTube tutorials and thought that some of you might find this one interesting. Automations have opened up so many cool possibilities in Airtable!

Hello!Default formula fields too small? Hate using your mouse?Good news! Here’s a Tampermonkey script thatMakes the formula input field larger by default (Customizable) Allows you to set a hotkeys to: Save the field (e.g. Hitting Left Control + Right Shift will save the field) instead of clicking the Save button manually Add a new field DetailsWe can customize the height and width of the input field by modifying the following lines:let formulaFieldHeight = "350px"let formulaFieldWidth = "350px"And we can customize hotkeys to automatically hit the Save button by modifying these lines. (I used

You can view or edit Google Docs, Google Sheets, or Google Slides files from Airtable with On2Air Forms.How to use the Google File Field in On2Air Forms for Airtable.

Made by a French Lego Master with reused pieces. The hole story and a picture of the artist here (sorry, this is in french)

TLDR 4 week accountability meetups to build automated CRM for myself Do hands-on assignment before each meetup During meetup on Zoom we discuss on our hands-on experiences and answer other’s questions $50 to join - which includes an expert Q&A to answer all our questions Hi everyone! I’m building automated CRM with Airtable. But I’m not that confident to push myself to finish it, so I’d like to organize a weekly accountability group with other B2B company sales persons or marketers where Do hands-on practices in the articles Meet on Zoom weekly for an hour Discuss on the obstacles and ask and answer questions to each other Every week participants need to do hands-on practices on one’s own. Then, during the meetup, we can share and discuss on our experiences and ask &am

You have all your data in Airtable and now you need to summarize and calculate all the information.Reporting on business information is a vital part of company operations. “How do I create a report in Airtable?” is one of the common questions we see from Airtable users.First, the answer is, “Yes, you can create reports!” You can create summary reports from your Airtable data, whether you need to summarize income, projects, sales, or information such as employee vacation hours or inventory totals.In this tutorial, you’ll learn how to create summary reports in Airtable, how to automate record links to a report, and how to create a dashboard to showcase the information for others.See the full tutorial here:How to Create a Summary Report in Airtable

3/17/2020 Edit: updated the the ‘Create’ case to return the recordId's of the created records, rather than just a count of created records. Thanks @kuovonne for the idea. The updateRecordsAsync(), createRecordsAsync(), and deleteRecordsAsync() functions that Airtable provides in the Scripting Block only allow the action to perform on 50 records at a time at most. While Airtable does provide a helpful example of how to run a loop that batches a set of records greater than 50 for processing in the “Find & Replace” example of the Scripting Block documentation… // Only up to 50 updates are allowed at one time, so do it in batches while (updates.length > 0) { await table.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); } I thought it might be nice to have a single function to

If you are looking to pull insights from your Airtable data, try connecting your Airtable base to Metabase to easily build interactive graphs and dashboards. Metabase is an open source BI tool where you can easily summarize and visualize your data. You can connect Airtable to Metabase using a tool I helped build, Sync Inc. We’ve been blown away by the kinds of dashboards people are building - so we wrote up a tutorial that walks through how to do it: docs.syncinc.so

https://www.askdottar.org Hello folks, I am Joseph, creator of The DOTTAR Project or The Database of Technology Training and Resources Project, an online database that is ad-free, with an easy to use interface. It is an online resource for sharing other resources. On DOTTAR a user can contribute to the project by adding a new resource, they can also use the project to search for resources in various categories, from online courses, micro degrees, or content creators and videos, to offline resources like books, textbooks, lecture notes, or colleges and local universities. It is a resource of resources. DOTTAR is built on Airtable and Softr and I am truly pleased with how the project turned out, if you have any feedback please let me know. :slightly_smiling_face

In my last gig, my team used Airtable extensively as our database. Our content editors wanted to collect user testimonials in Airtable, where we managed all of our existing data. If you or your team has this kind of setup, Open Testimonials is perfect for you. Open Testimonials stands out from the plethora of testimonial collection SAAS’s in a couple of ways: :heart: 100% Open Source (self-hosting coming soon!) :heart: Small bundle size (https://bundlephobia.com/package… reports 3kb min + gzipped) - this means that Open Testimonials won’t slow your website down! :heart: Server-side rendering (works with React, comment other frameworks you’d like to see) Try it out at https://opentestimonials.com! For a limited time, you can get a lifetime plan for a $150, w

I wanted to share what I figured out looking for a way to run an automation at a scheduled time. First, create a helper table named Automation Trigger with 3 columns: Name (type: Single line text) Run At (type: Date, with time field included) Record (type: Formula, expression: RECORD_ID()) For each automation you want to schedule: Add a row with a unique descriptive name Add a view with a filter matching only the one record added above (Name is …) Add an automation: Choose trigger: When record updated Select table: Automation Trigger Select view: the one matching your automation intent Select the Run At f

Do you have an Airtable workspace with multiple important company bases? You can backup up multiple Airtable bases at once with On2Air Backups - without having to add the On2Air Backups extension to every single base. Every On2Air Backups plan (except Starter) can back up multiple Airtable bases. Check out this 3 minute video on how to create a Backup Project :small_red_triangle_down: You can also read our knowledgebase article: How to Back Up Multiple Airtable Bases with a Backups Project

No words. Just visuals.