Skip to main content

User Groups
Product Ideas
Events
Academy
Help Center

Welcome to the Airtable Community!

Ask questions, get answers and engage with your peers

39,545 Topics
122,160 Replies
101,033 Members

Get Started

New here? This is a great place to start

Ask the Community

Get support directly from your peers

Builders Board

Celebrate your Airtable wins

User Groups

Forge connections with other Airtable users

Events

Explore and RSVP for upcoming events

Announcements

Read the latest news the Airtable team

Check out the Enterprise Network ✨

Check out the Airtable Enterprise Network (or 'AEN'), the exclusive hub for Airtable Enterprise customers. Access private events, connect with peers, and ask your top of mind questions here.

ENTER HERE

Airtable Enterprise Network

What's New in the Community

The Community Digest

Categories
Recent Activity
Help Others

Welcome

Welcome to the Airtable Community! Check out our resources on this page to help you get started. Lets learn and grow together!

Getting Started on Community

Getting Started on Community

12 topics

Onboarding Resources

Onboarding Resources

12 topics

Announcements

258 topics

Ask the Community

Ask the Community

Automations

5016 topics

Base Design

3227 topics

Formulas

5853 topics

Development & APIs

Development & APIs

3604 topics

Interface Designer

Interface Designer

1272 topics

Other Questions

Other Questions

14344 topics

Builders Board

Builders Board

Show and Tell

995 topics

Product Discussions

Product Discussions

2 topics

Jobs Board

1000 topics

Legacy Product Ideas

Looking for a post that was once on our legacy Product Ideas page? They're all viewable here. Note that all future product feedback must go through the new Product Ideas submission form here: https://community.airtable.com/p/product-ideas

Legacy Product Ideas

Legacy Product Ideas

2697 topics

aruckerbuiceNew Participant

Need to automate sending an email identifying a unique record

I’m trying to identify where a record has an expiration date and send an email identifying that record.I can automate an email that recognizes the expired date but can’t find a way to attach/send the identity of that record. I have a log (record from a table) and the entries have a field “expiration date”. My automation finds that record and sends an email that a record has expired. I need a way for it to not only do that but identify what record that expired (separate field). Is there a way to do that?

sonialeuNew Participant

JSON/Object Error Automation Between Airtable and Circle

Hello everyone,Goal: When new or updated Record in Airtable --> Create Event in CircleAirtable: https://airtable.com/app2Ndd4eV463aOsy/shrbaX4IOs9mGkQoPCircle API: https://microconf-de57a9.circle.so/settings/api?page=1 There are 3 required fields to Map:Name of Item --> Name of Event (Single Line field in Airtable)Description --> Description of Event (Long Text field in Airtable)Start Date Time --> I have tried both in Date Format and Also Single Line Field.I have tried both Zapier and Integrately. In Zapier I get JSON error and in Integrately I get [object Object] error. I believe the Start Date Time is the error but I have tried multiple formats, ensuring it matches with Circle API and even tried converting to plain text and copied the exact same format as in Circle API (minus updating the year to the future). Not sure what I am missing.   

OPEAConsultNew Participant

Development & APIs

Receving error 302 'Moved Temporarily' when using fetch method on apps script

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

crotheyNew Participant

Other Questions

Copy and paste statuses across list view records

Hi! I might just be silly, but is there not a way to copy and paste a status across several records in list view? In grid view it’s easy, just copy a cell and paste. Is there not an easy and quick way to do this in list view?

Ayesha_BoseCommunity Manager

Airtable Portals: Now Generally AvailableNews

Hello! I'm Ayesha, a Product Manager at Airtable. We're excited to announce that Portals is now generally available, giving your organization seamless guest access capabilities. What are Portals? Portals let you invite users outside your organization as guests to your interfaces. These guests will see a branded sign-in screen and can collaborate within your interfaces—making it perfect for:Client portals: Give clients real-time access to project updates and deliverables Vendor management: Create a centralized directory where vendors can track projects and view invoices Customer support: Provide customers visibility into your roadmap and collect their suggestions What's new in our GA release? Branded experience for external users:Simplify access for vendor-client relationships, contractors, and more Customize the sign-in page with your logo and background image Scale affordably with lower-cost guest seatsFull control for admins:View all external guests and their access points Restrict g

Peter_ColesNew Participant

Development & APIs

Escaping of data in formulas for API calls?

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?

Luciano_MamminoParticipating Frequently

Development & APIs

Standard way to prevent formula injections when using AirTable `select` and `filterByFormula`

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

joerazorNew Participant

Need an Airtable Expert to help me sync Crypto Ask/Bid prices from Exchanges to Airtable in Realtime

I am trying to sync the Ask/Bid prices of several cryptocurrency prices, along with their trading volumes, from different exchanges in real-time (Or at a maximum of every 2 minutes) into my Airtable via API or any possible alternate method.I have attached a screenshot of how I would like my table to look like.There will be a list of ~2000 cryptocurrencies that I need to be constantly updated. If the specific cryptocurrency is not traded on a specific exchange, it should leave the field empty.I was able to get the job done via DataFetcher, but unfortunately, it is not a cost-efficient approach.I am open to getting this done via Javascript scripting if possible.I am looking for something cost-efficient in the long run that will not require hundreds of dollars every month.If you can get this job done, please let me know. 

madisenbaldwinKnown Participant

Interface Designer

Mobile Interface Delete Confirmation

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.

Sean_Hyland1New Participant

Development & APIs

Connecting airtable with payment gateways

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

aruckerbuiceNew Participant

Need to automate sending an email identifying a unique record

I’m trying to identify where a record has an expiration date and send an email identifying that record.I can automate an email that recognizes the expired date but can’t find a way to attach/send the identity of that record. I have a log (record from a table) and the entries have a field “expiration date”. My automation finds that record and sends an email that a record has expired. I need a way for it to not only do that but identify what record that expired (separate field). Is there a way to do that?

OPEAConsultNew Participant

Development & APIs

Receving error 302 'Moved Temporarily' when using fetch method on apps script

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

crotheyNew Participant

Other Questions

Copy and paste statuses across list view records

Hi! I might just be silly, but is there not a way to copy and paste a status across several records in list view? In grid view it’s easy, just copy a cell and paste. Is there not an easy and quick way to do this in list view?

BenFortunatoKnown Participant

Repeating group - error on one script doesn't generate error for automation

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.

jejohnsonNew Participant

Other Questions

referral management

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.

BenFortunatoKnown Participant

Link to interface page with specific filter - understanding airtable's filter parameter values

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.

DodybuddyParticipating Frequently

Other Questions

Weird auto-correction issue when validating text in Airtable (only on one computer) - Bug report

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

Corosh ToshangNew Participant

Looking for an Airtable expert (with Make.com & Softr experience)

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!

DodybuddyParticipating Frequently

Other Questions

Restore confirmation message to delete reccord

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 !

Emma-RFPNew Participant

Date counting formula weird results

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

Welcome to Airtable Community!

Make sure to register or log in

Please read our community guidelines

Join one of our user groups (+ events!)

Help others in the Ask a Question area

Community Events

Leaderboard

Airtable Academy is free for all Airtable users and plans.

Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.

Sign up for Airtable Academy Get Airtable Certified 🏆

Powered by Gainsight

Terms & Conditions

Platform Platform Overview Integrations Extensions App Building AI Connected Data

Solutions Product Marketing Operations Human Resources Sales Finance

Learn Airtable Academy Events Video Center Demos Customer Stories Webinars

Resources Partners Services Developers Community Templates Airtable Universe

Company About Careers Blog Status Newsroom Try Airtable For Free

Security API Sitemap Privacy Terms Do Not Sell/Share My Info Cookie Preferences

Sign up

Already have an account? Login

Login with SSO

Log in with Airtable SSO

or

Username *

E-mail address *

Password *

I accept the terms of service

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

Log in with Airtable SSO

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK