Ask the Community

Hey everyone Maybe I dreamed this, but I thought I could copy\transfer the layout of one existing Record Detail to another Record Detail. I know I can duplicate an existing Record Detail layout to a new Record Detail layout. That creates a new layout which I want to avoid since I would have to reference the new layout to replace a depreciated layout. And I have a lot of those that I need to clean up. Updating an existing Record Layout by using a different record layout is pretty useful. Is that possible? Was it ever possible? Thanks everyone!

Hi, I'm approaching launch for my first Airtable application, a support/ERP/CRM system for my wife's business (two users currently planned). Is there an agreed upon best practise how to launch a production version but yet be able to continue developing the application? I have little real experience in application management, although I have managed some LAMP applications with SQL updates and diffing PHP. I thought I would keep the current base as PROD, make a back-up of it and assign that a DEV role and continue developing new stuff there. But how to migrate changes from DEV to PROD? Rgds, Björn

I'm finally making great progress and haven't been frustrated enough to quit yet, so I think I'm going to be able to make this (along with fillout) to help support my makerspace. I hope to eventually move from the free plan to Teams once I know I have all the major pieces in place. But once I do, and we're using it, I'm concerned that my future clugey attempts to add functionality might break operations. Is there any concept of development, QA and production versions of a workspace?

I'm building a base to track volunteer sign-ups for a project. Table 1 stores Volunteer info Table 2 contains available Timeslots When a new volunteer signs up via a form on the Volunteer table, an automated email is sent confirming the timeslots they’re registered for. The issue: When I include a grid of timeslots (using a Find Records step in the automation), all of the times are showing in UTC. I need them to display in EST. Here’s what I’ve tried: I created a formula field to convert the time to EST using SET_TIMEZONE, and also tried A single-line text field that gets updated by a separate automation But when I try to include either of those fields in the grid, the grid shows the correct number of records, but all the cells are blank. Has anyone figured out a way to include times in the correct time zone (EST) inside a grid in an Airtable automation email? Would appreciate any tips!

I have two tables, Table 1 and Table 2, with different fields. When a specific record is populated in Table 2, I want the values of some of its fields to automatically appear in a corresponding record in Table 1where the cells were initially empty, based on the primary fields of both tables, I’m calculating a total in Table 1 based on entries into records in several tables and need to have the total in Table1 automatically updated whenever the values change in the other tables. What is the best way to achieve this? IOW, what is the equivalent of XLOOKUP or Index Match in Airtable?

Hey AT community. I have downloaded Sales CRM template. This link shows that training is available, but I don’t know how to access training. Your help will be greatly appreciated. Thanks https://academy.airtable.com/quick-start-the-sales-crm-airtable-template

Hi, Clicking on the email address opens Microsoft Outlook Live. How can I change the default settings to open Microsoft® Outlook for Mac?

Bonjour, j'ai crée une table mais le champ type "Nombre" est absent de la liste des champs disponibles.. Avez-vous une explication?

I’m running into an issue while trying to set up an Airtable automation that links records across two synced tables, but I’m getting the following error Invalid filter on field A (Invalid filter value: [ { "linkedRecordId": "rec0hJCM2U7BBdWWa", "value": { "id": "recvaxWZ99uQ8cYia", "name": "12345678" } } ]) I'm trying to locate a field value in Table 1 with Table 2 using Find Records, and then link the records via the Automation. Setup Trigger (Table 2) > Find Record (Table 1) > Update Record (Table 2) I have done almost the same type of Automation in another base (which is working fine) and the only difference is I am now working with 2 synced tables in Find Records - in the previous one i created it was comparing synced with source/original table I've tried adjusting field setups (in source as well) for both tables: Sync linked, string fields, lookups, used Trim functionI continue to get filter errorsI can only assume it's because Airtable doesn't like that both tables are synced? Am

Hello Airtable community, not sure it is possible, but Gemini says it is)) but when Gemini gives me the sample script and I adjust it and try to use it, it does not work. Here is what I am trying to do. I have a record (contacts database) where I have a multiple select “Status” for this record. And I have another multiple select “Services” with let’s say “Option A”, “Option B”, “Option C” and “Option D”. When I choose the option “Available” in this multiple select “Status”, I want to the script or automation to limit the options shown in the field “Services”. For example when “Status” is choosen for “Available”, my field “Services” will only display “Option B” and Option D” as an available options to choose from. Anyone thinks you can help me with some advise?

Does anyone have a current script that is parsing any emails beiing received in the new “trigger when email received”. I am trying to parse the body, but I cannot figure out the inputs from the email received. I get errors on all of the inputs. My reason for the inputs, is that the receivedDate didn’t work. // Get inputs from the automationlet inputConfig = input.config();let subject = inputConfig.subject;let body = inputConfig.body;let receivedDateRaw = inputConfig.receivedDate; // Optional: log inputs (for testing)console.log("Raw receivedDate:", receivedDateRaw);console.log("Subject:", subject);console.log("Body:", body); // Parse date string into Date objectlet receivedDate = new Date(receivedDateRaw); // ✅ Function to get the next Tuesdayfunction getNextTuesday(date) { let day = date.getDay(); // Sunday = 0, Monday = 1, ..., Saturday = 6 let daysUntilTuesday = (9 - day) % 7; if (daysUntilTuesday === 0) daysUntilTuesday = 7; let nextTuesday = new Date(date); nextTuesday.setDate(dat

I am trying to convert an existing solution to airtable, and see some great enhanced functionality. however, there are relationships in my existing system that I am not sure how to appropriately recreate in airtable. For instance, i have a join table that shows several different related tables through a relationship. some of the relationships are many-to-many, and would be created in the main join table. What’s the best way to recreate that in AirTable? Thanks in advance… jesse

I have two linked tables on a field called “customer”. This works great for issue tracking, because I can add a customer to a specific issue and know who needs to be followed up about it, or quickly get their current status. I’d like to group by the Customer field. However when I set this grouping up, it treats the following as separate groupings: A B B, A B, A, C and so on. Is there a way to view the grouped view so all of Customer A’s associated issues will show up under Customer A, rather than 1 under A, 1 under B, A and 1 under B, A, C?

Hi all, Guessing this is a popular question, yet when I am searching the existing questions I've not yet found the solution. There's gotta be an easy fix.... right??? We've a base listing our clients. Each client might have between 1-3 staff assigned to support that client. For example: Steve, Jill, Carl supporting Client A Steve supporting Client B Jill supporting Client C Carl supporting Client D If I group the sheet by 'Assigned Staff' I get a list that looks Similar to above, but I am trying to produce a sheet that looks more like: Steve Supporting Client A + B Jill Supporting Client A + C Carl Supporting Client A + D Whats the easiest way to achieve this? Would LOVE it if there is a known video out there that can walk me through the steps. ❤️

Hello, I'm trying to use airtable to email callers templated information about products. I have a grid view where I can enter an caller's email, select from product list (a, b, c), then use the Button feature to trigger a SendGrid email that contains information about the selected product that is retrieved from a lookup table (a - info text, b-info text, and so on). This all works very smoothly except I would like to create a Form to enable staff to use this process without having to interact with the grid view. So I would like to somehow automate the pressing of the "Send email with SendGrid" button once the Form is submitted/record created. Is there a way to do this? Thanks for any ideas you have.

I see I can set up an automated email response like “thanks for filling out the form” but ca I set it up to include their responses so they have a copy of what their answers were?

Hi, I have a request to set up a “tag” so that users can @mention everyone in a dept. in one new comment. I tried doing this with groups. I created a group made up of 4 users who are all Editors in the base, and gave the group the name “TechGroup”. I would like to add a comment on a record and ‘@TechGroup’ so each member is notified. So, far this doesn’t seem to work. Is there another way to tag multiple people in one mention? Thanks!

Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed? We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed? I have see some notes on it, but we need scripting help to achieve it. Thanks for any advice. Kevin

I’m getting the following error when I get or create the data from airtable in my next.js project. AirtableError { error: 'NOT_AUTHORIZED', message: 'You are not authorized to perform this operation', statusCode: 403} I’m using airtable npm module for integration. I’ve added all required scopes already but not sure why I am getting that error.Can anyone help me for that? Thanks

The Airtable OAuth specification says that authorization request responses will return the same code_challenge that was included in the original request. These docs also say that this value must be verified: The code_challenge parameter you passed in the authorization request. You must verify the code_challenge variable is associated with a code_verifier you generated. From what I understand of the PKCE flow, Airtable's backend (not the client integration) is responsible for validating the code_verifier included in the token creation request from the client. Why does the documentation call for the integration to check that authorization response returns the same code_challenge that included in the request? Also, the official Airtable example implementation does not perform this check: https://github.com/Airtable/oauth-example/blob/a714e68c2610e3249063b3d92faf064bf4c15188/index.js#L94-L137. Any ideas? TYIA!

Hi Everyone I’m sure that this has been done before but I can’t seem to get anything I try to work Im looking to create a forula filoed that looks up and displays the PAYE Month a date in another field falls into for example 17/04/2024 would lookup and display PAYE Month 1 02/10/2024 would display PAYE month 6 20/08/2025 would display PAYE Month 5 I am dealing with the tax year in another field so I dont want to worry about the year below is the parameters I have tried if statements I have tried a switch example but cant get anything to work I have tried setting a year start date and using dateAdd to add on the number days after the year start but I just not getting anything to work right If someone could point me in the right direction I would be really gratefull Cheers Jackie From Date To Date Days Between No. Days from start of tax year Should Display 6th april 5th May 29 29 PAYE MONTH 1 6th may 5th June 30 59 PAYE MONTH 2 6th june 5th July 29 88 PAYE MONTH 3 6th july 5th August 30

Not sure what to title this. In a record detail interface page, there is the option to add a button and perform an action. (Yes, love it!) But it doesn’t seem like the option exists here to add a new record in a different base via a form—the dropdown on the right doesn’t seem to allow it. And unfortunately, “Interface Forms” for some reason still don’t count as “Interface Pages”, so I can’t click on “Go to interface page” and click on my form. The best current option seems to be “Go to external URL”, and put in the URL of the form. But that seems to only open my desired form inconsistently: open external URL in same tab = overwriting my current page, and there’s no way to complete that form, then hit a “back” button to get back to my record detail open external form URL in new tab = often it just doesn’t open. My ideal would be to click on the button, open another modal with the form, which I could complete, then close, and still have the record detail at-the-ready. Does that make sens

I need to create a test/quiz for my employees in order for them to be certified in a subject area. I'd like to create a form with 30 questions, each question with up to 4 multiple choice answers. I have an answer key, indicating which of the answers is correct Is there a way for the employee to complete the form and submit and AT automatically compares the answers to the answer key and provides the number answers correct and the percentage of answers correct out of 100.

Hi know that creating a recipe with several ingredients and do the calculations So I was thinking to do the recipe vertically Is that working for me ? Please advise Regards

Hi! Does anyone have any recommendations on how to continuously import contacts from Mailchimp into Airtable without using a third party (i.e. Zapier)?