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,533 Topics
122,101 Replies
100,997 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

5013 topics

Base Design

3226 topics

Formulas

5853 topics

Development & APIs

Development & APIs

3603 topics

Interface Designer

Interface Designer

1272 topics

Other Questions

Other Questions

14342 topics

Builders Board

Builders Board

Show and Tell

995 topics

Product Discussions

Product Discussions

2 topics

Jobs Board

1000 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

Emma-RFPNew Participant

Date counting formula weird results

Hi all, I am copying over historical data into a new Airtable system and I am using the following formula for calculating the number of days taken to complete a task IF( OR({Date Completed}, {Date Completed Override}), WORKDAY_DIFF( IF({Start Date Actual Override}, {Start Date Actual Override}, {Start Date Actual}), IF({Date Completed Override}, {Date Completed Override}, {Date Completed}) ), BLANK())It works just as intended, it counts the number of workdays to complete a task, using the default field unless an override date is being used.However, there are one or two results that are just way off. As an example, one record has the following values:Start Date Actual: blankStart Date Actual Override: 1/3/2025Date Completed: blankDate Completed Override: 23/4/2025Completed Task Duration: 474831What is baffling me is that there is another record with exactly the same dates that is correctly returning a value of 15.The default fields are auto generated via a formula, and the ove

NialloNew Participant

Syncing amendments to Google Calendar events

Hi all,Have been scouring the web, AirTable support and various AI platforms to get an answer to this, but no joy so far. I am trying to set up automation to sync changes between Google Calendar and Airtable, including updates and deletions. AirTable support instructed me to set up triggers for new events, updated events and cancelled events. I am doing this on an empty table at the moment just to test it out. However, I am hitting a bit of a brick wall with the Updated Events automation. I believe I have the Find records action set up OK, see screenshot below (although when I test the step at that stage, it says Found 0 Records but I guess this is because the table is empty currently...)My screenshot: Find records menu Where I’m really getting lost is with the Update record part. According to AirTable Support, “the ID of the action that gets the information to be used goes in Record ID, and should look like the below. “This is because this Integrated Trigger is not directly related to

yonatan halperinNew Participant

Other Questions

sharing an interface

i want to share 2 interfaces with one person, as a commenter, will i pay for him twice?

ek0583232948New Participant

In the "Date and Time" field, when I perform automations on it, it treats it as if it were GMT/UTC even though I defined my own time zone.

Hello.My time zone is Israel.I defined the time zone of Israel in the Date and Time field. But when I run formulas or automation on it, it refers to the registered time, as if it were GMT/UTC and this disrupts all my automations.Is there a solution for this?

Mary_WilliamsParticipating Frequently

How to use combined formulas for a label printing program -- Concatenate + if/then + probably something else?

Hello hive mind geniuses! Bear with me, I’m not sure how to explain all this, so I’ll start with my use case scenario and end with my current setup so far.I’m trying to create a file folder/mail merge printing system for genealogy & correspondence names. The problem I’m trying to resolve is having to copy and paste information over and over into label templates, whenever file folder or mailing labels need to be fixed, reprinted, or duplicated.Currently, I have to copy and paste from within each name or address cell in my spreadsheet. Even if I rearrange the spreadsheet to display vertical columns rather than long rows of cells, a full copy/paste of multiple cells shows mini tables inside the label borders, instead of formatted text columns. It’s exhausting. So the urge is to save the label sheet for when new labels need to be printed as replacements, edits, or extra file folders or envelopes. But then every time you need a few or many new labels printed, you have to hunt them down

AndreaRInspiring

Help with automation that creates nonduplicated record

HI there - I’m about to pull my hair out and have been trying to figure this automation out for several hours now. I have a table called “Field Enrollment” where I am tracking “Producers” with their unique farm #, tract #, and field #. I have a concatenate formula to give me “Farm Key” which is Producer & Farm. I have a second table called “Producer Enrollment” that I want to be auto populated by the Farm Key. However, there are cases like in my example where there are duplicate Farm Keys and I only want the one. (A bit more context: In Field Enrollment we are required to track data related to the unique Farm/Tract/Field. In Producer Enrollment, we are required to track other types of data related to the TOTAL farm, so essentially a roll -up from Field Enrollment.) How do I create the unique record?! Example Field Enrollment table: Example Producer Enrollment table: Here’s the automation I thought would work and is saying is working (but it’s not)

kate1New Participant

Other Questions

Trying to get in contact with the sales team

Has anyone successfully engaged with the Airtable sales team via email? I have submitted the "Contact Sales" form about 5 times over the last month or so, here: https://airtable.com/contact-sales?ref=htcs.prd&_gl=1*1555h4p*_ga*MTkwODg1MjkwLjE2NjY5NjkwODA.*_ga_VJY8J9RFZM*MTY5NzU2ODA3OS4xNS4xLjE2OTc1Njg3NzAuNTcuMC4w Has anyone successfully gotten in touch with a salesperson to get pricing/information about an enterprise plan?

BenFortunatoKnown Participant

Repeating group - error on one script doesn't generate error for automation

I have a script that is using a repeating group to batch process a couple of records sent through output.set() If one of the scripts fails it doesn’t seem to register that error in the overall automation. See image below, individual script failed, overall automation is giving me the green light. I noticed that the script wasn’t behaving correctly on some records but having the script not throw errors is potentially dangerous as problems stay hidden.

ConnorTomaskoParticipating Frequently

Outlook Email Automation Limiting to 25 Emails per 24 Hours

I have an automation set up with an Outlook email action that runs into errors after sending 25 emails successfully. When I run it at least 24 hours later, it will send another 25 emails. However I keep having to push the rest of the records that need emails sent to the following day. What is the term for this specific limit I’m running into with Outlook’s integration? Is there a way around it or to disable it?

Support_ITKnown Participant

Other Questions

Is it possible to be notified in Google Chat, Slack or Teams when "@user" is used in comment/notes

Hello,Quite simple question : today when you mention a user with “@person” in a comment or a note, he/she gets notified by email. Is there a way to route these notifications in Google Chat, Slack or MS Teams ? I’d like to avoid kludge solution like creating a Zap or Make that watches over the mailbox and transform an email received into a chat message, this should flow directly from airtable to one of those 3 solutions, like a setting in the user specific parameters.

Emma-RFPNew Participant

Date counting formula weird results

Hi all, I am copying over historical data into a new Airtable system and I am using the following formula for calculating the number of days taken to complete a task IF( OR({Date Completed}, {Date Completed Override}), WORKDAY_DIFF( IF({Start Date Actual Override}, {Start Date Actual Override}, {Start Date Actual}), IF({Date Completed Override}, {Date Completed Override}, {Date Completed}) ), BLANK())It works just as intended, it counts the number of workdays to complete a task, using the default field unless an override date is being used.However, there are one or two results that are just way off. As an example, one record has the following values:Start Date Actual: blankStart Date Actual Override: 1/3/2025Date Completed: blankDate Completed Override: 23/4/2025Completed Task Duration: 474831What is baffling me is that there is another record with exactly the same dates that is correctly returning a value of 15.The default fields are auto generated via a formula, and the ove

NialloNew Participant

Syncing amendments to Google Calendar events

Hi all,Have been scouring the web, AirTable support and various AI platforms to get an answer to this, but no joy so far. I am trying to set up automation to sync changes between Google Calendar and Airtable, including updates and deletions. AirTable support instructed me to set up triggers for new events, updated events and cancelled events. I am doing this on an empty table at the moment just to test it out. However, I am hitting a bit of a brick wall with the Updated Events automation. I believe I have the Find records action set up OK, see screenshot below (although when I test the step at that stage, it says Found 0 Records but I guess this is because the table is empty currently...)My screenshot: Find records menu Where I’m really getting lost is with the Update record part. According to AirTable Support, “the ID of the action that gets the information to be used goes in Record ID, and should look like the below. “This is because this Integrated Trigger is not directly related to

yonatan halperinNew Participant

Other Questions

sharing an interface

i want to share 2 interfaces with one person, as a commenter, will i pay for him twice?

Mary_WilliamsParticipating Frequently

How to use combined formulas for a label printing program -- Concatenate + if/then + probably something else?

Hello hive mind geniuses! Bear with me, I’m not sure how to explain all this, so I’ll start with my use case scenario and end with my current setup so far.I’m trying to create a file folder/mail merge printing system for genealogy & correspondence names. The problem I’m trying to resolve is having to copy and paste information over and over into label templates, whenever file folder or mailing labels need to be fixed, reprinted, or duplicated.Currently, I have to copy and paste from within each name or address cell in my spreadsheet. Even if I rearrange the spreadsheet to display vertical columns rather than long rows of cells, a full copy/paste of multiple cells shows mini tables inside the label borders, instead of formatted text columns. It’s exhausting. So the urge is to save the label sheet for when new labels need to be printed as replacements, edits, or extra file folders or envelopes. But then every time you need a few or many new labels printed, you have to hunt them down

AndreaRInspiring

Help with automation that creates nonduplicated record

HI there - I’m about to pull my hair out and have been trying to figure this automation out for several hours now. I have a table called “Field Enrollment” where I am tracking “Producers” with their unique farm #, tract #, and field #. I have a concatenate formula to give me “Farm Key” which is Producer & Farm. I have a second table called “Producer Enrollment” that I want to be auto populated by the Farm Key. However, there are cases like in my example where there are duplicate Farm Keys and I only want the one. (A bit more context: In Field Enrollment we are required to track data related to the unique Farm/Tract/Field. In Producer Enrollment, we are required to track other types of data related to the TOTAL farm, so essentially a roll -up from Field Enrollment.) How do I create the unique record?! Example Field Enrollment table: Example Producer Enrollment table: Here’s the automation I thought would work and is saying is working (but it’s not)

BenFortunatoKnown Participant

Repeating group - error on one script doesn't generate error for automation

I have a script that is using a repeating group to batch process a couple of records sent through output.set() If one of the scripts fails it doesn’t seem to register that error in the overall automation. See image below, individual script failed, overall automation is giving me the green light. I noticed that the script wasn’t behaving correctly on some records but having the script not throw errors is potentially dangerous as problems stay hidden.

ConnorTomaskoParticipating Frequently

Outlook Email Automation Limiting to 25 Emails per 24 Hours

I have an automation set up with an Outlook email action that runs into errors after sending 25 emails successfully. When I run it at least 24 hours later, it will send another 25 emails. However I keep having to push the rest of the records that need emails sent to the following day. What is the term for this specific limit I’m running into with Outlook’s integration? Is there a way around it or to disable it?

Support_ITKnown Participant

Other Questions

Is it possible to be notified in Google Chat, Slack or Teams when "@user" is used in comment/notes

Hello,Quite simple question : today when you mention a user with “@person” in a comment or a note, he/she gets notified by email. Is there a way to route these notifications in Google Chat, Slack or MS Teams ? I’d like to avoid kludge solution like creating a Zap or Make that watches over the mailbox and transform an email received into a chat message, this should flow directly from airtable to one of those 3 solutions, like a setting in the user specific parameters.

Ivan_DuboisNew Participant

Interface Designer

Interfaces / List View / Remove Grouping text

In Interface, I create a grouping of my data based on warehouses. That works.The warehouse names appear as their own defined sections, great! Why in the world do I have to see the field name above every single group in my page??1-It’s the same (useless) information over and over2-It’s ugly Is there a way to just remove the grouping title? We can remove grouping record sums! Why not the title? In this example I would remove the POSO WAREHOUSE text.(My fallback is to edit this for something like an Emoji or whatever, but I’d rather have nothing appear). Thanks so much folks!

jejohnsonNew Participant

Other Questions

referral management

I am looking to create a form that will collect referrals from teachers that will store all the referrals in one place for those responding to these referrals to be able to act on them and then have the outcomes of those actions be shared out automatically preferably via email but I would also like the referral data to be easily sortable into specific students as reports that can be printed and have the ability to attach other files to these referrals. I would l also like to be able to analyze all of the data for trends and patterns as well as look at individual student data for trends and patterns. I have no idea where to begin and if airtable can even do something like this.

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