Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
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
Hi,I have an automation that is triggered when a record is created in Table X, and it then creates a new record in Table Y. This automation has been working well, but recently, I've noticed some failures in the Run History.It's not happening with all cases—only some. The trigger and all other actions work fine; the only issue is with the creation of the new record. The error shown is: “Creating the record failed due to insufficient permissions.”However, when I take the same record that triggered the automation and run a manual test using it, everything works perfectly and the record is created successfully.This is quite confusing—I don’t understand why some records fail while others don’t, and why it works without issues during manual test runs.Could you please help me troubleshoot this?
Is there a way I can share just a single record with an individual, via a customized link? My nonprofit runs a program where people apply and then their application goes through various stages. We have an Airtable form (as the application), which links to a base where each person’s application is displayed as a separate record. We would like a way for people to automatically view the status of their application, so we are trying to see if there is a way to share their own record with them, but only their record-- not anyone else’s records in the base. Obviously, we could copy and paste their record and send it to them, but we often are contacted multiple times by people who are wanting to know about the status of their application as it moves through the phases, so we are curious whether we could create a custom link that we can send to people after they initially submit their application. The idea would be that they can then return to the same link periodically to see updates in t
In my interface I can provide a Pie chart that will show the % of yes and no responses to a survey question.Each response, yes or no, is tied to a month value. I want to see the % over time of the people that reported yes to display a trend chart month over month. Example in Jan 42% reported Yes, in Feb 100% reported yes. This would be similar to my average satisfaction score month over month. How do I take the Yes/No answers and convert them into a % of the population in order to track month over month?
I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!
I’m trying to display metrics on claims details on a line or bar chart. I would like to be able to insert a “goal” line so we can see easily if we are above or below our goal. Is there a way to do this, or is there anything in the works that could accommodate this request?
Hello, my airtable is used within data within a project management platform I built in sotfr. my client portal users enter data via a softr modal which lands into the airtable and a softr table view that displays the entered data. I need each entries of by user to be auto-numbered from 1 to whatever the final entry is.For example if the data represented a christmas wishlist, and little bobby entered a “toy truck”, “building blocks”, and “book”, I need the list to show:toy truck Building blocks bookAnd if little tommy entered “Basketball”, “ipod”, and “ball cap” the list should be basketball ipod ballcapThe number needs to be hard coded to the entry, so that when the list is sorted differently the number follows along, for example, if I sort little tommy’s list within the softr presentation layer alphabetically the list should be:3. Ballcap1. basketball2. Ipod So how do I assure that the user’s entries are getting numbered automatically and the numbering range is limited by the scope of
Hi all, I’m running few food courts in parallel in our company. Each is in a different location. I want to create a process that will help me do the following: Create a menu for each day of the week (maybe even more than 1 menu per day as we have few meals) including the amount available for each item in the menu Allow users to order 1 item from the menu (per day, per meal) Allow the kitchen manager to review the orders Allow the kitchen worker to mark orders as delivered Later I would want to create some dashboard stats & inventory management. I would be happy to understand if there is a template that works best for me or how do I build this? Thanks, Shay
[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields📌 The problemI'm constantly getting this error: pgsqlCopiarEditarRuntimeError [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text. Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.🧩 Airtable Table Details: Table Name: Table 1 Fields: Nome do Cliente (Single line text) Produto Qtd Valor do produto Valor Total Data da Entrega ✅ Confirmed: Date with time format ❌ Formulas tested (all returned 422 errors in Make): plaintextCopiarEditarAND( {Nome do Cliente} != "", IS_AFTER({Data da Entrega}, DATEADD(TODAY(), -5, 'days')) ) Also tried with IS_BEFORE, simplified formulas, and also using "ok" in a formula field with static text — still getting the error.✅ Formula that worked in a previous database: plaintextCopiarEditarAND( {Cliente} != "", IS_AFTER({Entrega}, DATE
Hi I would like to automatically open an input form based on a user input.I have a visitor request form(s), First I would like to ask the user to identify the visit type (Form 1), based on a selection of a single drop down. After the submit Form1 I would like to determine which Form to open next for more details based on their selection. How can I accomplish this?
Hi all, I want to do some fairly complex actions when my users create a new record, and in certain circumstances block them from creating it.Here is the logic that I want to run when I create a new record: If FieldA is not null Look for a record with matching FieldA If such a record is found, do not add this record, stop 🛑 Else: If FieldB is null Fetch BValue from external source with a script that takes FieldA as input If FieldB is now not null: Look for an already existing record with a FieldB value that matches what I found If such a record is found, do not add this record, stop 🛑 Else, update this record with the new FieldB value The first issue is that I have nesting “IF”s here. And I cannot seem to nest IF statements in the automation interface. Is there a way to implement nested-IF logic in an automation other than by creating a custom script? The second issue is how to delete the triggering record. Is there a way to
I’m missing which field/value is used with two tables are linked. Can someone point me in the right direction? In particular, I have a master business directory table and I want use automation to push in the linking value to the separate Department table. I would have thought that they are linked on the record id, but when I try to push the Department record ID into the master table, it’s not recognized. It seems to want the department name, which is not always unique. Is there a place to see the linking values between tables?
Hi Everyone! I have an automation that is set to find records in a certain view and send them an email. I know when in testing Airtable will only show the first 10 records, but it is also completing the automation for the first 10 records as well and right now that view has about 18 records in it. Any advice on whats going on with it?
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.