Ask the Community

We are currently using dedupe to identify duplicates in our records.Since our records is growing, we need to do it in automated way everytime there's a new record coming in.Here's the scenario:When a new property address will be added, there should be an automation that will automatically check the current records that we had, and it will tag this new property address if it's a duplicate or not.We just want to have an accurate solution if there's a new entry coming in, it will automatically mark or tag as duplicate.You can just imagine a Google Spreadsheet, if there's a duplicate it will suddenly highlight the column with duplicates.Do you think it's possible?

How to make new inventory items automatically link to the corresponding room in our building by linking or with a formula or automation.When a new item is added, how can I make that item auto populate in another tab by room (multi select)?This is the base. We have a robust inventory with “ALL ITEMS” and items by room. We want each item entered into “ALL ITEMS” to populate in the room selected via “multiselect.This shows the multiselect tab. Any assistance is greatly appreciated!

Hello there, I want to create a form in Softr, connected to my Airtable DB, where my employees will input their availabilities for “next week”, so I need to generate automatically the “next week” concept. I have created a table “weeks”, with the following columns :Week number Year To generate the concept of “is next week”, I want to create a date field “today” that updates automatically on a daily basis, and then in the field “is next week”, put a formula. However, I don’t know how to automate the update of the date at “today’s date” . Can you please help ? :) 

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:There was an error during grant authorization. Close this window and try again or contact your system administrator for details.

Hey there, I am currently building some automation scripts in conjunction with my API. For performance reasons i would like to call multiple promises in a Promise.all function. However it seems that whenever I try to make an array of promises that by calling my async function (without await) that it already executes the fetch call to my API. Which shouldn’t happen.  let promises = records.map((record) => {  let firstPromise = asyncFunctionWithFetchCall1(record);  let secondPromise = asyncFunctionWithFetchCall2(record);  return [firstPromise, secondPromise];});let results = await Promise.all(promises.flat());here firstPromise and secondPromise already execute the fetch call within the functions.Has anyone experienced this before and is there a fix for this? Thank you! 

HelloI have a table, shown in Interfaces as a list and I designed a complex Record Detail. I have duplicated the list for convenience in a different interface - thinking I could amend it in the second interface (I only need a button), but it seems the two record details are linked, I cannot edit one alone. Is there a way to un-duplicate the two record details, without having to rebuild the list and record details? 

Hello everyone,I'm running into a very frustrating issue with the Google Drive Sync feature and I'm hoping the collective experience here can help, since support is currently unresponsive.My Goal: I want to set up a one-way sync from a Google Sheets file to a new table in my Airtable base, to use that sheet as a data "dictionary".The Problem: I am on the Team plan. When I start the process from Airtable (+ Add or import -> Google Drive), I successfully authenticate my Google Workspace account. However, the next window, which should show me the files in my Drive to select from, is always completely empty.I have already performed all the troubleshooting steps I could find, but with no success.Troubleshooting Checklist (What I've Already Tried):✅ Plan Confirmed: My base is correctly on the Team plan. ✅ Ownership & Permissions: I am the Owner of both the Airtable base and the Google Sheet I want to sync. ✅ Google Sheet File Permissions: I have set the file's sharing permissions to "

I created an automation to notify an assigned person, however when an assigned person gets an email, the previous assigned person also gets CC’ed with the same notification. I am using a multiple users field.  Created a simple workflow trigger that listens for that field to be updated and sends an email. It works great when only 1 person gets assigned. However when a 2nd person gets assigned it triggers an email for the 2nd person and creates CC for all the previous people. I want to only notify each person once, not multiple times for each assigned person.

So I have a paragraph, from which I would like to extract a few sentences via formula. The reason for this is that I need to copy the sentences in the middle and insert them into other pieces of text. I need to do this a lot of times, for text in several languages I do not read, which makes it annoying to do visually.  While the number of characters will vary a lot language to language, the number of sentences is the same, so I had hoped to use periods and REGEX to isolate the sentences I need. Basically I have: > This is the first sentence. Here’s another sentence. Beginning of the part I need. I also need this. Here’s a sentence I don’t need. <!--more--> I can use Regex and LEN to get rid of the <!--more-->,  but it seems like going further than that is beyond my current skill. Any ideas?

Ive tried to set p a workflow automation to X - but Im getting errors?  

I’m trying to create a database to track income from various deals. I have several different types of deals with different commission rates and they are covered in separate tables - but often several types of deal will apply to one title (I’m a literary agent) and I’m trying to bring it all together so I know, for each title, what the author earned and what the agency earned.I’ve successfully set this up using look up fields for one set of deals but now I’ve started adding in another set and something is going wrong but I can’t see what I’m doing differently. The main information is clearly coming through because the name field (which is generated via automation when the original table is updated) but the look up fields for those records aren’t pulling through. Any thoughts why that might be? Thanks   

Hello I am trying to share an interface to new users as view-only. This shared interface should be as low-effort as possible, immediate access to the table and the detailed records, nothing else. Instead the invited user is asked to sign-up (for free), is shown an horrible and totally irrelevant App Builder process and shown he has 14-days free account. This is totally unacceptable for us: is that how it is supposed to work?  How do expert users of Airtable do this? Is it possible to embed the interface somewhere else? Or do we need to build in our website these interfaces via API? 

I have an interface with a list that has a button that needs to grab records in a linked table.I thought that the searchable area would always be the primary field of the child table. In my instance, the data from some rollup fields in that table.Does anyone know how to control what’s being used as a searchable field and what 5 columns are shown in the selector, as I’m about to go crazy, as it’s really difficult just to select something where everything is NA?

Hi there! I created an interface for my base with 3 pages. In one of the pages, I want an element of a record to link to another from a different page. See attached image, circled is the element I want to pop up automatically when I input the “account” in the original record. Right now I have to manually add it. 

Hi everyone,I’m working on a budgeting setup in Airtable and would really appreciate some community insight.We currently have a well-structured “CostComponents Employees NL” table, where we define specific account-level budgets per employee. These accounts all roll up under OPEX, and more specifically under the top-level group account “610000 – Staff Costs”. Some of these accounts belong to the group accounts:611000 – Direct Staff Costs 612000 – Other Personnel Costs 613000 – Car CostsNow here’s the situation:Certain accounts are budgeted at the employee level only and should not be editable elsewhere. Certain staff related accounts are budgeted at high-over level (not on employee level, Other OPEX accounts (not staff-related, Operational Costs) need to be budgeted at account level, under the following group accounts: Housing Costs Office Costs IT Costs Marketing and Travel Costs General Costs We are looking to build a unified “Chart of Accounts Budgeting Table”, where: All relevan

Hey,I have an extension in Airtable that creates a file for each record within a Table. Is it possible to download each file as a pdf and populate a file field in the same Airtable record? Each file generated by the extension doesn't have a unique URL (that I can find) to that records extension file making it difficult to download automatically. Please help!Thanks 

Hi Everyone, I’ve been searching the community pages and it seems that there is no way to create PDF’s automatically from templates created using Page designer, is that right? I’ve created the field type ‘Button’ to click which displays the document in the page designer app perfectly. But, I then have to manually save it as a PDF. What I’d like, is to be able to click the button and for that document to be automatically downloaded and saved as a PDF file. Surely this must be possible? It just seems crazy that the button can produce the document but can’t save the file. Am I missing something? What do people use the Page Designer app for if not to create documents which they then want to attach and send to their customers? Thanks, Rosa

Our finance department wants to start using Airtable to send out invoices to vendors. Is there a way to place a template invoice somewhere, and then have an automation modify the template pdf with chosen data from our vendors listings with their invoice? (i.e- from template to a customized pdf with their information, amount to pay etc).

I would like to generate a PDF out of a record (to easily visualize the data) and attach the record as an attachment. I would like to do this for all the records in my base. Any ideas on how to do this using either a script or Zapier/Integromat, possible using Formstack (does not have to use formstack though)? Would love any insight - I am capable of coding in JavaScript and can leverage that if necessary.

Hi there - I have a list of outputs and am trying to create a PDF listing those. Is it possible to create a PDF via script? Or what other methods are there other than one line per PDF? How could you use the PDFs if linking all records to one record in another table?

Hi AllI am new to Airtable…..I have set up a base with all my customer records and imported sales data to populate all my fields.Now that I have new sales data, I cannot import the data to over-write existing data. All I seem to do every which way I try is create duplicate account information with new sales figures.This is really frustrating. I have tried using data from excel, CSV file as well as Google Sheets with the same result.What am I doing wrong???? Any help will be appreciated.

I'm running into an issue with how our team interacts with our employee database through interfaces.We have staff who need to edit certain fields in the record detail view, but we're constantly running the risk of someone accidentally overwriting key info with a wrong input. Making the detail record view view only isn't an option, because they still need to be able to update certain data when necessary.What we really need is some kind of toggle in the detail record view that lets you switch between "view" and "edit" mode—so by default it's safe to browse, but editing can be turned on when needed.Is there anything like this available? Or any workarounds you've used to prevent accidental edits while still allowing flexibility? Thanks! 

When adding a sync table to our base, we have an option to either “delete the records” or “leave the records” in the destination table when the records are deleted from the source table. See screenshot below for a screenshot of this option. I find this Sync Setting problematic for 3 reasons: It’s not truly a “sync” if the records are mismatched between 2 tables. We have absolutely no way to distinguish (in our destination table) whether or not a record was deleted in the source table. Airtable gives us absolutely no way to tell if a record still exists, or if it’s just a “phantom ghost record” that once existed a long time ago. This is yet another security hole in Airtable. If I delete a record from a base, it’s probably because I don’t want anyone to see that record anymore. Yet anybody who has formerly setup a sync to my table can now see previously-deleted records. From a security standpoint, this is greatly flabbergasting to me. Can someone please help explain the above 3 c

Is there a way to enable AI Assistant in a shared base view (from the shared link option)? I understand how to use AI Assistant currently as a user with access, but I share a raw database periodically with stakeholders without user access and it would be helpful if they could hit the database with their own queries.  

Hi!  I might just be silly, but is there not a way to copy and paste a status across several records in list view? In grid view it’s easy, just copy a cell and paste. Is there not an easy and quick way to do this in list view?