Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
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.
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
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
i want to share 2 interfaces with one person, as a commenter, will i pay for him twice?
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?
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
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)
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?
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.
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?
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.
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!
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.
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.