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
I am having an issue where I have a table that calculates a sum Total. I figured I could easily just show a user’s name + total on the interface but it seems very hard for some reason.Right now, I get the sum with a user’s name, but it then adds all of these columns for each unique sum there is within the data set.Example Image: And here is what the data looks likeSo I am just trying to make a table on the interface (as we will share that view) that simply shows Name + Total.I have a bar chart showing this, which kind of works, but just having 2 columns with plain text would be nice too in the interface.Thank you!
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?
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?
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.
