Ask the Community

A couple months back, I asked for help deleting lines of text beginning with the word ‘Highlight’ and was given this great formula: REGEX_REPLACE({Hook},".*Highlight.*\\n\n?","") It has been a huge time-saver but something I forgot to ask with my original question is if there is a way to add a blank line/line break where those lines were. I input data into the records that looks like:Highlight(blue) - Page 34 · Location 290“Look at that. That thing’s almost a book.”Highlight(yellow) - Page 34 · Location 292“You think… she’s going to print it? When it’s done?”Highlight(pink) - Page 34 · Location 294“I hope so,” I say as brightly as I can manage.  And when using the current formula, it comes out like:“Look at that. That thing’s almost a book.”“You think… she’s going to print it? When it’s done?”“I hope so,” I say as brightly as I can manage. But I need blank lines where the lines starting with ‘Highlight’ were so it looks like:“Look at that. That thing’s almost a book.” “You think… she’s

Hi, I have been trying to get in touch with the Sales Team for more than a month, I have a base that keeps exceeding the 125k records limit, and we urgently need to get more records. has anyone faced a similar situation, and if that’s the case, how did you solve it? Thanks

I’m trying to configure a log-style table in Airtable where, when a new record is created, certain fields are automatically populated using values from the most recent existing record.The problem I’m running into:Using Automations → Find records, I can filter and sort records so that the correct prior record is identified However, Automations treat the result of Find records as a list, even when sorted and limited to one record Because of this, I can’t reliably reference a single previous record’s field value when updating the newly created record I’m using the Airtable free tier, so scripting and paid features are not availableWhat I’m trying to understand:Is there a supported way on the free plan to carry values forward from the most recent existing record into a new record using automations? If this isn’t directly possible, what table design or workaround is required to achieve this behavior within Airtable’s constraints?Any guidance on what can be done with free-tier Airtable autom

I want to use the Claude - Airtable connector in my team which allows them to create records from within claude. I want to make sure that when they are creating a record, for eg. a Task, they are asked to give all the information that is required for my processes. I don’t see how I can set the SOP when allowing them to create/edit from claude. 

When importing a CSV file I am selecting ‘create missing select options’. I can see these new options in the preview but when I’ve selected ‘import’- the records are there but with no new options. Troubleshooting I have already done:I am the owner- however on the free plan. I have saved the Excel file as a standard CSV and as a CSV UTF-8 file. I have tried importing a smaller sheet (sheet/data is not large to begin with) I have made sure the field mapping during import matches the multiple select field exactly. I have refreshed the base and switched views after import. The data is not computed fields (like formulas, rollups, etc.)  I have no hidden or filtered views.  I don’t have a huge amount of options in my multiple select fields to begin with.  I have submitted a ticket but am interested to hear what the community thinks. What am I missing?

Hi everyone,for a long time the page designer extension did a great job creating shipping labels for my records. But recently the page designer extension always crashes. I have the feeling that with the amount of records in my table - more than 30k - it became a problem for page designer. In bases with a smaller amount of records age designer works well. Does anybody else have similar issues?  Kai @ CPLI 

I've found that SEARCH() in filterByFormula handles escaped double quotes differently depending on the field type. Backslash-escaped quotes work correctly on text fields but silently return no results on linked record fields.Setup:- Table "Registrations" has a linked record field {Rider} pointing to table "Riders"- One of the records in the Riders table has the primary field value: Aubrey "Aub" Holland- A Registrations record links to that Rider- Table "Registrations" also has a plain text field {Direct name} where one of the values is Joe "Biggie" SmallsWhen searching the Registration table I get different results with a very similar search depending on which field I search: What Works (text field):  SEARCH("Joe \"Biggie\" Smalls", {Direct name}) != ""Returns the matching record correctly. What Fails (linked record field):  SEARCH("Aubrey \"Aub\" Holland", {Rider}) != ""Returns zero results — no error, just an empty response. The formula is accepted as valid but doesn't match. This do

Hello, I would like to write a script that will move this project from “Active Projects” table to “Completed Projects” table when the status is changed to “Completed”. Can anyone help? Thanks!  

Bonjour, Je cherche désespérément à créer une automatisation dans ma base sans succès et sans réellement en comprendre la raison. J’ai une table Détails Facture qui intègre les lignes de factures de mes partenaires. Cette table a un lien avec un ma table Prix (qui regroupe tous mes produits). Je précise que les deux tables sont liés par un code produit interne. J’aimerais que lorsqu’une nouvelle ligne est créée dans ma base Détails Facture, le prix renseigné soit comparé avec le prix renseigné dans ma base Prix. Si le prix est inférieur, j’aimerais que la base Prix soit mise à jour avec le nouveau prix. Sinon, un email m’est envoyé (l’automatisation pour cette dernière étape est ok).Dans la base Détails Facture, j’ai crée une view avec un tri sur un champ de Sélection si ce champ est renseigné en “Attente de validation”. Dans l’automatisation que j’ai crée un trigger : Quand une entrée est crée dans la vue… Ici je remonte bien mes lignes “En attente de validation”. C’est la suite qui e

A common use case I encounter in Airtable is comparing the state of my data today to a prior state.Here’s an example:I have a table of people and the business units (BUs) they bill their time to Due to reorgs, this info changes frequently I’m trying to get a quick view that lets me compare currently billing to prior stateFor example: Person BU as of today BU as of date xx/xx/xx 1 BU 1 BU 2 2 BU 1 BU 1 3 BU 3 BU 4 4 BU 4 BU 1  Perhaps this is an example of a poorly designed database (we didn’t anticipate so many org changes), and I know I can retrieve a snapshot and do a manual compare.IT would amazing if I could take the field “BU as of today”, duplicate it, and set it to show the data that was in that field on a prior date. (Basically a mini-snapshot).

I need to work with 2,500 - 3,000 records for a 6-Mo/1-Yr project. Once the records are loaded there will be no need to ADD primary records; maybe a few variables in associated tables. Only one ‘Seat’ is needed; no team collaboration. When the project concludes if I change the Base to the Free plan what will happen to the records over the 1’000 limit?

 Hello everybody I have been working on some AirTable Automation scripts and I figured people might need some help on working with Dates and Times using Javascript on the platform so I am here to share with the community a little guide on both working with AirTable records with Dates along with how to convert them over to JSONs and access/modify them. I specifically cover how to get Ordinal values from the day of the month along with getting the name of the month from the numeric value of the month! Setting Up Your ScriptThe first thing you will want to do is click the Automation Tab → Create your Trigger → under actions  create an action that says “Run a script”.Creating The Script AutomationNext you will want to import your data either from a view or a table. In the left pane you will see a category called Inputs. inputs allows you to add in data from previous steps as long as it was mentioned using the output.set() function. Inputs PaneIf you have any previous steps with the output.

Hello - I saw a post about viewing all place my base is syncing too  - but there was no answer and the thread is closed now.Situation: We have multiple bases that are connected via synced columns. Data moves through the operations workflow. We would like to be able to visualize the system and any dependencies. I’m trying to generate or create something similar to the Base Schema extension but across multiple bases. Anyone know a way to do this? Thanks

I have created a base that I want to use as a central dataset (People, Office, BU, CoDEs, Disciplines).I am syncing the People table into another base (feedback base) and linking to it. I can successfully pull through the Name field, but I cannot get Office or CoDE-related data to come through correctly.When I link a record, I only see the Name, and lookups for Office / CoDE fields return blank.SetupSource base (dataset)People table:Name (primary, single line text) Office (linked record → Office table) BU (lookup → Office → BU for Office) Office List (lookup → Office → Office) CoDE Lead (linked record → CoDEs) CoDEs List (lookup → CoDE Lead → Codes) Other fields (emails, etc.)Office table:Office (single line text) BU for Office (single line text) People (linked to People)CoDEs table:Codes (single line text) People (linked to People)Disciplines table:Standard linked structureSync setupI am syncing the People table from a view into another base Sync settings = “All fields in the source”

Hi,I have an automation that ultimately triggers from checkbox field being checked. The checkbox is normally checked as the result of another automation, but I need to let users re-run the automation manually.I thought I could place an Update record button and let it toggle the checkbox, i.e. first uncheck the box, then check it anew.Unfortunately it doesn’t seem to work, it doesn’t seem to do anything. Here’s an image of how my setup. Any ideas how to configure a button so that it unchecks and the checks a checkbox?Rgds,Björn

Hi, Everyone!As per earlier announcement Airtable said “Large views load faster with previews”, which is great for views. BUT, we could need that function in interfaces as well as my team is heavily complaining about loading times when a project became more then 25k records, for example. Kai @ CPLI 

Background:I’m keeping records of applicants in my Airtable base. I wanted the applicants to be able to review the information I entered into Airtable and make any changes to them if needed. I already created the form and a separate table to do so, and I created a link (in a formula field) to their own pre-filled form using the Airtable extension. I also already created the automation to update any changes made with their pre-filled form. All of that works great but only when you click or copy and paste directly from the link in the Airtable formula field. Problem:I wanted to set up an automation that would send an email based on a trigger field to these applicants with their pre-filled form and confirm their info. I tested it out with a fake applicant record but the link in the email is not showing any of the pre-filled fields when you copy and paste (for some reason its also not showing the link fully underlined). I’ve attached a photo of what the pre-filled formula looks like in the

I am trying to open Airtable in Chrome but when I enter a url into a browser and hit return, the screen turns white and my Airtable is tab at the top of browser spins as though it was loading.  Then nothing happens.  The same url works on my colleagues computers no problem (by way of trouble shooting, my internet is working fine, OS and browser is up to date and running most recent version, I cleared my cache and browsing history, disabled all extensions).  I can get it to load in Safari but I want to use Chrome (I’ve set up some extensions and automations in Chrome and don’t want to leave this browser).  Not sure what to do!  

I am looking for a front-end developer to build the public website for Single Use Connect, a B2B platform serving the biopharmaceutical industry.The site has already been fully designed — we have production-ready HTML, CSS and JavaScript, along with SVG logo files and a defined brand system (Libre Baskerville / IBM Plex Sans, a navy and teal colour palette). Your role is to take this existing code and turn it into a live, hosted website.What we need:— Ability to implement clean AirTable data base— Experience deploying softr App— Custom domain configuration (singleuseconnect.com)- A user access management— Basic SEO setup (meta tags, Open Graph, sitemap)— Mobile responsiveness review and polishThis is a focused, well-scoped project — the design is done and the code is largely written. We are looking for someone who can take it across the finish line cleanly and professionally, not reinvent it.Expected timeline: 2–3 weeks. Fixed price preferred.Please share examples of sites you have dep

Hello,My name is Luke Rosencrans and I operate Chain Reaction Motorcycle School.I am looking to work with an experienced AI automation specialist or small team to build a comprehensive AI-driven operations system that can automate a large portion of my business workflow, including communication with customers, scheduling, payments, enrollment tracking, and administrative tasks across multiple platforms.The goal is to create a centralized system that acts like a digital front office and significantly reduce the amount of manual administrative work currently required to operate the business.I already have many message templates created that can be used to communicate with students, including templates for:• scheduling confirmations• follow-ups• payment reminders• enrollment instructions• class preparation instructions• frequently asked questions• links directing students to the correct signup pages on the websiteThese templates and signup links can be incorporated into the automation wor

Hi all, Im trying to build a timeline and all the surrounding forms to manage the factory bays and mechanics on airtable.I’m wondering if there’s any way to colour mask (possibly the background) the weekends as well as masking off the day-offs of the mecanics.  Is there a way to do this on airtable or possibly on extentions? Thanks for your attention.

Hello! I have an automation that runs once a week (so scheduled time trigger) that generates a list of names, email addresses, and tasks based on certain conditions (so Find Records action). I need this email to be sent to the addresses in that list. How can I get this information into the To field?I was able to do this with a “record updated” trigger, but I need it to be a scheduled email.

I am trying to build a system for a one-man business so the owner will be the only user.  While I’m building at least, how do I restrict the owner from being able to edit anything other than what has been allowed in Interfaces?

Hi everyone,I’d like to know if, on the Business plan, there is any way for a user on the Free plan to update or modify a field in a base without incurring additional charges.Is this possible through automations or any other workaround?Thanks in advance!

Current Table Current Interface ViewCurrent “Start Tracking” button AutomationCurrent “Stop Tracking button Automation step two … unsuccessfulThis is my current table, interface and automation set up to try and create a time tracking interface. I am stuck on the “Stop Tracking” button automation. I can’t seem to be able to update the “End Time” field with the current time when the stop tracking button is pressed. Thanks!