Ask the Community

Hi.  For the past 1 - 3 days, I've been experiencing immense slowdowns using the web UI interface of Airtable, when loading tables, changing formulas, doing any updates whatsoever.  This used to work pretty fast up till now. As far as I know, nothing drastic has changed from my base size, or design.The Web UI takes ages to load irrespective of table size, I have tables of less than 200 records which take a very long time, and also others of 10,000 records. Tools integrating with Airtable, like Make and some other tools, still work pretty fast and get good response rates.I have no idea where to start to troubleshoot such performance issues, or how to go about this.  Any help would be greatly appreciated.

Hi everyone, I’m facing an issue with counting linked records in Airtable, and I’d love your help! I’ve created two tables for managing group interviews:1. “Entrevues Dispo” (Interview Slots) – Tracks the availability of each interview slot.2. “Entrevues Inscriptions” (Interview Registrations) – Stores candidate registrations linked to the available slots. In the Entrevues Dispo table, I have a linked field called “Entrevues confirmées” (Confirmed Interviews), which pulls all the candidates linked to a specific interview slot. The relationship works, and I can see the correct linked records. The Problem: I’m trying to calculate the number of candidates per slot using COUNTA({Entrevues confirmées}). However, it only counts 1 record, even though there are multiple linked records (e.g.,

When creating filters for views, I often have to select a lot of options from a multiselect field. Once i've selected more than a couple, it becomes difficult to see all my selections. It would be great if the filter view area could be enlarged to full screen or expand to display all the available options. 

Emails sent via automations replace underscores with nothing, thereby corrupting the URLs, and other values, that contain underscores. I've read the many posts about this and still can't figure out the syntax to use to make this happen.Here's an example screenshot:What syntax would I use to ensure the Asset Location (URL) field values will retain any underscores?I've tried single-quotes with parentheses, and/or brackets but am not having success.Thoughts?   

I have read previous posts on this topic (syncing with Google Sheets) but a lot of these posts are from 2019, 2020 or even earlier. I would like to sync up my Google Sheets data with Airtable so my tables in Airtable update as Google Sheets updates. I am unable to use zzzBot because of privacy restrictions (?) and a lot of changes have been made to different integrations. Does anyone know whether it is possible to sync Google Sheets data with Airtable?

I am new to the free version of Airtable which I am using to keep track of my craft stamps. I have at the moment around 500 items which have sentiments listed. When I try to find a particular sentiment I search for eg has any of, but it gives me "enter comparison value" and all the sentiments I have created. What I want is just a search box so I can just type just one word eg happy, so all those sentiments are found. What have I done wrong please and how can I rectify it.

Hi support, We're changing the ownership of a workspace to a new owner. Will this affect our automations and API integrations?   

Hello, I am trying to get this to work but all I get so far is a massive headache haha 🙂Context : organizing automatic reminders to clients we're meeting at a trade show. On the day of the meeting, I want to send a reminder to the invitee at 8:00 local time (and of course this local time changes depending on where the trade show is) to tell them they have a meeting with us that day.I have two tables.> One for trade shows with Trade Show Name (linked to the other table) and various fields, one being a number field providing the hours difference as well as a time zone field 'Europe/Paris' for instance, this being the time zone where the trade show takes place. > One for meetings with plenty of fields, including one that comes from our booking tool (Calendly) and where I've set up a webhook and the meeting time always comes as UTC. I have there also a lookup field repatriating the hours difference as well as the timezone field.

Hi,I'm looking to secure that some fields are filled out before a user can check a "Save" checkbox on an interface page, since there is no actual "Submit" button we can use. I have gathered from previous answers that there are no native ways to do this in Airtable.To be sure I'm asking again if somebody has come up with something for this?Alternatively, has anybody had any experience with the new DataGuard extension? They claim to be able to do this, but the public info is relatively brief and I would appreciate hearing of any real life experiences. Here's their marketsplace page:https://airtable.com/marketplace/blkg6J9RM61xpauOZ/dataguardThank you in advance,Björn 

I am trying to find a better way of building out our schedule across the entire portfolio.Current setup:Projects tableTask TableFinancials TableCurrently the schedule only assumes the task lead times to do a workback for planning along with a workforward schedule that adjusts forecasted delivery based on actual stage gate progress.Separately we manage finances and track costs and approvals, along with payments, however all of these are linked to the projects. When we hit our budget for the month in our portfolio spend, we end up delaying tasks and pausing development.So what i would like to do is have the workback schedule anticipate the weekly budget and increase LT for the workback so that we can ensure we are starting projects early enough to schedule in their payments.Is there a way to structure this with automations and formulas to avoid having to do this manually for 1000's of projects? 

Hi Everyone, I’m getting a few enquiries about clients wanting to move from HubSpot to a Airtable based CRM. It looks like HubSpot allows the export of the Contacts, Accounts, Deals and probably other related activities but I wondered if anyone has been through the pain of doing this and associating the records back in Airtable. Any advice, tips, lookouts is greatly appreciated. Jason

What is the best form app which enhances airtable forms ?https://on2air.com/forms/https://www.fillout.com/airtablehttps://miniextensions.com/category/form/airtable-form/https://www.feathery.io/blog/airtable-forms-a-comprehensive-guide-for-2023 https://www.dronahq.com/airtable-forms/https://nativeforms.com/airtable

Hey guys, I need your help!I have 3 tables -1. Projects2. Items3. TasksIn general - each project has linked items and each item has linked tasks.Because that was the goal, the only place where a specific employee is associated is at the tasks stage.Because each task is linked to an item and each item is linked to a project, I knew that if I associated an employee with a specific task, he would also be associated with the appropriate item and task.The problem - the client now says that he does not want each item to have a task.Now, this creates a problem for me because in such a situation I do not have a task to link to this item and then the employee "does not know" that he is associated with this item because there is no task under it.How do I overcome this?Did I build the entire system incorrectly?Do I need to create an "employee" field that we will have to enter at each stage? Task, item and project?

Hi all@TheTimeSavingCo @kuovonne @ScottWorld Keen to hear how you would go about setting up the subject. Details below;1) Buyers need to make single or multi item enquiries to their delivery location.2) Sellers need to be able to make one or more quotes against selected enquiry items.3) Upon approval from both sides the status moves to ordered. 4) Currently I have the inquiry items table linked to a parent table which holds the buyers details. Likewise with the quote items linked to parent table.5) The sellers needs to view the inquiries and choose the selected products to quote price and quantities against. This needs to create a record in the parent table aswell as the quote/order items tableBuyers then need to accept quotes.Sellers then need to approve.Order becomes final

I have a base with two tables: Employees and Projects.Employees has a primary field of Employee ID and Project IDs.Projects has a primary field of Project ID, Project Manager(s), and Status.In the Employees table I want the field "Project IDs" to be automatically populated with the corresponding Project ID from the Projects table when the Employee ID matches any names in the Project Manager(s) and when Status is not "Completed".Sounds like it should be simple. But I can't seem to figure it out. Thanks for any assistance! 

Hey guys, I am trying to automate my content posting through AirTable and Make and everything works fine until Instagram has to access the video file/URL from AirTable, then it fails and gives me errors. It's because my table is not publicly accessible so how can I change that so Instagram can access the Video URL without being blocked?

Hello everyone,I'm working with an automation system on Make.com, where I generate images using an API and then send them to Airtable. However, I’m currently facing an issue:When the generated image is returned via a webhook from Make, I’m unable to insert it into a specific field of a table in Airtable.Here’s what I’ve done so far and the problem I’m encountering:I THINK I created an Airtable record with a Record ID (see screenshots).When I attempt to update this record in Airtable, I receive an error message stating, “Received invalid inputs.” At this point, the Record ID appears to be missing(see screenshots).I’m not su

Hi, how are you?I have one table of leads that has the date each lead entered the system.Another table of advertising expenses where I pull yesterday's advertising expenses every day.At the end, I want to make a total of how much a lead costs me each day.I thought about adding a column in the advertising expenses table where I would pull the total of each day's leads and then divide the expense by the number of leads.But - I can't figure out how to do it correctly without running a lot of internal automation.Could it be that I'm missing something? It seems very simple and logical to me that it should be possible to do it quite easily.I would appreciate your help!Thank you very much!

Hello,i would like to create an Automatisation that send an Outlook Shedule link to an Customer to his Email.1. Customer types his Email in a Form (done)2. Customer chose a Date Slot over Form (done)3. Automatisation creates a Outlok Shedule (Date he chosed) link and send it to Customers Email (open)Im familiar with many Automatiosations, but this one is a Riddle for me. Anyone who created somethin similar and can please helm me? Thanks!!

Im currently building an online question bank for medical students. The bank will be sold online, with anual subscription. Im looking for a web developer to help me build the question bank. There will be approximately 5k questions and about 100-200 users yearly. The questions must be separate by theme and year.Im would also like the it features a feedback page. With test results and performance in graphics. Do you know anyone that could help me?

Hello, I have a price list table and I want to update them following sector index.I will use api from the french statistic instute to automate the process but I am not sure which tool to use. I woyld be keen on just doing an airtable script.I am able to use the api of the institute (but I don't know how to code it into airtable script), the answer is a big xml file which contains basically a large number of series with dates  and values for each in two lists of the node serie X. What I want is to be able to parse this xml to merge the dates because there are the same and put it in a column and create one column for one index with the value.There are plenty of tools but I don't know which process is the best.Thanks you for your help!If required, I can attach the xml response file.

I’m very new to airtable but have learned a lot by watching tutorials and searching the community. I’m not sure if I’m searching for the right thing for this particular issue though. I’m setting up an airtable for a client who has a form that needs to be completed by his clients on a weekly basis. He needs to know who hasn’t submitted the form 3 days past the day he sends it out which will be on the same day each week. For instance, he’ll send the email with the form attached to be completed every Monday and if someone doesn’t fill it out by Thursday, we need to automate an email to follow up and remind them to complete it. I’m thinking I need a field dedicated to auto-populating whatever the current day is or at least a formula that shows when the week starts and when it ends. What formula do I need for this? This is literally the last thing I need in order to complete this airtable setup but I can’t figure it out. Any help would be greatly appr

I have a solution with 2 tables: An Invoices table containing invoice information (date, amount, etc.) A Payments table containing payment information (amount, method, date, etc.) I want to link these tables so payments can be applied to invoices. I need a column that shows the remaining balance of each invoice after full or partial payments are applied. I created this using a lookup field and formula field in the Invoices table. However, I'm having trouble when I need to apply one payment across multiple invoices (either to the same vendor or different vendors). Currently, the lookup field calculates the full payment amount towards each invoice, which is incorrect. Is there a way to split a single payment across several invoices, allowing me to specify how much of the payment should be applied to each invoice? I need the final balances to correctly reflect the payments for each invoice.

I created a form for our rental car contract in Fillout. Everything is populating correctly into airtable except the time. My issue is that I put the "date - time out" in the form eg 12/19 8:00pm. It will populate to airtable as 12/20 3:00am if I have the airtable time set to UTC. if I change the time in airtable to Denver (which is correct) it populates properly from fillout to airtable. HOWEVER, when I open the PDF everything in changed back to being a day in the future at 3:00am. I think it will work properly if I create seperate fields for date and time, which I can do, but it seems like it should be able to work by doing it the way I am. I'm sure this is a timezone code I cant for the life of me figure out. Please help, Thanks!

Hi,I am setting up an automation with integration with Outlook emails. I can only find limited trigger options. I don't want all my emails to go into AT, only select ones. I figured I would do this by making the trigger conditional, i.e. only when an email is designated with a certain category will the integration trigger and the email post in AT. Does anybody know if this is possible?Thank you in advance, Christopher