Ask the Community

I’m confused at why this is so difficult to figure out. I want a record created automatically once a month in a table via automation with start and due dates filled out. You can’t add formulas to automation fields so that’s a no go. My workaround is that I’ve created a ‘creation date’ field that is filled in by the automation’s ‘expected trigger time’. That create date field is then used to fill in a start date and due date formula field using the DATEADD function with some math. My problem with this method is that I’m not able to change dates independent of each other if I need some flexibility and the only way to adjust dates is by adjusting the ‘creation date’ date field. Having due dates populate based on the date the automation was fired off seems simple enough but I can’t really figure out the best way to do this. Any input would be great!

I have a field in TableA called “ProductSKU” which is a primary field that concatenates some data from other fields in TableA. The formual is: LEFT(Description,10) &"-" &FinishCode &"-" &Model I have a field in TableB called “SelectKit” that is a link to “ProductSKU”. I have a third field in TableB that concatenates data from the “SelecKit” field. The formula is: LEFT({SelectKit},5) Now, that we’ve established that. I have found that SelectKit is arbitrarily entering a single quotation mark as in " just before the text that is being pulled from “SelectKit”. This only happens in one case. I’ve checked all the fields from every other table and there is NO quotation mark entered in a field. I’ve checked the formulas and they all appear correct anbd otherwise working, except for one entry. Why is this question mark being entered??

Hi, I want to track employee annual leave via Airtable. They’ll input Date From & Date To (including time). There will be individual calculation fields for each leave type (e.g sick, annual leave etc) and an approval status. So this formula would be wrapped in IF conditions; IF Type = ‘Annual Leave” and Status = “Approved” this calculation will apply. Formula needs toonly calculate weekdays (ignore weekends) understand 1 day = 7.8 hours only needs to count hours if the time differs between date from & date to fields. Understand working hours are 8:30-5pm (time zones differ) So outputs for the following would be;17 June 2025 3:00pm → 17 June 2025 5:00pm → 2.0​​​​​​​17 June 2025 3:00pm → 18 June 2025 3:00pm → 7.8​​​​​​​17 June 2025 3:00pm → 18 June 2025 5:00pm → 9.8​​​​​​​17 June 2025 3:00pm → 24 June 2025 3:00pm → 46.8 I’m open to doing this more simply via the base design if the formula is too difficult to write (e.g having the employee select from a drop down to say ‘full days

My AirTable implementation deals with scheduling and staffing of courses for a university. We have a table for Professors, a table for Courses, and a table for Offerings which marries the two together with each record representing a single staffed course-section that students will ultimately be able to register for.Of note: currently our professors do not have AirTable access. Having them create accounts is currently not an option, unfortunately. Additionally, our plan does not include AirTable Portals.When we initially link professors to offerings, we need to send emails to have the professor accept or decline the position. We currently intend to do this via a Fillout form that will allow them to edit a single select field with accept/decline as the options (the “Accepted?” field below). Our issue is with the fact that professors teach several offerings every term, so sending one email for every offering would be cumbersome. Instead, we want to find a way to send a single email to eac

I like to know what others are doing to have better organization of managing their users against workspaces, bases, and interfaces, specifically within their organization. I have built a number of apps amongst different departments. We have not decided to turn on enterprise hub yet for our enterprise account but we do have SSO. However, I think using groups would be useful as a growing community of users is developing. I’m a little clunky with using groups and will need to a lot of clean up. Structurally this is how I’m laying it out:Workspace per department Product owners of the Base have creator access only at the Base NOT at the Workspace level (Reasons - within the department could have multiple products not meant for other team members thus at the Workspace level gives too much control) Groups - Product owners are Group ManagersMy logic in what I’m thinking to do:At the Base level manage access for creators only Instead of inviting people directly to the base or interface per a pe

Ok, who approved the new gui layout? I keep going top left for the Hide fields, filter, group, sort….. only for it not to be there anymore!!! Any chance you could put some real effort into wrapping the headers of columns please?ALSO allow us to colour the different groups. 50 shades of grey is really difficult to keep track of! 

Hi All,we keep getting the error message “Invalid permissions” on the Airtable app on Android phones when trying to view our Interfaces. Everything worked just fine for months. The users on the phones do have access to the Interfaces, as per our settings.Weirdly, the error can be circumvented when accessing the same Interface through a direct link that we click from outside the Airtable app. We re-started the phone, cleared the cache, uninstalled&installed the app. None of those helped.Has anyone experienced this before and is there a recommended solution?  

Hello all:I have a table that stores our department's class offerings schedule. The important fields are:Lecturer's name Course number  Day of the week (Multiple select - as there can be multiple days the class is offered)  Start time of the class (the date does not really matter here; We only care about a typical week) Duration of class (in minutes) - helps to compute the end time of the sessions. I would like to generate a view that shows us the Weekly Schedule that is “date Agnostic” for an entire semester. The columns will be the weekdays, and the rows will be the time frames of each day (running from 7am to 9pm). I would like the classes to be filled into a “calendar-like” view based on their time and day of offering. This will aggregate across all classes, and i would also like to apply filters to it. We achieved it in Tableau, but it would be nice to have it in Airtable, where all our data are typically stored. Thanks for your help. 

Hello all, Basically I have a form to link working units and owners: For some reason the “+” button on the Owner side is displaying “Add unit” and I can’t figure out how to change it to something more accurate (Add robot). Do I need to rebuild the table and change the name of how I will call each record? Secondly, I just noticed (probably I did it in the past but I forgot to follow it up) that the visibility of the fields is limited once I applied a filterIn other words, with this setup…  As soon as I enter parameters on the “filter”, I see “0 visible fields” on the fields option. That limits the visibility to end user when is trying to attach/link an option after clicking in the button, no idea if there is a workaround to avoid this behavior.The filter contains a couple of rules to limit the options displayed based on the “current’s user email” which is strictly needed. As an example, in the opposite side… if I remove the filters... It seems to be by design, but, any alternative aroun

Hello! I realize this might sound confusing! Select item in one field, have it filter the second field based on that selection so I can choose from a filtered selection, and then auto-populate the third field based on the second selection I make. Here is a quick Loom so you can see what I mean! Loom Loom | Send a video. Not a thousand words. Get your message across with instantly shareable videos for work. Capture your screen, record your front-facing camera, and narrate it all at once, then instantly share with a simple link. I have a column with OEM Make, those OEM Makes have specific packages but those packages all include different things, but some OEMs have the same package names even though they include different things. I want them to be able to choose the OEM from the OEM field, then the package field with the packages they can choose from only has the packages that match that OEM. Then the 3rd field is auto-populated with

The back end of one of our products is built on Airtable. Its been runing fine, but in the last couple of months (since May 18th) it hasn't been working anymore. Unfortunately we didn't discover this until now, and this means a key product in our whole business is broken/down.Did airtable change its scripting system to change how attachment fields work? The images being attached work, the script appears to successfully run, logs are totally okay, just the images don't get attached at the end.More info:We wrote an airtable script that, based on data, attaches a photo to the airtable. The script stopped working recently. It gets triggered, appears to run, logs look fine, but images aren't attached. It was working before, but stopped working around may. What do you think the issue is?We’ve emailed Airtable support but haven’t heard back yet :( let table = base.getTable('Raw Data');let inputConfig = input.config();let recordNumber = inputConfig.RecordNumberAutomation; // Replace with actua

I’m very new to Airtable, here’s what I’m trying to achieve. I have a table named Inventory: Name, Category, Price.A table named Project: Address, inspection date, images, Reno Estimate. Ideal process: From the Project I want to select items (30-50 items) (ideally a multiplier field. eg: 1x, 2x etc) from the Inventory list. (Or even just a checkbox) So for the Project I’ve selected what Inventory items I’ll need and the total of their cost.Hope that makes sense.

I have a main table with records, and linked tables with linked records, they are readable using an interface. I want to enable independend Airtable users to select specific records from those tables, to export or print that selection. They need to be able to do this independently, so one user should be able to select records without those records also being selected for another user. 

Hello! Recently took over Airtable and am getting familiar with it. I set up an easy lookup between linked tables, but am having difficulty with a little more complex scenario. I have two tables that are linked, let’s call them ‘Operations’ and ‘Account Management’.Each table has fields that are: Partner, Territory and Business Line.I’m trying to set up a lookup in the Operations Table, where if all three of the values match in the linked tables (match on Partner, Territory & Business Line) - then return the value in the ‘Account Manager’ field which is stored in the Account Management table. Assuming this is possible, any ideas on the easiest way?

Hi All, Our team is having trouble with the cells running into the other pages when printed. This doesn’t affect everyone, just some people which makes me think it might be a setting issues. Any thoughts?“So the problem of the grid lines not closing between pages is still there, but it looks less messy than having long columns of text and pics in the body of the report. I tried using the Page Designer Extension or an outside program as suggested by others, but they require you to basically restart the whole template.”

Hi useful people, Our Airtable database contains multiple services with attendance data. We also log the individual names of each attendee. Airtable can easily gather the total about of attendees across a period of time - my question is, how does Airtable gather the individual data? For example, Airtable may tell us that there were 1000 attendees across a calendar year, but how many many of those are the same people? What we’re looking for is the amount of individuals who have accessed the service in the calendar year, not a total attendance tally. I hope that makes sense… thank you in advance.

I am new to airtable and am having trouble.  I have a cattle ranch and am working on a database to manage their reproduction.  I would like to calculate each cows conception rate based on the number of times she has become pregnant vervus the total number of opportunities she has mated.  For example, if she has been with a bull 10 times and has become pregnant 7 times in her lifetime, then her conception rate is 70%.I have each cows breeding records in the data.  I also have a field titled “pregnancy status.” If i use rollup for this field with:Source= Cattle ID#Cattle field to rollup= Pregnancy StatusPregnancy status field is: pregnant or non-pregnantHow would I create a formula that would look up the pregnancy status for each mating and then calculate the percentage pregnant for the cow’s lifetime? Thank you so much for any help you can give me!  

For the love of all that is holy, WHY!?In this most recent UI update, Airtable seems to have randomly increased the margin width on the Interface side pages, messing up many of my pages and making it much harder to fit three elements per line in many circumstances.Example 1:The lines in each section of this page used to fit the width exactly.Example 2:The Action Menu dropdown was to the right of the Status field. Now it is pushed to another line.It is no longer possible to have a section division, and fit three total elements abreast. I hope to god this is a bug and not an intentional choice... 

Hi All,there is an issue for some users I invited to use my interface. An error message pops up for them when clicking in one of the tabs. They are all read only users with NO access to the base. That specific tab is created using the new interface templates, where you can switch between views: list or gallery. Error message:An error has occurredSorry, your request conflicted with another change.Thank you in advance!

Hello Airtable Community,If you’re looking for a way to integrate Airtable with Notion, I’ve created a beginner-friendly tutorial that walks you through syncing your Airtable data directly into Notion using an API-based approach.🔗 Step-by-step guide: Import Airtable data into Notion This Notion + Airtable integration tutorial covers: How to get your Airtable API token How to build a request URL to fetch your Airtable records How to sync data into your Notion database automatically It's perfect if you're trying to centralize your Airtable workflows in Notion without manual copy-pasting.Let me know if you have any questions. 

I’ve made a print view using the blocks. I’ve set the page direction to Landscape. But every time I’m printing i manually have to switch to Landscape in the print prompt - is there away around this? Secondly my printer constantly prints an empty page. Tried to move content away from the edges and play around with the margins but no matter what, my printer prints my view followed by a blank page. Does anyone have any idea how to get rid of the empty page?

Hello, I have a JF table which contains dates of public holidays and an APPRO table which contains a date field. I can't test if the date field in the APPRO table is a public holiday. Does anyone have a solution?

After reading this topic about tracking an airtable iFrame, I looked deeper into if its possible to track interactions within an iframe through scripting. I read a few articles, but this one explained most clearly that it’s not possible: Note: To reiterate, you need developer access to the iframe in question . This means the source website’s code, not the iframe HTML on your website. 80% of the cases I see where people are struggling with tracking iframes are simply not possible. Without access to the iframe in question, you cannot install any tracking code. Since I don’t have access to the source for the embedded form, I can’t do tracking. My organization is relying heavily on airtable, especially for volunteer signup forms. We’d like to know how our forms are doing in terms of converting potential volunteers, but right now we’re blind because Airtable doesn’t integrate with Google Analytics. Another tool we use, Donorbox, also relies on embedded iframes, but has an option to input

Hello everyone!Thank you for taking the time to read my post.I’m new to Airtable, and absolutely loving it so far!I’ve already built a database, created forms, and now I’m exploring interfaces. My goal is to give different establishments we work with access to some of their own data, so they can add, update, or delete it as needed. I’m currently trying to achieve this within Airtable itself, without using third-party tools.I noticed that when sharing an interface, there’s an option to restrict access based on specific email domains, which is great, since most of the businesses we work with have unique email domains.I tested this using a random email I created for the test, and a few unexpected things happened: I received $10 (which I wasn’t expecting). I got an email saying I would be charged (also not something I intended). When I logged in using the test email, it didn’t allow access to the shared interface. Instead, I saw a pop-up saying I don’t  need to request access, it was a

Hi Make.com was able to create this But I can not see on my side airtable What am I doing wrong why can I not see what that see when test?regards Linda