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,927 Replies
100,900 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

4999 topics

Base Design

3221 topics

Formulas

5848 topics

Development & APIs

Development & APIs

3599 topics

Interface Designer

Interface Designer

1265 topics

Other Questions

Other Questions

14340 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

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

shelley_floNew Participant

Create a multiple choice quiz that self scores

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

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?

Chef TarikNew Participant

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

Farrukh SheikhNew Participant

Other Questions

How to access training

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

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?

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?

Lydia_GutermanNew Participant

Other Questions

Mailchimp / Airtable integration

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

Jon_Wilson1New Participant

Other Questions

Enterprise: Can SSO be used to control access to a form, on an individual basis?

I’m currently a Pro user and I’m considering an upgrade to Enterprise. I’d like to know if the following workflow is possible with Enterprise. A billable collaborator creates a form for a Base in their Enterprise Workspace. The billable collaborator shares the form with a non-billable collaborator from their domain. The non-billable collaborator accesses the form, authenticating with SSO prior to seeing the actual form fields. The non-billable collaborator submits the filled form, and their user ID is passively submitted along with the other form values. (I suppose this ID would be the email address they used to authenticate with SSO.) A billable collaborator can see the new record (with the ID of the user who submitted it) in a grid view. Reasoning: I’d like many individuals from my organization to participate in data collection and entry but want to restrict administrative access to a small team. The number of potential participants is around 300, and I’d prefer not to have to p

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

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?

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

jjones09New Participant

Display the root of a linked record field

Hi! I created a base and interface for a game I have been playing, Schedule 1. Yes, it is a game where you create drugs based on different combinations and then sell those drugs :P. I have included a public view of it below. I have it basically how I want it, but I need a way, anyway, toFrom the drugs table, have a view that pulls the Teir 1 drug from any drug that isn’t a T1 drug. And then display in each row, the T1 drug, the different mixed supplies, and the drug effects.The challange is, in the game, when you make the drugs, they randomize the names after mixing. So, what for me, mixing ‘Aspen Grool’ which is a T3 drug, might be called something different for another user. It would be rather daughting to dig through each drug combo and source it back to the T1 drug, so I was hoping there was a way to do it in a formula or view or something. Thoughts? https://airtable.com/appXdxs1ShjFgTxFE/shrbWwxkofvHeaHNr

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

PeteFordNew Participant

How do I compare dates to return the lowest?

Can anyone tell me how I would write a formula that will return the lowest date from a series of dates? this would be very simple in excel, but it seems impossible

BenNew Participant

I can't seem to find a general statement when choosing data for an email automation for multiple people for the 'To' section

Hello, I am currently trying to send an Airtable automation where it bulk emails people from a table. However, I am in the ‘To’ section to send an email, but I can’t find an option under ‘Current item from List of records’ that has just a general statement of ‘Applicant Email’. Currently, it’s showing a specific Applicant Email, but I want to send more than this person. This is also happening for the message when I am trying to include their names. I’ve attached one of the screenshots as a reference. Can someone help me resolve this issue please?

jonathanshanksNew Participant

Interface Designer

How to add a table to an interface

Hi everyone!I have created an interface to keep me organized, and one thing I would like to add is a table that would function like the data side, just within the Interface. For my specific example, I have various groups I invite to events, and it would be helpful to have a table with the group name, group contact, and then a checkbox for when I’ve contacted them. My interface is a “Record Review” interface.Does anyone know how I can achieve this? Any help is appreciated!

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