Ask the Community

I've developed a solution on top of Airtable tailored for real estate investors. This tool helps manage properties, units, tenants, and leases efficiently. Recognizing that each investor has unique needs, I am also offering customization services to fit specific use cases and requirements.My goal is to charge a monthly fee for using the solution, with additional fees for customization services. However, I’m uncertain about how to maintain control over the solution given it's built on Airtable. Specifically, I’m concerned about the following:Preventing Unauthorized Distribution: Is there a way to prevent users from copying my solution and distributing it for free?Access Control: How can I ensure that access is removed if a user stops paying?I would love to hear how others handle these challenges. Is it realistic to think that I can productize something built on Airtable? Are there any best practices or strateg

I am hoping to use Airtable Forms to manage applications for a grant, but I am running into issues in finding the best way to export the results so I can review each application/record individually. Clearly exporting to .csv is not the best way to do this. Further, the grant requires an attachment upload. For a simpler grant, I used page designer to print to PDF each record, and pulled in the required fields in order to evaluate. The application data takes up one page, so I just print the pages I need. This is becoming harder as more applications are received, however, because the print options are only “print current record” or “print records in a specific view” (i.e. my entire grid/all results). What I need is to only export/print certain records that have not been reviewed yet. For the more complicated grant, I want to export each record including the attachment. Not export the entire grid to CSV then download each attachment. Is this going to be possible? Each appl

Hello, I need to create a database for a fire station with:- A table for staffing levels- A table for scheduling training sessions- A table to indicate which personnel were present or absentWhat I'm doing isn't very efficient. Could someone help me? I'm new to Airtable and its many features.Thanks

What timezone is used by Calendar View and\or how to change it? Can’t find this in documentation so far. Using Pro plan, if it matters. My use case: I have an ‘events’ table and I want to make 2 calendar views for US and for Europe and be able to (re)schedule events by dragging on both views

Is it possible to change the sent from email, from the default of automations@airtableemail.com to something of our choice? Or by a per project basis?

I want to update a record when a field condition is met, and currently the “Update Record” automation only seems to use any value/change to the field. What I am trying to do when the “Status” field is updated, and ONLY when it’s Value is changed to “Used” do I want to execute the update. Right now when the value is changed from Used to Unused, it runs the automation. Any guide on what combination of actions I can use to do this?

Hi everyone —I’ve built an automation that:1️⃣ Triggers when a Project Overview record enters a view2️⃣ Creates a related record in Prelims Summary (Client Breakdown)3️⃣ Updates the original Project Overview record to link back to that new recordEverything works — the link is created — but in the run log, the Linked Prelims (NEW) field shows two entries: ["rechvSfKKM3dFqypl"] ✅ (green — works) "rechvSfKKM3dFqypl" ❌ (red — literal string) I’m currently setting the linked record field value in the Update Record step as: ["Airtable record ID"] (using the dynamic variable from the Create Record step with the “+” button).Is this expected, or should only the array appear?Could something in the input mapping or type conversion be causing the duplicate string entry?Any insight from others who’ve built dynamic link automations like

Seems like the most obvious functionality, can’t believe I had to query help pages to find out how to do this.

We have an interface where previously (before UI change) we were able to apply a filter to limit the data that was shown but now when you try to add a condition it just shows the hover “Cannot filter on fields” 

Hi! I’ve tried a few different ways of doing this and can’t seem to figure it out. I’m importing some data into a new base and there’s a field that has update notes on different lines all formatted the same. I’d love to figure out an automation to add each line to a linked table as separate updates connected to the parent field. Has anyone attempted this before?Sample long text:6/24/2025: PB approves DM7/8/2025: revised draft sent to client7/10/2025: sent revised draft to sales/CST's7/14/2025: sent revised draft to client7/15/2025: final draft  7/24/2025: final approvals + sent execution copy7/29/2025: f/u w/ client + PE + email FE PDF to client 

If I use an automation to update fields, does it update the fields in the order listed in the automation? So can I copy data from the existing fields first then update the fields with new data all in the same automation? If they update in order why can't I rearrange the order? just have to delete and reorder them all manually...

Hi everyone,I’m building an Airtable base for product data management in pet nutrition. The goal: automatically generate “Article Passes” – structured text outputs with all packaging-relevant details (composition, analytical values, additives, storage info, etc.) in multiple languages.My structure: Products → general info Product Versions → recipe & design versioning Packaging Units → GTIN, article number, recycling info Analytical Constituents / Additives → linked via junction tables Multilingual Content → texts for a number of languages At the moment, I use Rollup fields filtered by language (e.g. Language = DE/EN/IT) and combine them into a big formula for multilingual output like:🇩🇪 GermanShort descr

I have a Single Select field field that I want to allow users to be able to add new options too when they are in Create Form interface. Since this is not possible, are there any workarounds/alternative designs that anyone has used?My thoughts:1. Using Linked Record is also not possible, since it doesn't allow new record creation from the Create Form interface. 2. Using a text field and then automating creation of the option in Single select also is not possible since I believe it doesn't allow update of the Single Select options through "Run Script" in automation?

Okay, looking for brainstorms/solutions. I use Go High Level for almost all of my business management. The one area where I struggle mightily to rely on GHL is calendars. So, I'm implementing Airtable. All my events. All in one place. Folks can register for more than one at a time. GLORIOUS. Until I want to send confirmation emails & reminder emails/texts. I'm trying to decide whether it's easier to do that communication through Airtable and then send it over to GHL for record keeping, OR....whether to send registration info to GHL and then handle all confirmations/reminders from there. I need easy/medium difficulty (with Chat GPT assistance!) to create and reliable replication as we grow. Suggestions????

Our small creative team uses Airtable in a KanBan view to manage client workflow. Each client has a base. Within each base, we typically include the active teammate assigned to the task as a field on each record. This allows us to manage team bandwidth for that particular client, but we still have to manually manage our teams task assignments across various client bases.Is there a way to pull records from different bases within a shared team workspace? We’d like to have an internal view stacked by team member.

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COP

Is there a way a user submitting a form can save the data filled out before he submitted it? I have a very long form for my users that they won’t fill at once.

My sync stopped working even when I manually sync. When I have investigated what the issue is I did find out that sync stops working when the source base is inactive which could be the case here. But how do I fix this issue without losing any data? I have tried resyncing to the original view and also syncing to a duplicate view. I’m lost. 

INTRO:If you’re not a coder then how can I do Java code to make a script? If you guessed it, yes we use LLMs to help us like ChatGPT. But you tried that and it never worked. Welp, there’s some basics you need to know to appropriately instruct, in your prompt, the right details to get a script properly produced. This post will give you the knowledge and instructions to successfully start your scripting journey.WHAT YOU NEED & SHOULD KNOW TO DO:It is ideal that you know how to build automations with the provided Airtable actions. By this point, you’re figuring out that the basic actions are not able to accomplish certain functions you want. What you do need, is to have access to is some form of LLM like ChatGPT, Claude, etc. PREFACE:I’m writing this, because I’m not a coder and early on I struggled a lot in figuring out how to build scripts. The early version of ChatGPT was not great but n

I am trying to build an automation where multiple choice preferences of a customer under multiple columns need to be  matched with another table where these preferences are mapped to an expert. I am unable to find the output of the right mapping. Can someone help with a workflow direction ? 

Hello! This week my colleagues and I noticed that the format of our email notifications from Airtable has changed. We used to received email notifications saying the person's name "via Airtable." Now it appears as their email address. The new format makes it just a little harder to keep track of who is sending us notifications. We'd like to revert back to the old display with the name but can't figure out how or why it changed. Any ideas? Thanks!

Hello! I have a table which is sort of like a job application portal for our company. We have a google form which is filled along with roles and role specific questions which then we bring into airtable for screening. Now we wish to have a technical round (Round 1) which is through a seperate google form. I wanted help to get the score from the google form/google sheet into this application portal. As i understand there will be separate source data for the application form and for the Round 1 evaluation form (Seperate google sheets). Hence there might need to be some automation required to be able to match the data of both the sources and add it to the same table. I intend to use the email ID as the matching parameters since the forms are filled using google accounts.

Bonjour à tous 👋 Je suis en train de mettre en place une automatisation entre mes tables “Banque / Paiements” et “Synthèse mensuelle”. Objectif : Quand j’ajoute un paiement (avec une date et un montant) dans Banque / Paiements, Airtable doit automatiquement créer ou mettre à jour la ligne correspondante dans Synthèse mensuelle, et additionner les montants du mois.  Ce que j’ai déjà fait :1️⃣ Déclencheur : “Lorsqu’une entrée est créée” dans Banque / Paiements2️⃣ Recherche : “Rechercher des entrées” où Clé mois = Clé mois3️⃣ Création : “Créer une entrée” dans Synthèse mensuelle4️⃣ Mise à jour : “Mettre à jour l’entrée” pour lier le champ Mois (lien) Mon problème :🔹 Le champ Mois (lien) dans “Banque / Paiements” reste vide (ou “dossier sans nom”)🔹 Et je n’arrive pas à faire apparaître “Aucune entrée trouvée” dans la condition de vérificatio

’ve created four tables. Clients is the master table. New submissions from my intake form go straight into Clients.The other three tables are Service_1, Service_2, and Service_3. When I deliver, say, Service 1 to someone who already exists in Clients, I want to link that service record to the existing client—not just type their name again.Concretely: if I start a new record in Service_1 and type “John Doe,” I want that entry to reference the same John Doe in the Clients table, so I can pull his saved info (email, phone, notes) via lookups—rather than duplicating data.What’s the best way to do this?