Ask the Community

2 interface questions: Is there a way to discard unpublished changes? I was trying to add something to a current interface, but it isn’t laying out how I want it to… so I want to revert back to how it was. But it won’t even format itself back to how I originally had it… So I’d like to discard these changes and put it back how it was automatically. This leads me to my next question. Can the elements on the interface only go into these pre-determined ‘boxes’ that are popping up. Sometimes it won’t allow me to resize things the way I want them because it doesn’t seem to ‘fit the mold’. Does anyone else have this problem? I hope those make sense!

I have a bunch of columns/fields that use the same list of single-select values. I have changed the colors of the selectable values in one of the columns and I want to apply the same change (colors) to all the other columns with the same range of values. How can I do this short of manually edit the colors on all the other columns?

Hey experts, I’m a beginner of Airtable and I’m setting up the bases & interfaces to present my team’s resource allocation plan.I have set up two bases: Task & Timeoff. And I have created an “Utilization Interface” as shown in the below screenshot.I’m wondering if there’s a way to show the timeoffs in this interface as well? If so, should I merge the two bases (task & timeline) together? Or if there’s any other best practices that I can keep these two bases separated but still show both the task and timeoff in the same utilization view?Thank  you so much for your guidance!!

Problem:When adding a linked record in Airtable, the search is currently limited to the Primary Field of the linked table. In many cases, however, the Primary Field is a technical ID or a customer number, which is neither intuitive nor easy to remember for users.Example:We have a customer table with fields like Customer Number, Company Name, and Address. When linking a customer to a product table, we can only search by the Customer Number (Primary Field). This is inconvenient because we would often prefer to search or filter by Company Name or Address to quickly find the correct customer.Current Workarounds: It’s possible to create a formula field that combines multiple fields (e.g., Customer Number + Company Name). However, this combined field

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 d

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

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 on

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 typicall

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 atta

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 wo

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 rec

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?