Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
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.
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
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.
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.
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
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
Have automation to run when record is created, When record is created, It will set added_date, add_by(person email) and set record as active. It does 2 of 3… It doesnt add person email address. What could I be doing wrong?
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.
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.
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?
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
Hey guys,Is there any plans to make it so that when someone copies a base from a public share link, that the automations also get copied across?I create a bunch of systems and templates for people to try and get them in to using Airtable but this is big limitation when it comes to offering these types of solutions as the automations are really a big part of any system.Is this going to be possible at any point or is there a good workaround at all?
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.