Ask the Community

Given the new integrated Gmail, I’d love to see the ability for Airtable to have a similar integration with Google Chat as Slack where a bot can be added to a Char room and send messages based on Automations.

Hello,Beginner here working on a MVP. Is it possible to create an interface with 6-8 photo carousels each with a drop down of filters? Or is that something beyond a beginner? Thanks!

Hello,we run an agency and for every client we have a different base. The base is almost identical for every client. We now have access to the business plan, and we want to use a master base to consolidate the data from every client into one base, so that we can benchmark our performance as a whole, and dive deeper into every client if we wish. We have a table called KPIs in every client base. The KPIs are always the same. For that reason I have created the same base in our master base, and I am now syncing data from master into each client base. We also have a projects table for every client, which includes 3 fields (primary metric, secondary metric, tertiary metric). These field are linked records from the KPI table. In the KPI table (for each client) we can then see how many times a KPI has been used for that client, and the overall uplift for a KPI with a client. I want the same information to be shown in the KPI table in our master base, but then for all clients. I thought about c

I'd like to: Identify fields with duplicate values Keep only the most recently created record, deleting all other duplicate older records Run the process and be done However, I also want this to apply automatically to newly created records. That is, whenever a new record is added with a duplicate value in a specified field, the new record should be kept, and the older one deleted.The field with duplicate values that I want to identify is called Deviceid, and I have createdtime field.The solution in the linked thread only handles existing records—it doesn’t account for new ones added later. Is there a way to automate this behavior in Airtable scripts?script i made that doesnt work:let table = base.getTable("tablename"); // Get the triggering record's Deviceidlet inputConfig = input.config();let newDeviceId = inputConfig.Deviceid; if (!newDeviceId) {    throw new Error("No Deviceid found in input config.");} // Fetch all records with same Deviceidlet query = await table.selectRecords

Is there anyone who can help with a script for this, if even possible? Would looove to see this implemented as a feature, as we’re using A LOT of views. Thank you!

How can I search globally in all tables ? No the existing search app doesnt work. See the image below. it only search in the records in current base not globally. Please guide me whats the possible solution to this. Screen Shot 2020-09-17 at 10.53.07 AM

When I go to upgrade to the new Teams plan, it says I have 14 billable users (and tries to charge me for such), but 9 of our users are only commenters.The Pricing page FAQ says, "No charges will apply for read-only collaborators, commenters, or people submitting forms."When I click "14 Billable Users" (on the upgrade page), it says, "…users with viewer and commenter permissions will get free viewer seats."And yet:It says here, "You can see every billable collaborator… This includes… any base collaborator with owner, creator, editor, or commenter permissions."And here: "On self-serve paid workspace plans, any collaborator with a permission level of Commenter, Editor, Creator, or Owner is classified as billable.I know Airtable is in middle of a price structure switch; not sure if this conflict of info is due to that.

Hello!  TIA for any help!  I'm creating a base for Donor Management and have run into a challenge.  I'm building an interface for Fundraising Campaign tracking.  The main Interface is a Record View layout.  Potential donors are loaded into a table and then viewed via this Interface.  When you click on a potential donor, it loads their contact information and the tracking data below it, as you can see in this screenshot.  *I've removed the sensitive data! Because the potential donors are linked into the campaigns, all their contact information is not editable in this Interface.  I'm generally okay with that, but I'd like to include a button that would let users open a donor's page for editing, possibly using the Contacts Interface you can see in the menu bar at the top.  Is there a way to create a link that would somehow take the ID of a linked record from the current Interface and pass it to the Contacts Interface on loading?Thanks agai

Hello, I have a table where one column is a relationship to itself. So I can links records to each other.I’d like to have another column where I show the linked records. Sort of like a Lookup what records are linking to a specific record.I found this 3 year old thread, but it has no solution offered here: Is this something I could do today?

When indenting a numbered list in the Airtable rich text field, the Level 1 numbering is working properly. However, the level 2 is not unique to level 1 and continues on the sequence from the previous level 1 line. Ideally, I could have a list organized like below:step one… Note regarding step one… step two Note regarding step two… Any idea on a quick fix for this? 

My company publishes books and the titles of the books often change throughout the course of the publication process. We currently ingest records via a CSV download from our title management platform that is manually uploaded to Airtable. We already have an automation that deletes or rolls up duplicate titles. Currently, when a book title changes, it is viewed by Airtable as a new record. Is there a way to have Airtable check the upload and see that the ISBN is the same and update the record title rather than create a new record? Example: Title ISBN ORIGINAL TITLE 123 NEW TITLE 123  Instead of creating a new record for “NEW TITLE”, I would like Airtable to see that the ISBN is the same and update “ORIGINAL TITLE” with “NEW TITLE”.  Thanks!

Hello, Been very busy and I suspect I’m going blind with what’s probably (hopefully) a simple data flow. As a picture says a thousand words, my problem is as per below; I can self link a record to its own table with a lookup field, which in this example I consider that as “Pushes to” - So A pushes to B. But what I’m needing, is another column that tells me the reverse of that relationship, so I can see that “B” is pulling from A - and then even create a filtered view around that very “Pulls From” data. I’m keen for your thoughts on this, hoping there’s something simple that I’ve missed that will allow this workflow. But I also have access to scripts/automations too if they’re the only way out of this.

Anyone know how to stop autofill on forms? 

I have two separate AirTable bases that I’m using to track our orders and inventory. I just upgraded from a free account because I wanted to be able to sync information from the two bases to be able to compare orders to inventory side by side. I’ve created a new base and synced tables from each existing base but cannot figure out how to get data from one table into either the other table or a new table. I’ve tried lookup fields and linking to new record fields and can’t get a new field to populate with information from the other table. Is this not possible or hopefully I’m just missing a simple solution?

Hello, I am trying to get a field named “Statsig Url” in a table named Experiments (this is a field with the url type). (My intent is to get the record id based on the value of the Statsig Url field). A filter will be applied in the url. let table = base.getTable("Experiments");console.table( await table.selectRecordsAsync( {"fields" : ["Experiment Name", "StatSig Link"]}));console.table( await table.selectRecordsAsync( {"fields" : table.fields}));I have tried with different approaches (testing other fields...). Each time I only get the primary key. 

Dear All,how to set my personal access token account in n8n? make my workflow in n8n can use airtable as a memory for write new also update. Many thanks!Mad 

The client has access permission, so that he can enter and edit data, but he constantly accidentally adds values ​​to the field settings, every time he types a value that does not exist in the list that is set for selection, it automatically adds a new value.Something I do not want to happen

I am collecting grades for students, a few of the grade types have subcategories that need to be averaged (some of the nomenclature is strange as it’s being translated from another language). I need to calculate a “Values” score by averaging the “Honesty”, “Empathy”, “Lucidity”, Performance”, “Respect” scores. I’m trying to keep the table design very simple as we will need to eventually translate and teach non-English speakers how to use it.  Is there a way to calculate averages only for select rows, by student? (I would like to calculate a Values score and a Property Respect score by averaging the relevant subcomponents). I understand I can see it with a View, but I want to be able to calculate the actual number to put in a clean interface view. And if I need to collect this data monthly, are the columns I have for Month/Year the best way to do that, and we would just continue adding rows?   

Is there still no way to create reusable code in Automations?I see this thread from 2021, with 6k+ views, which seems to have no resolution (blockchaining is possible in Scripting Apps, but not Automations).  Someone must have solutions for this?  Copying/pasting seems prehistoric.

Cannot get this Switch to work and its very simple.  I have a field that has the year of the record stored as a number (ie 2025).  I can easily get this to work with these arguments as a singular IF, but I dont want to nest 5 Ifs. The below will not function, doesnt even give an error, wont even let me save it. Neither Claude nor chatgpt has any suggestions that make sense.  What am I missing?? SWITCH(INVOICE_YEAR, YEAR(TODAY()), "Current Year", YEAR(TODAY())-1, "Previous Year, YEAR(TODAY())-2, "Two Years Prior", YEAR(TODAY())-3, "Three Years Prior", "Older")For this record this works fine:  SWITCH(INVOICE_YEAR, 2025, "Current Year", 2024, "Previous Year", 2023, "Two Years Prior", 2022, "Three Years Prior", "Older") 

Hello! I am trying to set up a work request form, and am stuck on one part. I’m not sure whether I need to use formulas or automations, but I’ve scoured help videos and articles to no avail trying to find what I’m looking for. I would like to have a numerical Work Order ID (basically a consecutive numerical number) added to a record field as soon as the record is created. Ideally, I’d love for it to take this form (Year-####), as that’s the current system we use, but I’d settle for just a unique numerical number for each new record created. I’m sure this is simpler than I’m making it out to be, but any help would be appreciated. Thank you!

I've created a script that is attached to a view's button.In this script, I'm calling an API with remoteFetchAsync().  I need to supply basic authentication credentials, but btoa() and Buffer don't work in my script: const authorization = btoa(`${ credentials.username }:${ credentials.password }`)const authorization = Buffer.from(`${ credentials.username }:${ credentials.password }`).toString('base64')output.text(`authorization: ${authorization}`)Is there another option?Is TypeScript supported in a script that is triggered by a button?  If so, how do I enable it?FYI, the "Ask the community" link (https://community.airtable.com/c/developers/scripting) returns 404.

I’m trying to integrate SAP Business One (SAP B1) Service Layer API with Airtable scripting to fetch business partner data. The integration works perfectly in Postman and Python, but when I run the same API request inside an Airtable scripting block, I get the following error:401 - Invalid session or session already timeout. What I’ve Tried: Confirmed that it works in Postman and Python I can successfully authenticate and fetch data from SAP B1. Session ID is returned properly, and I manually add the ROUTEID. Using remoteFetchAsync() in Airtable Scripting I correctly pass Content-Type and Cookie headers. Even when I manually copy a working session ID from Postman, I still get a 401 Unauthorized error Has anyone successfully integrated SAP B1 with Airtable scripting? Could Airtable be modifying the request headers in a way that causes SAP B1 to reject it? Is there any alternative way to bypass CORS while using Airtable scripting? Any other troubleshooting step

Hello All! Thanks in advance for any help but I am stumped. I am trying to automate updating a multi-select field from a Linked Record Field, and after looking for help here I found this thread: I followed the guidelines here but I am running into an issue with a completely different field. When I test, I get this: I am not sure why it is trying to do anything with the photo field :(Long story short, I want when someone is added to this department on one table, for their profile to be updated as well, with the matching department name on the multi-select field. Here is the way I set the automation:TriggerAction 

Can anyone point out what i’m doing wrong here? The goal is to create a list from 30 different fields. Each field should be on a new line We want to skip any fields that are empty. E.g don’t add a newline for empty fields. The latest version of my nested IF formula looks like this. Any help greatly appreciated! IF ({filename_1}!=BLANK(),filename_1 & “\n”,IF ({filename_2}!=BLANK(),filename_2 & “\n”,IF ({filename_3}!=BLANK(),filename_3 & “\n”,IF ({filename_4}!=BLANK(),filename_4 & “\n”,IF ({filename_5}!=BLANK(),filename_5 & “\n”,IF ({filename_6}!=BLANK(),filename_6 & “\n”,IF ({filename_7}!=BLANK(),filename_7 & “\n”,IF ({filename_8}!=BLANK(),filename_8 & “\n”,IF ({filename_9}!=BLANK(),filename_9 & “\n”,IF ({filename_10}!=BLANK(),filename_10 & “\n”,IF ({filename_11}!=BLANK(),filename_11 & “\n”,IF ({filename_12}!=BLANK(),filename_12 & “\n”,IF ({filename_13}!=BLANK(),filename_13 & “\n”,IF ({filename_14}!=BLANK(),filename_14 & “\n”,IF ({