Builders Board

Sharing here because obviously the team I’m working for can’t appreciate it as much as you all will!! And the Airtable community is amazing!! Took me a hot minute and it’s a bit convoluted with lots of helper fields (if you have a better/cleaner way, please share!!), but I finally figured out how to get a linked field into a nice list with comma separators and an “and” just before the last item. I use this in a template email. I may do a Loom video if anyone wants it, just let me know in the comments. Requirements: 2 tables linked :slightly_smiling_face: In table 1: First Name Field First Name Length Field - This is essentially a character count of the length of the first names. If your scenario may have more than 99 characters you’ll need to add two zeros in front of the numbers less than 10, and other formulas later may need to change. Thanks to Airtable forum for this formula: IF( LEN( {First Name} )<10, ‘0’ )&LEN( {

Early this year I wrote a script1 to help a user organize some sequential events, where one event would start when the previous event ended. Rather than continue to post updates to that original thread, I felt it would be best to start a new one. This script lets you go from this: …to this: Change durations and re-run the script to re-calculate the relevant start and end times (no need to clear fields first!) Choose as many fixed start times as you wish, and those times will remain untouched while the others calculate based on the end time of the previous record Tip: use record colorin

Hi everyone,I would like to know if it would be possible to create a sort of ‘Doctolob’ in Airtable.I have a table Users. I have a table Event. I have a table Event_x_User.I would like to know if it is possible to create an interface in which I pass a User ID as a parameter, and I display all the Event_x_User that are available (not linked to a user, this is a relation 1-1 Event-User), then that the user can subscribe to the Event. I link the Event_X_User to the User if he selected.

Recently I tried out a few experiments using AI to do SEO analysis on competitor websites and formulate a strategy that can be used to beat them. This performed really well for most internal SEO teams as they got new and insightful strategies based on current data All you need is a keyword and a backend workflow scraps all the pages ranking for that keyword. The content and site structure is analysed by AI and a strategy on how to go about the strategy is providedThe next step is creating a new blog based on a combination of different strategies from the above steps to generate a unique high-quality blog postIf you would like to test it or have a custom AI integration feel free to PM or email me at zacharia@effibotics.com

This a product I build on airtable, and automated the backed using n8n to create powerful SEO manager that can automate basically all your SEO tasks from keyword research, competitor research, write AI blogs and publish to wordpress.I liked Airtable as its much easier to use and manage with the free tier, and can be easily automated to create complex systemsYou can access the template here 

We're seeking an experienced Airtable consultant to help implement and optimize a Product Information Management (PIM) system for our apparel brand. The core architecture is already built and well-organized — most of the logic and structure comes from an existing Google Sheets system we’ve used for years.Your Role: Translate our existing Google Sheets logic into Airtable (formulas, rollups, linked records) Implement our table structure: Master Merchandising (Men, Women, Kids, Unisex, Accessories) Product Variants Product Category Attributes Design Tables (Final Art + Web Mockups) Platform Import Tables (Shopify, Katana, QBO, OrderDesk) Build scripts/automations to: Auto-generate product variant rows from merchandising inputs

Hello everyone,I've built a document generation for Airtable, using Google Docs for templating. Today, this product, Typeflow.us, is available as an Airtable extension.Thanks to it, you can bulk generate PDFs directly in Airtable in a few clicks. I built this extension, because many of you struggle to generate PDFs automatically with Airtable Page Designer.It's also possible to generate PDFs using:Airtable Automation our API to generate PDFs with Make / Zapier just to generate PDFs directly with a button in Airtable.We have many features to cover your use case:line items => perfect for invoices, quotes, reports. nested line items => perfect for

 I need many subscriptions for my operations, and I need to collect the invoices every monthSo I have accurate reporting, and for my accountant of course.So I built this system to solve my own problem - hope it’s useful to others too! Download link to all material used is in the video description.

I just tried the new “improved Home Screen”This time, the UX team reached a new level of make things worse. 1. Why do you need this column on the left with so much dead space just for Home Buton, a Help shortcut, Notifications and your profile??? Really Why?Colors tables dont respond to the color base...it is just a light hue of the color you choose. Horrible at least.   What is the point of moving  the toolbar on the right? what’s wrong with the previous one? Icons, graphics, looks sharper

TL;DR:I’m a non-technical cartoonist who built a fully chat-controlled editorial system using Airtable’s API and OpenAI Actions (via ChatGPT Teams). I can manage my entire cartoon workflow—images, captions, submissions, rights, and tagging—just by talking to it. No middleware, no third-party tools. It handles flexible inputs, reads image fields, and edits any table or field naturally. Happy to share details if anyone’s doing something similar.Why I built it:I draw single-panel, black-and-white gag cartoons (like what you’d find in The New Yorker). I needed a way to track and submit work, manage captions, analyze themes, and stay organized across multiple stages of a cartoon’s life. I had no editor or agent—so I built one.What it does:Reads and analyzes cartoon images alongside their captions Tags tone, subjectivity, and humor style Edits any field across multiple linked tables (submissions, rights, cooldowns, etc.) W

Includes spanish characters. LOWER( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE({Título},"¿",""),"?",""), “!”,""), “¡”,""), “-”,""), " “,”"), “(”,""), “)”,""), “á”,“a”), “é”,“e”), “í”,“i”), “ó”,“o”), “ú”,“u”), “ñ”,“n”), “/”,""), “#”,""), “:”,""), “”",""), “””,""), “.”,""), ““”,""), “,”,""), “ª”,""), “º”,""), “Á”,“a”), “É”,“e”), “Í”,“i”), “Ó”,“o”), “Ú”,“u”))

 Hello Airtable Team, I hope you’re doing well. I’m currently building a patient management system using Airtable and I need to implement the following key features: A public form where patients can submit a medicine request (already handled via Airtable Forms). Automatic generation of a username and password after form submission if an email is provided. An automatic email sent to the patient with their login credentials. A secure way for patients to log in and view the status of their request via a dashboard. Role-based access for a committee and union member to review, approve, or reject the requests. A system to prevent duplicate submissions based on national ID and phone number. A “Forgot Password” feature to allow patients to recover their login access.  I understand that Airtable is excellent for data collection and collaboration, but currentl

I would like to request the ability to add custom vertical lines or markers at user-defined intervals in Timeline view.Use case:In Agile project management, we organize work into sprints (usually every 2 weeks). It would be extremely helpful to visually separate these periods in Timeline view by adding vertical lines or markers at custom intervals (e.g., every 2 weeks, starting from a date I specify). This would make it easier to plan, track progress, and communicate timelines to my team.

We’ve been using Airtable as a backend for lightweight apps — like a project dashboard for clients, or a form submission portal that touches multiple tables.Interfaces help a bit, but they don’t quite support login, user-based permissions, or multi-table forms. We ended up building a role-aware portal layer that connects to Airtable and lets users view, edit, or create records based on their role — it’s now ClientlyBase, but it started as a personal workaround. Just curious if others here are building similar “mini apps” on Airtable. What tools are you using — Interfaces, Softr, Glide, or something else?

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. The user selects one of five categories. Based on that selection, he or she is allowed to choose from a subset of five subcategories, taken from an overall population of 25 subcategories. Thi

Hey everyone! We recently shipped two features for BaseQL that I’m really excited about.For those that don’t know, BaseQL provides a GraphQL API for Airtable that makes it easier to build custom apps with your Airtable data.These new features came directly from user feedback about workflow pain points.TL;DR: You can now query Airtable views directly and have full control over filtering/sorting related records in a single API call.Querying Airtable ViewsBaseQL now supports querying specific Airtable views using the new _view argument. This feature leverages Airtable’s powerful ability to create custom views with specific sorting, filtering, and grouping configurations.Why this mattersMany BaseQL users were manually implementing sorting through rank columns or creating complex filter combinations to match what they had already config

Just returned from Asia's largest Apple ecosystem expo where we showcased AirKit for Airtable. What an amazing experience connecting with so many passionate Airtable users across Asia! The energy was incredible as visitors from China, Korea and beyond stopped by our booth. We were genuinely surprised by how many people are using Airtable for everything from personal projects to enterprise solutions.  Many users shared their frustrations with the slowness and navigation complexity. It was validating to demonstrate how our AirKit app solves these exact pain points by enabling quick record additions and table access through Siri commands and Spotlight search. The conversations were enlightening - we learned so much about how people are using Airtable in different contexts and cultures. Several visitors even showed us their unique Airtable setups! I've created this vlog to

The Long Text field in Airtable is currently way too small. It was previously possible to expand the size of the long text field to make it easier to read…. long text….I wish that they would bring back the option to resize this field so that it wasn’t such a pain to use. If resizing isn’t possible to bring back, then I wish that they would either:1) Expand the default size significantly;2) Allow users to make the long text field full screen; or3) Make the Long Text input box responsive so that it increases and decreases in size based on the amount of long text that is in the field.This would prevent users from having to constantly scroll to see long text in the long text field. We don’t need this to be as feature friendly as a full scale text editor (although that would also be great), but it should at least allow you to easily see the long text that is in this field without having to scroll for hours. It’s a huge pain to u

Hi,UMI FUND are looking for some short term support to improve the functionality of our CRM on AT. We’ve set much of it up and been using it for over a year but have some needs to polish the processes and production of analysis so it works better for us. We don’t have a huge number of contacts / records so don’t foresee it taking a long time. Would broadly encompass the following:Review of current use / needs by staff using AT, and those that could (e.g Finance/Ops, Programmes, Leadership etc) Suggestions and implementation of improvements to process, donor journey through AT. Improvement to production of dashboard / analytics (FR reporting, Board reporting, Projections etc) from data input on AT. Recommendations on how UMI could further optimise usage of AT- specifically in relation to donor intelligence gathering, prospecting, and donor stewardship.Pease respond below with availability, rates and time estimate and I’ll get

Long text preview too small?  Not anymore!This script lets you resize the modal and set your own default width / height.  To use it, you’ll need to use Tampermonkey (https://www.tampermonkey.net/) Happy to fix any bugs or issues, please let me know about them and I’ll do what I can! Inspired by this post here:  // ==UserScript==// @name Resizable Airtable Multiline/RichText Modal// @namespace adam@thetimesaving.company// @version 0.1// @description Make multiline/richText modals resizable with defaul

Using chatGPT in an Airtable automation. In my use case, the automation triggers on when an Airtable record matches conditions,then follows with 2 actions, run script and update record. Adjust the first part of the promptwith your own use case. Tip: Use chatGPT to help you write a prompt for chatGPT (!) let inputConfig = input.config(); text = `${inputConfig.text}`; var key = "openai-api-key"; var url = "https://api.openai.com/v1/completions"; prompt = "Reword this text to grade 9 reading level: " + text; var gpt = { model : "text-davinci-003", prompt : prompt, temperature : 0, max_tokens : 1024 }; response = await fetch(url, { method: 'POST', body: JSON.stringify(gpt), headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + key, } }); answer= await response.json(); data=answer.choices[0].text; output.set('your-airtable-field',data); 

Wir suchen für unser PropTech Furnestate deutschsprachige Mitarbeiter für Hybrid-Rollen, welche sich aus Customer Support und Airtableoptimierung zusammensetzen. Bei Interesse bitte per Mail an david@furnestate.com :-)

Hi everyone,  I am a Music Supervisor (syncing songs for video games, movies ads…). I am currently using the Microsoft Suite and Google Suite for my business but I am now looking for a tool that can do it all in one platform. Airtable seems to answer many of my user cases and so I am now looking for an Airtable Expert that could set up the templates and automations for me, so I can then populate the templates with my own data. Ideally this person would be UK or Europe based. I would ideally like to work from Airtable’s free plan but can also consider subscribing to the Team tier.  I would need Airtable for 3 main user cases:  1/ CRM:I have different databases of con

A custom script that helps you integrate Airtable with the OpenAI API without using any 3rd party tools like Zapier or Make - possible even with the free Airtable account. Just copy-paste the "script" and start getting responses from gpt-4/3.5, immediately.What can you do with the “script”?You can bring the power of OpenAI language models (GPT-4 and GPT-3.5) to your Airtable base and utilize them to create content for 1000s of rows at once.For example:Generate product descriptions based on several data pointsCreate personalized emails for 1000s of guests based on available dataDo programmatic SEO by creating super-optimized AI contentGenerate content for anything and everything that follo

I know a lot of you including myself on the forums wish there was a way to attach dropbox image links so you can maintain your digital assets locally such as this post: Choose Dropbox or Google Drive for attachment storage Product