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,493 Topics
121,931 Replies
100,911 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

3222 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

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

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!

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

dZYhNew Participant

Development & APIs

code_challenge in OAuth authorization request response

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!

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

movementservicesNew Participant

Interface Designer

Interface detail page action button: Add Form?

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 sense? A

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

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

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!

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

Farrukh SheikhNew Participant

Other Questions

How to change the default email program

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

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?

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