Ask the Community

Hi All – I have a large base which essentially functions as a CRM.  The first field in the base is “partner name” and the subsequent fields are information about the partner - location, bio, Linkedin profile, etc.  We use the base to track engagement and other touchpoints with the partners.  I want to build an end-user interface while allows my executive director to input the name of an individual from the base and then have it return a few specified fields.  For example, the ED has an end-user interface and is instructed to input a partner name.  After inputting the name, the interface returns Linkedin profile, bio, and last-emailed (all fields that we collect and keep up-to-date).  I know it’s possible to just make my ED an editor and give access to the entire base but we have 50+ fields and I want an more user-friendly experience.  Privacy is not the concern here, rather my ED doesn’t need to see all the fields and details in the base.  Is this kind of build possible with an interfa

I ran into Airtable’s row limits and pricing walls, so I built a free browser-based tool that lets you export full bases — including tables, links, and attachments — into a clean ZIP file.No data ever leaves your browser.No account required.You can try it here if you're curious: https://ar.konanx.comWould love any feedback or ideas for what to add next — especially if you’ve had similar Airtable pains.

What happened to the Pretty Print link?  It no longer works, but there are so many references to it for formulas.

Is there a way to wrap the text in a filed name?

I notice that while i have a confirmation enabled on the computer for the delete button on an expanded record in the interface, I do not have to confirm to delete from mobile which has been risky for my team as we use our mobile devices frequently in the field and its easy to accidentally hit that big red button. There is also no way to undo on mobile if you miss the brief "undo" float message. Am I missing something? It would also be nice to have a delete confirmation feature when add/delete records in line is enabled for calendar, list, kanban views, etc. on an interface. I want my team to be able to click the calendar to easily add tasks to a certain date without filling out a form for each but I don't want them to accidentally delete records either.

I am trying to set up specific filters after a user clicks a button to visit an interface page. It seems that there is no native way to do this given the options airtable gives you,. It also seems like there is no way to add url parameters to an http address  but I thought it might be possible to just do this using url parameters and a http page.Maybe there is a way to do this with a script? I’d have to figure out what the parameter values for the filter are, and then also have some way to redirect to a new page which might not be possible in the airtable scripting environment.  

I'm trying to use a web app deployed via Google Apps Script inside Airtable Extensions and Automations by selecting "Run a script." However, I'm encountering the following error:Response status was 302 'Moved Temporarily' but redirect mode was set to 'error'Despite this error, the action triggered by the request is actually executed successfully.I tested the same request using Thunderclient and did not encounter the error — everything worked as expected.Searching the community, I found a workaround suggesting the creation of a webhook to handle the requests. I implemented this through Zapier, and using the webhook, the requests now run successfully within Airtable (both in Extensions and Automations).However, this setup isn't ideal for me because it adds an unnecessary (and paid) middle step just to retrieve a simple success response from my Apps Script API.My questions: Is there a way to configure Airtable to prevent or handle this 302 error directly? Or, is there a better solution

Is there a preferred way to escape data inside formulas when using the API? For example if we pass a formula into an API call like '{name} = ' + name where “name” is a variable that might contain user-generated inputs, then what’s the best way to escape the “name” variable? The best I can find is to escape quotes? Using an escape character in a formula? But is there a more standard library (I happen to be using Python) or escaping approach that can be applied (like would I use the csv or json module)? Or is this documented somewhere?

NOTE I originally wrote this in a rush hoping that the information provided here would be sufficient to start a conversation. It turned out it was not. Please refer to this comment below for a better explanation (and A DEMO) of the issue: Standard way to prevent formula injections when using AirTable `select` and `filterByFormula` - #15 by Luciano_Mammino Hello, When using your APIs to get data dynamically from a table, is there any secure way to handle formulas that need to contain user input data? How can we avoid a user trying to alter the formula by crafting an injection (like a SQL injection but for your formula language)? I couldn’t find anything in the docs, nor any utility in your (JavaScript) SDK… So far I had to come up with my own escape function… In case you need an example, this is my formula: {code} = 'someCodePassedByUser' If the user passes the following code ' >= 0 & ' I end up with {code} = '' >= 0 & '' which is always TRUE! Considering that injections

Hi There Hope I can get some good info on my issue.I have a client that manages their operations on airtable (We helped set it up).They are now quoting and invoicing from airtable using third party integrations. We are also collecting deposits via a 'mini extension' extension with a stripe integration. The Quote sent to the client has a stripe payment link which is a prefilled payment window. It has the clients name and the amount to be payed. When the payment is made the second part of the automation kicks in. A field in the airtable record gets marked paid. This allows us to easily match bank payments to clients and move the project into the scheduling process. It saves a lot of time.Our client company now wants to set up a payment automation using API/webhooks for another well known payment's gateway provider. The provider has the tech in place but I wanted to know if their are any airtable specialists that could bring specific know how to help create a similar automation?Regar

I have a script that is using a repeating group to batch process a couple of records sent through output.set() If one of the scripts fails it doesn’t seem to register that error in the overall automation. See image below, individual script failed, overall automation is giving me the green light. I noticed that the script wasn’t behaving correctly on some records but having the script not throw errors is potentially dangerous as problems stay hidden.  

I am looking to create a form that will collect referrals from teachers that will store all the referrals in one place for those responding to these referrals to be able to act on them and then have the outcomes of those actions be shared out automatically preferably via email but I would also like the referral data to be easily sortable into specific students as reports that can be printed and have the ability to attach other files to these referrals.  I would l also like to be able to analyze all of the data for trends and patterns as well as look at individual student data for trends and patterns.  I have no idea where to begin and if airtable can even do something like this.

Hello appreciate the community’s help here. I am uploading a CSV file on a weekly basis (the data is from application form submissions on google form). So every week I am getting new applications in. I uploaded last week matched the fields and all was good. I even started reviewing and syncing some applications on the airtable base. I had 10 applications last week. This week I got 17 more. So I downloaded CSV file (business as usual). I went to airtable and uploaded and suddenly i realize it created 27 new records. I proceed and on the base I find 10 old records + 17 new records (out of which 10 are duplicates from the old upload). How can I prevent this from happening, appreciate your support.

As in archived copy of this thread :Re: Automations error (but not on Block): Response status was 302 'Moved Temporarily' but redirect mode was set to 'error' Can someone in Airtable update me about the issue of allowing redirects in API/fetch requests in code in automations ? This is needed urgently , so that we can connect airtable to google sheets. (as i create an API in google apps script) so the behaviour of google apps script is, it redirects the requests to another url when you pass a parameter into itself.example :  if you send a get request to in automation: https://script.google.com/macros/s/*******-g/execgoogle redirects the paramteres into :https://script.googleusercontent.com/macros/echo?user_content_key=*******thus, when i set an automation in when a data updates in airtables scripting section, i get this error: I dont want to use any 3rd party services to solve this problem. Thanks 

We are using Airtable to organise our plant nursery. We need it to track the stock of plants in the nursery and match to orders etc. Its a bit different to normal stock tracking where we might track "current stock" by adding to stock when we get in stock and subtracting as orders go out because we have to grow the plants from seed and there are often plants dying, not being good quality etc. So we often have to go out and count the actual plants in good condition on the tables to get an accurate idea of stock count. But we also want to be able to subtract from the stock count automatically as stock is sent out. So we have a conflict between what we want to enter as our current stock levels - if we have a calculation in the current stock field - auto subtracting deliveries - we can't simply type in a number when we do a manual stock count. Any suggestions on how to resolve this ?

Hi!I’m writing a script that will create a QR code that you can scan to open a record. It works to open in the data view without issue. But I need to have it go to an Interface.If I open an interface on the desktop browser then right click on a record, then click on "copy device URL", that URL will work on the iPhone. I can paste that URL into a note and when I click it, it opens the Airtable app and goes directly to the record in the Interface. Exactly what I want.The catch is, that URL has a bunch of extra base64 encoded stuff. I can’t figure out how to get the elementId , queryContainerId , and savedFilterSetId. Using this partly redacted URL for example:https://airtable.com/appXXXXXXXXXXXXX/pagLAWnn0AqECV5AG?detail=eyJwYWdlSWQiOiJwYWdZdkdwVG1VbXZ4eURpYyIsInJvd0lkIjoicmVjMktQeGpvbHpxc0dkV1QiLCJzaG93Q29tbWVudHMiOmZhbHNlLCJxdWVyeU9yaWdpbkhpbnQiOnsidHlwZSI6InBhZ2VFbGVtZW50IiwiZWxlbWVudElkIjoicGVsRHhZVTlPOFp3T3draTgiLCJxdWVyeUNvbnRhaW5lcklkIjoicGVsM0ltR0tBOVpQRmhqVEoiLCJzYXZlZEZpbHRlclN

Hi guys,I have an Airtable base with several tables, including one for “persons” and another for "sectors".The "sectors" tables link persones to fields specific to a sector.In the interface, for a specific sector, I had created a Kanban view where the stacking field was set to the ”person” :“Person” stacking field is availableHowever, after changing the interface, I noticed that I could no longer select the "person" field as the stacking field.“Person” stacking field doesn’t appearI have tried to replicate the table from the older version but I can’t manage to make the “Person” stacking field appear again.Could you please help me understand what might be causing this issue? Thank you! Marino

HI there - I’m about to pull my hair out and have been trying to figure this automation out for several hours now. I have a table called “Field Enrollment” where I am tracking “Producers” with their unique farm #, tract #, and field #. I have a concatenate formula to give me “Farm Key” which is Producer & Farm. I have a second table called “Producer Enrollment” that I want to be auto populated by the Farm Key. However, there are cases like in my example where there are duplicate Farm Keys and I only want the one. (A bit more context: In Field Enrollment we are required to track data related to the unique Farm/Tract/Field. In Producer Enrollment, we are required to track other types of data related to the TOTAL farm, so essentially a roll -up from Field Enrollment.) How do I create the unique record?!   Example Field Enrollment table: Example Producer Enrollment table:  Here’s the automation I thought would work and is saying is working (but it’s not)  

Hello everyone, Here is a weird behavior I would like to understand…On one of my computer (and only one), when I validate text in a cell of my text column (when I press enter or change cell after writting something), Airtable sometimes modify some words of the content arbitrarily… Here is a true exemple “remportent” automatically transforms into “représentent” in the next sentence, which often change the meaning of the sentence (and being a journal it’s compromising). Exemple : Les Auvergnats remportent le match contre le LOU.Automatically becomes : Les Auvergnats représentent le match contre le LOU.  Here is my text field :  I tried the same sentence on another computer and the phenomenom doesn’t happen… It happens that I share my session and credentials with team members and that we use the interface with the same credential at the same time but this happen whether or not I’m alone on the session. Very weird. If someone knows about it or is experiencing the same thing, I would really

Hi!We are looking for a skilled individual or company experienced with Airtable, Make.com, and potentially Softr. Our goal is to customize a database solution tailored to our specific needs.We’re looking to: Optimize and structure our Airtable base Set up automated workflows with Make.com Possibly create a frontend for the database (using Softr or another tool) Connect Airtable with our website/backend Preferably, we would love to work with someone based in Sweden or who is comfortable working in Swedish, but this is not a strict requirement.If this sounds like something you can help with, feel free to reach out via DM or comment below. Looking forward to hearing from you! 

Hello, I accidentaly misclicked the button “do not show this message again” when the confirmation message to delete a reccord appeared.I would like to restore it please. I tried to explore interface settings while looking for this fonctionnality but without success. If anyone as an idea, i’m all ear.Thanks and have a nice day !

Hi all, I am copying over historical data into a new Airtable system and I am using the following formula for calculating the number of days taken to complete a task IF(  OR({Date Completed}, {Date Completed Override}),  WORKDAY_DIFF(    IF({Start Date Actual Override}, {Start Date Actual Override}, {Start Date Actual}),    IF({Date Completed Override}, {Date Completed Override}, {Date Completed})  ),  BLANK())It works just as intended, it counts the number of workdays to complete a task, using the default field unless an override date is being used.However, there are one or two results that are just way off. As an example, one record has the following values:Start Date Actual: blankStart Date Actual Override: 1/3/2025Date Completed: blankDate Completed Override: 23/4/2025Completed Task Duration: 474831What is baffling me is that there is another record with exactly the same dates that is correctly returning a value of 15.The default fields are auto generated via a formula, and the ove

hi there. Ive been trying to setup automation emails and links were showing as hyperlinks in the beginning as I was testing, but now have stopped showing Please advise. 

Hello, I’m trying to add a link to my automation, but nothing appears when I add the field even when using parenthesis. Could the fact that the url field/column is a formula link be the reason why the link does not appear in the automation? Left is the column/url i’d like to pull in & the right window is the automation I am trying to set up. tyia!

Hi, for a given record, I have data attached to linked records of linked records that I’d like to lookup. I remember this was really easy to do in FileMaker, but I can’t seem to find a way to do this in Airtable, unless I add lookup fields in each table? Any idea/solution would be greatly appreciated - thanks!