Ask the Community

I have a very simple automation that runs every 15 mins. It finds rows from a table that have data in a specific column and then uses a repeating group to send a slack message to each of the channels listed in those rows it found. This typically works 90% of the time but usually a handful of times a day it errors out for Slack API rate limited. Sometimes it errors out with 4 groups that it found but will also error out with 1 group. Experiencing similar issues related to the repeating groups for slack messages.  Any help is appreciated.  

Hi there, I am looking at creating a line graph in the interface. Is there a way to show multiple teams as the lines?  What I am hoping for is X axis to have the months and the Y axis to have the number and each month to populate the number is this possible?  Thank you 

New to AirtableJust cannot get this to workThe first 3 records….all the same - adds up to 22.In what I hoped would be a summary table - one record the same as those 3 using the MTOX fieldbut this is all I get 

Hi everyone! Our library uses an Airtable base for approving programs, some of which are one-time and others are repeating. We’re running into a problem where we’re sometimes overbooking on a single day (this is across multiple branches, so we have the room, but we try not to host too many programs on one day) and we’d really like to see all our programs on a calendar view. The problem is with the recurring programs. Right now, the base is set up with a text field where programmers put in their dates (e.g. “every third Wednesday from 11-12”) but obviously Airtable can’t read that. We could set up individual date fields for each occurrence, but some of these programs are staples, held dozens of times a year and would necessitate dozens of date fields. As a work around, I tried making a separate “Calendar” table with the dates as primary fields, and then in the main table, the date field became a linked record field. In Calendar, I created a calendar view and that technically works, but

HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import it and have the Link to the customer tableThanks in advance for any helpMike

Hi AllI have a Base A with Table 1 and Table 2. One of the fields in Table 1 is a linked record field to Table 2.I also have Base B with Table 1 synced to this base.Rather than showing a linked record from Table 2 in the field in Base B Table 1, a text field with the entry in the primary field for Table 2 appears - is this expected behaviour? If so, how should the setup be structured to show the linked record? If I have a Table 3 in Base B that has a linked record field to Base B Table 1 and I want it to have a lookup field to the linked record field already in Base B Table 1, is that achievable?Thank you.

Hi, I am new here. I have some columns like name, email, job title. I have 3000 rows of these data. I want to send personalized emails to all of these 3k users with their name and job title. How can i do it? Is there any automation or extension available which can help me with sending these email automatically?Thanks for help.

Hey guys ! i have an interface for my customer with a form and other data. He wants the form to be prefilled with the same message “long text field” in the interface. See the screenshot. it it possible to do that? and how? Thank you

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