Ask the Community

I have a base with a table: Scores that has 2 fields in it. Field 1: TeamName, Field 2: QuizScoreWhat I would like to accomplish is to generate a leaderboard where the Average QuizScore per TeamName is displayed. There may be several TeamName records with differing QuizScores.  I do not want to show the detail records in the Interface. Just the summary records. I'm not sure the best way to do this. I managed to link to table: AvgScores, where I calculate the average. But, I cannot figure out how to do an animation, where when a new record is added to Scores, how to I update AvgScores. The TeamName is created in another application, so, I can control how it is spelled/formatted. So, I can match a field in AvgScores. But, I can't figure out how to do that either. I'm an old SQL hack...

I am designing with softr portals for my teachers. They don't access airtable but interact with data through softr. For assessments I would like then to be able to edit all records more like a spreadsheet way,vseeing 20 records for 20 students for example and being able to grade them all without having to edit record one by one as they could do with an airtable access m is there any way, platform, existing I did this ?I’m designing teacher portals using Softr, where teachers interact with data through Softr rather than accessing Airtable directly.For assessments, I’d like teachers to have a spreadsheet-style view, allowing them to see multiple records at once (for example, 20 students' records) and enter grades efficiently across all records without needing to edit each one individually. Essentially, a way to edit data in bulk, similar to what’s possible within Airtable. Does anyone know of a platform or integration that supports this functionality?I

Hi AllI am trying to connect to airtables through power bi and have the API setup with the key, base id and table id. however when i enter the details into Power Bi i get an "We couldn't authenticate with the credentials provided. Please try again." error. now sure why as i do have access to the airtable with the same power bi credentials.Thanks 

Hi all,I am trying to update a select field options, as mentioned in the documentation.It would seem that I can not update the options of a selectField within my automation 'Run a script' module.Documentation :Errors :Code:    // Create new entries if necessary const uniqueUpdateOptions = sortedRecords.map(record => record.fields['Price Wave Number'].name); const newOptions = getNewOptions(uniqueUpdateOptions); const selectField = priceWavesTable.getField('Price Wave Number'); await selectField.updateOptionsAsync({ choices: newOptions }) // typescript is not sure this will

I’ve built a client meeting interface for my team with the following elements: Client record dropdown element Meeting record dropdown element Client Goal filter element (to filter for only the goals linked to the meeting) Client Action Item filter element (to filter for only the action items linked to the meeting) My objective is to generate an automated URL to view the interface with all 4 elements prefilled. I’ve been able to prefil the client record and meeting record, since these only use record IDs. However I can’t seem to identify what data type the filters utilise in their url code. Here are some examples of one of the filter’s URL code: 0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjWEtBdGMzQmJaY0JlaUYiXV1dfQ 0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjR1pWRzc1OU50Q2JORDkiXV1dfQ The bold part appears to be the value of the filtered meeting, but is clearly not a record ID.

 I want to calculate the average income per hour correctly by dividing sum of total price by sum of total hours. In the left number the average is calculated incorrectly by dividing the sum of income per hour with the number of projects. Is this possible? I would need calculations in the interface I guess.

Hello!I have a table that has multiple tabs. If on Tab A, I have a column of costs, am I able to link the sum of that column to a cell on Tab B?I know that I cannot use Airtable like I do Excel, but I am trying to do it anyway because I really love working on Airtable.!!thank you for your help!  

I’m working with two tables in Airtable: "Application Data" and "Personal Info". Here’s the setup:Application Data Table:Contains records for each application a student submits.Students can submit multiple applications, so they may have multiple records in this table.Has a column called "Full Name" (used as a unique identifier to match records in the Personal Info table).Has a checkbox field "Reviewed" to indicate when an application has been reviewed.Has a linked record field called "Personal Info Link" which should connect each application to the corresponding personal info record.Personal Info Table:Contains one unique record per student.Has a "Full Name" column (used as a unique identifier to match records in Application Data).Has a

I've had a simple "LInk to Another Record" field working flawlessly for years.  All of a sudden it stopped working correctly., sometime between 9/27/24 and 10/31/24 . I give you the dates because I'm almost certain that there was a note from Airtable that popped up in the last week or two about new AI features, and I see that on the Link to Another Record field there is a new option that wasn't there before--to use AI (see attached screenshot).AI addition or not, here's the behavior:- On existing records, it's still working, sort of. Although if I change the field (Field 1) it is using to select a field from the target table, it doesn't grab the new record.- On a new record, The Link to Another Record does not bring in the record field. So on new records, I now have to out my cursor in the Link to Another Record field, and manually select the record I need.Any ideas?   

Hello, I am trying to collect two types of survey responses through Fillout parent & child form that are linked to two separate Airtable tables.1) I am using the record picker option on Fillout to let respondents create new records. Currently, only child form responses are updated on Airtable and the parent form responses do not get updated on Airtable even though they are integrated correctly. What could be the issue with this problem?2) Is there a way to set titles to the new records created by respondents? Currently the new selected record appears as a blank. 3) Even though I have integrated the respondent identifiers for both parent and child form, the unique link to log or identifier (name) columns do not get updated on Airtable. Is there a solution for this? Any help will be appreciated. Thank you in advance! 

Bonjour,Je souhaite créer des listes de choix dynamiques. C'est à dire que si je choisi une "Catégorie" dans un menu déroulant, ça limite le choix dans le menu déroulant du champ de la "Sous-catégorie" aux sous-catégories associées à la catégorie sélectionnée.Est-ce bien possible (j'ai trouvé aucun script, même avec chatgpt) ? auquel cas comment ?Je vous remercie pour vos retours, c'est un sujet basique mais récurrent qui me pose problème sur quasiment toutes mes bases...Damien

In the new forms section there is no way to sort your form title in the left forms list.Allow sorting of these forms both by drag and drop AND alphabetize like we do all the time with fields like single selects. Thank you!mpollock@olamilaunch.org

I turned off an automation as I wasn't ready for it to run. The automation was set to go off at a certain date. When this date was reached the automation ran even though it was turned OFF. Should automations run if they are turned OFF? 

Hi there,I am building a base with 2 tabs: the first one is for data entry and to be linked to the second tab which contains standardized data.  About 5-10% of the data in the second tab updates frequently and the data in tab 1 must reflect the data in tab 2 on the date of entry, meaning the data in tab 1 should maintain the old data and if new data is entered, it will show the most current data from tab 2.How do you counter this problem?  Any insights or help will be appreciated.  Thank you very much! 

To create a base through API you  need to provide a workspace_id -> https://airtable.com/developers/web/api/create-baseBut I can't find a way to list the workspaces a token/user has access to. How do I get the different workspaces for a token (in non-enterprise accounts) ?

Hello there,I am trying to automatically delete records after 1 week. As I am in free plan, I can't run scripts (currently I don't want to upgrade). I set up a field which tags every opportunity with a delete text. Can someone tell me how to solve that with the Search Step in Make (formerly Integromat). The following delete step is not the problem, I guess. Somehow, I just don't find the right formula.Thanks in advance!

Hello,I was notified by Airtable today that I am part of a minority of users using way too much API on the free tier, costing Airtable money. The email instructed me to look at my offending workspace. Unfortunately, the workspace sums all base APIs but does not break down percentage used by individual bases, making it impossible to tell which is the offender. How do I find out which base is hammering the limit? How much API limit will I get if I upgrade to team? Why is this information so cryptic?Thank you in advance,-API Hog

Hi there,I've created a base where I track all of the marketing activity for a number of shows, and now wish to track the weekly sales and present them in a line graph, similar to how you would in Excel.At the moment, I have a column in a table called 'Revenue To-Date' where I update the figure. However, this is replacing the data each time rather than tracking it in order to show trends. I'm open to using an app or building out another table but would love a simple way to update this via the interface I have built out.The data itself comes through via an email each day as an Excel spreadsheet, so if there was a way for this to be automated, too, I'd love to learn the best way to configure.Thanks in advance!

Hi all,Having a really rough time trying to update a (User) record through Script.I am trying to update multiple fields, names and types below:Leads: Linked Field"Source": Multi-Select"Marketing Consent": Multi-Select"Landlord of Properties": Linked Field"UTM Source": Multi-Select"UTM Medium": Multi-Select"UTM Campaign": Multi-SelectI have checked my personal reference, and the scripting docs, and I can't for the life of me figure out what's going on... I have double-checked that the multi-select field options are present before trying to update the record, but my issue highlighted in the issue below:Example Log of Values: Example Multi-Select // uniqueLandlor

Hi, I have some columns in my table where I want to use a formula but also link the data from that column to another record. Is that possible? Thanks. Tom

Hi allI'm trying to create an interface (dashboard) that uses a report Filter on client ID (eg. so that client A can only see client A data on the dashboard) (https://support.airtable.com/docs/interface-element-filter).I have shared the interface to a test user as readonly, however the test user can simply change the value in the filter on top of the dashboard, then he can see any client's data.What I'm looking for is to grey out the dashboard filter value, so it says client = "client A" for client A, and client = "client B" for client B etc).... I know I can create a different view for each client, however this is a lot of manual work as the number of client increases...Any suggestion would be much appreciated!  

Hi, I want to create a new record and link it with the right assets.Creating the record goes wel, but linking the assets won't work.I get this error. I am a bit new to airtable, maybe it is a beginner mistake.Thanks in advance.Greetings,Robin   const inputData = input.config(); const { txt_name, txt_files } = inputData; // Specify the tables let postsTable = base.getTable('Social media posts'); let assetsTable = base.getTable('Assets'); // Create a new record in the 'Social media posts' table and capture the ID let newRecordId = await postsTable.createRecordAsync({ 'Naam': txt_name, }); // Update the record in 'Assets' where the ID matches txt_files, setting "Social media posts" field to the new record ID await assetsTable.updateRecordAsync(txt_files,

I send emails using Airtables automation.   You can see when an email is sent from inside the automation setup.  Is there a way to put a field in a table that lists the last date an email was sent to easily see email history? 

Bonjour à tous,c'est mon premier post ici, j'espère être au bon endroit. J'ai déjà cherché les sujets en ligne mais je n'ai pas trouvé de réponses.Je suis débutant sur airtable, je souhaiterais faire des connexions entre deux tables d'une même base de données. Je m'explique, je souhaite créer mon CRM immobilier ou mes produits à vendre qui ont des caractéristiques spécifiques : ville, prix, nombre de pièces, jardin etc... pour être "confronté" aux recherches de mes prospects qui ont les mêmes caractéristiques de recherche.Par exemple, si j'enregistre un nouveau bien avec la caractéristique ville + prix + jardin + nombre de pièces, proposez-moi tous les prospects qui ont cette même recherche (idéalement avec un pourcentage d'erreur sur le prix) et inversement si j'enregistre un nouveau prospect.Je cherche depuis plusieurs jours une solution,

In my base i have made an automation that sends mail ( gmail) but whatever i tried it keeps giving messag " the To" is empty, there are nog blank fields in the row ( email) i ve made a roll up with the fix ( found on another thread ) .. after days of testing i didnt solve the problem.. can anyone help me please??A link to the loomvid https://www.loom.com/share/d497132a3ddb47c9a6ce93030e103e4b?sid=131789ac-7d4b-4f19-b43c-871452ce6fda