Ask the Community

// change these names to pick a view:let table = base.getTable('Invoices');let view = table.getView('Grid view'); let result = await view.selectRecordsAsync({fields: ['Amount']});let runningTotal = 0;for (let record of result.records) {    // change the field names here to adapt this script to your base    runningTotal += record.getCellValue('Amount');    await table.updateRecordAsync(record, {        'Running total': runningTotal,    });}

Hi, I hope you're all doing well. I wanted to let you know that I'm building a chatbot in n8n, and I need the IDs for my "Base" and "Table" sections. I'm using an AirTool node for this; however, I don't know how to access them through AirTool. According to Gemini, it should look something like this:Copy the IDs:The code that starts with app... (Base ID).The code that starts with tbl... (Table ID).

I have a table that lists the openings and closing of homes. Each record is a specific date and an opening or closing. So there is single select field that has the choices Open or Closed. Each record has a date and the single select and a customer and the property along with a few other fields. Right now 27 records.I also have a summary table with a link to the open and close table. Each record is a customer’s open and close records in the link field. That table has 22 records.I want to filter for the latest opens so I can create a list to email through an automation so I get a l list every week what's currently open.Does anyone have a idea of how to do this?.Thanks. ScottLinked table screen shotOpen Close Table Screenshot   

I’m trying to use the new ChatGPT integration with Airtable - specifically to have ChatGPT pull data from one of my bases in Airtable base . I’ve configured the settings in ChatGPT to connect to airtable, but Chat GPT is still asking me several times to confirm it has access to my base and other data points in Airtable. Is there a way to configure this to stop asking this question? It seems to be slowing it down. 

I have a question about adjusting my base design to accommodate a new data requirement.I use my base to run our property management company. It consists of 4 main sections: Customer tables, Contract tables, Property tables and Invoice tables. When I created the base I did not think about the possibility of a customer selling one home and moving and retaining our services for the new home. Silly me. Our customers are owners of generational homes in a resort and as such they rarely sell.In the contracts table I have a field that captures the year we took them on as a customer of that property. That year is derived from the signature date of the contract for the current property. All fine and good until they move. Now we have an old customer with a new house and the years as customer is now only valid for the new property. I lose the history of their original contract. I need to have a way to keep the original year.I have thought about putting a field in the customer table for their origi

Hi all,New to the community here 😊Quick backgroud, I use Airtable as core operational platform for enterprise-scale stadium delivery coordinating content, instructions, and approvals across major events. External stakeholders access structured workflows via a portal in Softr, while internal teams manage live production delivery in Airtable.I’m currently on Business and evaluating a move to Enterprise Scale.Before upgrading, I’m trying to confirm whether Enterprise Scale supports embedding Airtable Interfaces into third-party portals (e.g. Softr) with the following requirements:Embedded without public “share to web” access Users authenticate normally (Airtable / SSO) Interface permissions are enforced (role-based access, edit vs read) Users can edit records and reorder rows within the embedded InterfaceIn short: Can Enterprise Interfaces function as a secure, permission-aware embedded app inside an external portal?If this is supported:Is it native to Enterprise Scale? Or only available

Hi I am a New user to airtable. I need to create a quiz platform. I decided to use airtable for backend.But couldn't connect both and lack of guidance. Can you anyone please help me work around it its kinda emergency.

Hi Airtable Community,I’m trying to confirm whether the CSV Import Extension supports updating an Airtable Checkbox field from TRUE → FALSE when using “Update existing records / Merge”—or if there’s a known limitation/workaround.What I’m trying to doWe run a recurring sync where we: Export a CSV from Google Sheets that contains: a unique ID (used for matching) several columns of values one column that represents a boolean (e.g., TRUE / FALSE) Import that CSV into Airtable using CSV Import Extension → “Merge with existing records” Map: CSV ID → Airtable ID field (for matching) CSV boolean column → Airtable Checkbox field What works If the Airtable checkbox is currently unchecked (FALSE) and the CSV value is TRUE, the checkbox updates to checked (TRUE) correctly. The issue If the Airtable checkbox is currently checked (TRUE) and the CSV value is FALSE, the checkbox does not get unset—it stays TRUE after the merge/update. I’ve tested multiple “false” representat

I have 20 project managers. Every Monday i need to email each of them independently their list of jobs that meet specific criteria they need to take action on. I am starting to run out of automations for this base and am trying to consolidate this into a single automation rather than an automation per PM. Here is what I am trying to accomplishat scheduled time (good on this part) find records - find the PM by email address (this is a record within the table) I've taken this line out because it does not seem to be able to dynamically pull each PM, but m not sure how tog et the automation to accomplish this step. find records - when status1 <100%, and status1 due date is empty (good on this part) find record - when status2 <100% and status2 due date is empty (good on this part) send email - the PM defined in pm email address in the table gets an email listing the records in parts 3 and 4. These records are specific to projects he is running (cant get this to work correctly in a sin

I have a table called “Tickets” that my team enters project requests. Each ticket has a due date. A second table called “tasks” are specific things that need to be done to complete the project. Some of these tasks must be done a specific number of days (lead time) before the ticket due date to meet the deadline.I have a third table with standard tasks with a field called “lead time” that I use as a template to populate the tasks for each project.I want to be able to automatically enter the task due date based on the pre-defined lead time and the ticket due date. These dates need to editable to account for holidays and other conflicts, so I can simply use a formula.I want to create an automation that will look at the ticket due date and calculate the task due date (subtract number of days from said task due date) and enter it into the task due date. I can handle most of the automation, but I’m a bit out of my league trying to grab data from one table and use it in a calculation in anoth

I’ve spent hours on this and can’t figure it out. My goal is to simply click a button to trigger a N8N webhook trigger. Can anyone help me?

DescriptionI have a Tasks table with a multi-select field (e.g. values: A, B, C).I also have a Subtasks table linked to Tasks.Goal:When the multi-select field on a Task contains A and B, the automation should create two Subtask records: one Subtask called  A one Subtask called B (both linked to the same Task) Current setup: Trigger: When record is updated Field watched: multi-select field on Tasks Run Conditional Logic If condition are met: Type = A → create record A in subtask table Otherwise If condition are met: Type = B → create record B in subtask table Problems:Type in Task table = A & B, but the automation only run AHow do i fix this? Thanks in advance 

I’m working with a company that manages products, materials, and services across multiple Airtable tables.I want to use the Airtable API with Python to perform data integration / migration between two tables: A source table containing general product records A destination table where records must be created based on specific selected fields One of the main challenges is that I cannot rely on fixed column names, and I need a way to define which fields should be considered by the script when creating new records.I’ve read that working with JSON is the recommended approach by Airtable, but I’m unsure about the best practice to: Select only specific fields from a table Map them to the destination schema Maintain a relationship with a linked table (“categories”) My question is:What is the recommended way to automate field selection and mapping when creating new records via the Airtable API, especially when schemas are not fully standardized?Any guidance, examples, or design patterns w

Hello community,In our company we use Airtable in the Business version. This includes about 100 technicians who also have access.Since I now also use Airtable privately for our club, I’ve been thinking a bit about accounts and costs. This led me to the following thought:If I, as the workspace owner, have a Business plan, do all others who only fill out forms and enter data only need a Teams plan?Am I understanding this correctly? Or do all accounts need to be on the same plan level in order to work within the same workspace?

I’m looking for some advice re database design - and how to make the data entry easier using an interface…I’m a literary agent and specifically at the moment I’m trying to build the back end for tracking royalty statements. The tables I currently have are:ClientsTitlesContracts (which will usually only link to one client, occasionally two, but often multiple titles)Editions (which are created automatically when a contract is added and the formats a title will be produced in are decided - each edition will link to one title (although there will be, potentially, many editions per title, and one contract and which ever client/clients the contract and title are associated with). Payments (where I am trying to track the income and use views to be able to see what each client/title has earned)I’ve then gotRoyalty Statements (which is the top level statement info)Royalty Statement Detail (where a line for each edition covered is created so that I can record the sales/income for each edition. 

Hey all!  I work in higher education, and we use Airtable to do a lot of our forms and petitions. When students submit these forms, we require them to include their unique 10-digit student ID.  I am trying to do two main things: Whenever a form is submitted, the ID number is checked. If the ID number has not been used in a form submission before, it creates a “student profile” in a new table.  All forms that are submitted with the same ID number are grouped under the same “student profile” so that our colleagues using the interface will be able to see all forms submitted by a student.  Does anyone have any advice? 

Only 57 out of 98 columns are loaded through the query HERE in Power BI. Does anyone know how can this be fixed?

I have a form where respondents need to be able to select a topic and then see the draft definition of that topic. The problem is that the definitions are long and I cannot figure out how to make the form show the entire definition. I’ve included screen caps below.Is there a way to resize the field space that is offered in a form so that the longer text is visible?  

I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help? 

When I go to print a view or table, and hit the print icon, it goes “gray”.

In the left view column I have created forms. I also see that at the top of the page there is a row of links; Data, Automation, Interface, Forms. My question is should the forms created in View be duplicated in Forms or are they separate functions?Thank you if you can help.

My team recently inherited responsibly for the admin of an 850 seat Airtable enterprise license.We’re not an IT team; we’re just enthusiastic end users of Airtable, so we’re new to being admins.My question: is it possible to determine who gave out an editor license?When I go into the admin panel and hover over someone who was just upgraded, I get messages like:“[user name] was Editor on base [base name] on [date]” “[user name] was Creator on base [base name] on [date]” “[user name] made edits to workspace [workspace name] on [date]Is this telling me their last activity in Airtable?Is there a way to figure out who gave out the editor license they’re using?Thanks

I'm getting a pop-up saying "This form was upgraded" when I edit one of my forms.  I've tried both options it gives me, but I can't get the message to stop popping up.  It's unclear what to do.

i keep getting ‘Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.‘This error from n8n. any idea how to fix it?

I hope someone can help with this please  Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct  I’m not sure what I’m missing here , will be grateful if someone can assist