Ask the Community

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 there. Ive been trying to setup automation emails and links were showing as hyperlinks in the beginning as I was testing, but now have stopped showing Please advise. 

Hello, I’m trying to add a link to my automation, but nothing appears when I add the field even when using parenthesis. Could the fact that the url field/column is a formula link be the reason why the link does not appear in the automation? Left is the column/url i’d like to pull in & the right window is the automation I am trying to set up. tyia!

Hi, for a given record, I have data attached to linked records of linked records that I’d like to lookup. I remember this was really easy to do in FileMaker, but I can’t seem to find a way to do this in Airtable, unless I add lookup fields in each table? Any idea/solution would be greatly appreciated - thanks!

I ran into a strange problem in an automation.I am using a script to gather some data from two tables and combine it into a rich-text field. In the next step, I send out an e-mail with the content of this field. Turns out the e-mail is sent before the script has updated the text field!Even adding a 3 second delay in the script does not solve the issue.Curious if someone has a solution in place?Thank you!

Hey guys,Is there any plans to make it so that when someone copies a base from a public share link, that the automations also get copied across?I create a bunch of systems and templates for people to try and get them in to using Airtable but this is big limitation when it comes to offering these types of solutions as the automations are really a big part of any system.Is this going to be possible at any point or is there a good workaround at all?

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

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

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!  

Hi, A few our users are starting to see an error on the interface for a graph. The graph is replaced by the error 'Cannot access this data' Nothing has changed and this can be seen with anyone with database access as far as I can tell. Anyone have a solutions?     

Hey guys, probably an easy thing to do but I want to name an entry according to the right “quarter candidate” field without having to create a super long “IF” formula (I want to update this table without having to update the formula everytime I add a new quarter candidate to the list)My goal : in an other base each new entry have the current date added to it, according to this date, I want to have a field with the right quarter candidate because the date is after the “input start date” and before the “Input end date” Thanks for your help !   

Hi everyone,I recently subscribed to the $120/month plan on Airtable to use the "Invite Interface Users" feature, with the goal of building a secure client portal.🔍 What I’m trying to achieve:I’d like each of my clients to access only their own project status and files (like contracts, invoices, etc.) through a personal and secure interface, without being able to see any data related to other clients.🚨 The problem I’m facing:After subscribing and setting up the interface, I noticed that: When sharing via a public link or inviting users as guests, they can still navigate across all records within the interface. There doesn’t seem to be a way to dynamically filter content per user, which means clients can potentially see information that’s not meant for them. here is the public sharing link : https://airtable.com/appDYt3YzQdpYcnOG/shrUpygqc5VuKVW4OHere is the link to the new "Invite Interface Users" feature: https://airtable.com/appDYt3YzQdpYcnOG/pagkFj34FIhwvysX2🔁 My question :Has

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!

Hellowe are a marketing agency and use records as ‘tasks’ which have time against them so that our team can resource themselves each week and we use the timeline view to check their % capacity and utilisation each day/week/month. some people have a handful of tasks (1 per customer) assigned to them each month, with a number of hours to spend on the customer, but how they actually end up spending their time is a little bit each week. the challenge we have is if you pick a start date and end date as start and end of the month for this task is spreads it too thin and doesn’t allow the guys to setup their days in a more granular fashion.I guess we could break down and have tasks each week but then that’s extra admin, more chances of things breaking, not distributing the tasks evenly on some months with 4 weeks vs 5 and so on. just wondering if I’m missing a trick before deciding how best to proceed in an efficient way 

Trying to create a automation. I want to have it when a occurrence is created, it will get a count, with date, and filter by user. And if criteria is met, it will send a email? Prefer not script has i dont have team right now

Hey all,I would like to generate a document using a template that uses formulas to change the data in that document, and then attach that to a contract (populated with information from Airtable also) which is then sent for e-signature.Any thoughts on how to accomplish this?

Hi all, we had developed a nice data base application, but sometime users have limited access to internet, I’m trying to work around this challenge, so one of the Ideas are: Question:Can the final users in the field download the Airtable application on their Tablets and work on the database offline since there is poor or no connectivity at the sites. Then, when they are back in the office can they sync it to the main cloud-based database Ideas: Download the portion of the DB into CSV to the local PC, then updates offline and then upload it back to the DB, however and afraid the users enter wrong information or get confused by the layout.  Install or add an extension to the DB but I don’t know which could be to let the users work offline. I will appreciate your ideas and thoughts …

I am trying to create a automation when record is updated. and column is delete reason is filled out, I want it to update 3 fields... Active to unchecked, remove by date to current and removed_by to user to logged in user... but it fails. Could you help?  

Hi all,  Sadly, when tagging @yourself, you do not get an email notification from Airtable. I was hoping to solve this with an automation. However, I am struggling to set up a trigger that can detect a comment, and further detect a comment where the user tags themselves. Does anyone have any experience with setting up email notifications when a user tags themselves? Any help would be greatly appreciated, thank you!

Hi Airtable Community,I have an interesting problem I did not forsee when we made a base to track equipment we rent to other contractors from time to time. We have a job (record) where we linked in individual records for different kinds of equipment and now that it has been returned, we need to be able to track and validate it is here. I have the individual records that were added inside an individual cell and it went in how we did it - meaning in no numerical order (we just grabbed a piece of equipment off the shelf, scanned it into the customers record and repeated. The issue with that is the individual records didnt go in in any discernable order. They each have a number, but I can't seem to sort by the record by that number. This creates an issue becuase in order to check the items back in (or rather validate that they made it back here) we have to visually scan through every item in the record looking for the right number. This won't work as it will take too much time as there are

Hello everyone! We build some Scripts with the Airtable Scripting extension and we’d like to trigger them externally via Make.com / API.Is there any way to achieve this?  Airtable Automations are not an option because we are at the 50 Automation limits already (why would you make this limit so low??) Any help would be greatly appreciated!   

Is there a way to add the description from asana card to be sent via script to airtable. I have a full script which is pulling fields but it wont pull the description