Skip to main content

User Groups
Product Ideas
Events
Academy
Help Center

Welcome to the Airtable Community!

Ask questions, get answers and engage with your peers

39,496 Topics
121,942 Replies
100,912 Members

Get Started

New here? This is a great place to start

Ask the Community

Get support directly from your peers

Builders Board

Celebrate your Airtable wins

User Groups

Forge connections with other Airtable users

Events

Explore and RSVP for upcoming events

Announcements

Read the latest news the Airtable team

Check out the Enterprise Network ✨

Check out the Airtable Enterprise Network (or 'AEN'), the exclusive hub for Airtable Enterprise customers. Access private events, connect with peers, and ask your top of mind questions here.

ENTER HERE

Airtable Enterprise Network

What's New in the Community

The Community Digest

Categories
Recent Activity
Help Others

Welcome

Welcome to the Airtable Community! Check out our resources on this page to help you get started. Lets learn and grow together!

Getting Started on Community

Getting Started on Community

12 topics

Onboarding Resources

Onboarding Resources

12 topics

Announcements

258 topics

Ask the Community

Ask the Community

Automations

5001 topics

Base Design

3223 topics

Formulas

5848 topics

Development & APIs

Development & APIs

3599 topics

Interface Designer

Interface Designer

1265 topics

Other Questions

Other Questions

14339 topics

Builders Board

Builders Board

Show and Tell

994 topics

Product Discussions

Product Discussions

2 topics

Jobs Board

997 topics

Legacy Product Ideas

Looking for a post that was once on our legacy Product Ideas page? They're all viewable here. Note that all future product feedback must go through the new Product Ideas submission form here: https://community.airtable.com/p/product-ideas

Legacy Product Ideas

Legacy Product Ideas

2697 topics

bedjikKnown Participant

Need Help with the script or automation (Multiple Select Field)

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?

Jason_HillInspiring

Email Received Scipt Parse

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.s

jrobgk1New Participant

converting from filemaker

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

BKRNew Participant

Other Questions

problème sur le type de champ "Nombre"

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

Alex_RosenNew Participant

Other Questions

Grouping by linked fields when there are multiple linked records

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?

GrahamWKnown Participant

Grouping by a linked field with multiple records.... creates problems.

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 ASteve supporting Client BJill supporting Client CCarl supporting Client DIf 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 + BJill Supporting Client A + CCarl Supporting Client A + DWhats the easiest way to achieve this? Would LOVE it if there is a known video out there that can walk me through the steps. ❤️   

dipladocNew Participant

Send Email When Form Submitted

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.

Tina_TeutschNew Participant

How to automate form confirmation email that includes their submission answers

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?

AasiaParticipating Frequently

confirmation email for successfully submitting the form.

@AasiaWhen a form is submitted from he/she.  I want that Airtable to send a confirmation email for successfully submitting the form. 

Sharon_VisserInspiring

Is there a way to @mention multiple users in a Comment?

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!

bedjikKnown Participant

Need Help with the script or automation (Multiple Select Field)

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?

Jason_HillInspiring

Email Received Scipt Parse

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.s

jrobgk1New Participant

converting from filemaker

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

BKRNew Participant

Other Questions

problème sur le type de champ "Nombre"

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

Sharon_VisserInspiring

Is there a way to @mention multiple users in a Comment?

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!

Does Airtable have an "AI Agent/Teamates" function like Zapier and others?

It does not appear that Airtable has AI Agents that can perform ongoing, automated functions w lots of tasks including web searching for related info? This sems like a huge miss unless I am missing something?

K_B1Known Participant

Scripting: Convert Attached .TXT file to Long Text

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

MagPageNew Participant

Prefill a field and lock the content

AT community, Yes I have searched and used AI and I’m not getting a good answer on this question. I have a pre-filled form to advertisers. I want some of the prefilled fields to be locked so that the content cannot be change. Has anyone found a workaround for this and be willing to share step by step on how to do it. I’m very new to AT and want to learn!Thank you!

marccanlasNew Participant

Development & APIs

Fetching Not-Authorized Error in Airtable Integration

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

Jackie88New Participant

Display UK PAYE Month based on a date

Hi EveryoneI’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 102/10/2024 would display PAYE month 620/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 gratefullCheersJackieFrom 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

Welcome to Airtable Community!

Make sure to register or log in

Please read our community guidelines

Join one of our user groups (+ events!)

Help others in the Ask a Question area

Community Events

Leaderboard

Airtable Academy is free for all Airtable users and plans.

Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.

Sign up for Airtable Academy Get Airtable Certified 🏆

Powered by Gainsight

Terms & Conditions

Platform Platform Overview Integrations Extensions App Building AI Connected Data

Solutions Product Marketing Operations Human Resources Sales Finance

Learn Airtable Academy Events Video Center Demos Customer Stories Webinars

Resources Partners Services Developers Community Templates Airtable Universe

Company About Careers Blog Status Newsroom Try Airtable For Free

Security API Sitemap Privacy Terms Do Not Sell/Share My Info Cookie Preferences

Sign up

Already have an account? Login

Login with SSO

Log in with Airtable SSO

or

Username *

E-mail address *

Password *

I accept the terms of service

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

Log in with Airtable SSO

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK