Ask the Community

Hi! I have some pivots in Excel that I’m attempting to re-create in Airtable. It has multi-level categories in the rows (Region, Country) and then 4 different metrics that I convert to a %. (In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount) I have all of the line-detailed data that you’d need to get this in Excel (Record ID, Region, Country, and binary 1/0 for In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount.)  I cannot for the life of me figure out how to replicate this in Airtable and then add it to an interface. The closest I’ve been able to get is a grouped view of the data that I show as a grid and then removing the “0”s and changing the values of those metrics to be % Filled. This is almost fine, but it doesn’t stay grouped and expands too much. Is there a better way to do this? 

Hi! Does anyone know a trick about how to get the email of a user, that filled a form with a “Restrict access to an email domain” activated? When this feature is on, the user must sign up and login into AirTable to fill the form. If the user’s email domain belongs to the one accepted at the form settings, then he can view the form, fill and submit it. So my question is: since the user have just signed up and login, is there a way we can save the email address used, inside the created record? Thank community!

Hi all, I already know Airtable doesnt allow you to share interfaces with non-users (not a good move, Airtable!) but i'm trying to not give up on the beautiful dashboards i made.Other than taking a screenshot, are there any extensions/third-party tools that i can use to share my dashboards with others that are not on Airtable? We want to share it with our board, funders, etc.

Can anyone explain what this error message means? “Field cannot accept the provided value: Could not find matching rows for string.” Trying to fill a linked column with an automation, however, sometimes there is no information to fill.

I have been looking everywhere for this answer and I swear I have watched 100 Youtube videos to no avail. Hoping someone on here can help me :)I currently have a “projects” table and a “tasks” table in my base. The projects table is configured so when I add a task to that project it adds it in the tasks table to be tracked. However, if I add that same task to multiple projects it tracks it in the tasks table as one record. Therefore, I can’t individually track the same tasks for several projects. Basically, I want to select the same tasks for several projects and then track those tasks separately. Example:Project A tasks:-solicit bids (complete)-draft contract (in process)-hire sub (on hold)Project B tasks: -solicit bids (in process)-draft contract (on hold)-hire sub (on hold) Thank you so much in advance!! I really appreciate any help that can be provided. This seems so simple but I just can’

A quick question - I have a KanBan view, with a ‘Month’ field as the stacking field: JAN 24, Feb 24, Mar 24 …. etc.I want to be able to filter down my Kanban view, to just show recent activity, eg) 2025, but filtering the corresponding records for the view leaves the empty stacks in place. I know I can use the ‘hide empty stacks’ toggle, but it will hide any recent, relevant empty month stacks that I may want to use, and not just those in the past (2024, etc.) Any ideas?

Does anyone know how to get Airtable to go back to a previous look.  The new look with the status bar on the left has made airtable more difficult to work with.  Left Bar down the entire window instead of across the top.  

I’m creating an extension here. Often times I want to send record from extension to my backend api. My backend already supports the json serialized format returned by get records api. It would be very helpful if there is a method to convert record object in blocks sdk to that format. Or is there already a way for that?Thanks

Trying to build an automation where an email is sent when a record enters a view (specified by a month status). The record contains a previously uplodaded file (pdf). Up to that point I’m able to make the email automation work, but when trying to add a last “update record” step (so that the record is updated after the email has been sent out, by having its status changed/updated) I get an error. Seems as if Airtable wont be capable of updating the record  “status field”  because the record contains an attachment. Trying to work a solution that will allow me to keep using the product. I have a paid version.  

Hello, I have a main base and several project bases that have a two-way sync with this main base. In these project bases, I receive data from my main base, but also have columns specific to these project which are freely editable by the teams.I would like my columns from the main base (the sync one) to be in editor access to the teams (values are editable, but not the column), and the non-sync columns to be in creator access to the teams. How can I do that ? Thanks !Agnès  

I am perplexed by the labeling in Airtable Calendars.  In the attached screen grab, I have two projects in a single calendar, separated by color.  Great. However, it does not show the label of the fields I have associated with dates, even though it seems like there is ample room. So great, let me enable the labels I want.  Except it doesn’t show the labels, it shows the date, but instead of just including the date on the specific entry, it puts it on ALL entries.  Very perplexing.  Why would I want to show the date of one entry on a completely different entry that falls on a different date? This makes no sense and can not imagine a case where this would be useful.  Why won’t just show me the label that is already there on a specific date? Is there away to show the whole label on a given entry? In both the Interface and Calendar view I see this and can see know way to show the entire label.

When using a form, I want to offer specific choices for students to choose from, but I also want to offer them to option to fill in some option that we haven’t thought of. (As in, “how did you hear about us? Internet search, friend, Facebook, other- tell us how”) Thanks Linda

Is there a script that can initiate printing of a record designed in the printing extension from an interface? As in, Print This Record?

I am importing three different reports into the same table.  One report’s DOB field provides the date as we wish it to appear, MM/DD/YYYY.  The other two reports provide a DOB format of DD-MMM-YY.  I am using a formula to convert the DD-MMM-YY format into MM/DD/YYYY and then using an automation to move the DOB Calculation into the DOB field.  Some of the converted dates are future years.  The formula correctly converted 23-Sep-97 into 9/23/1997, but 29-Jan-56 became 1/29/2056.  How do I get the formula to create DOBs in the correct century?Some years convert correctly, others not so much.Current formula. 

Hello Community! Has anyone had success printing from the new Interfaces feature? I’ve created some texts and a table in the new Interfaces feature - basically it’s a nice checklist. When I do a basic print - the formatting is way off and my table doesn’t fit on the page. I tried using the app Page Designer, but it doesn’t appear that you can select an Interface to load into Page Designer. Thoughts? Suggestions?

I’m running into an issue where a URL prefill is linking the correct records to the form, but showing them as “unnamed”. I know they are the right records, because when I submit it shows the correct records. This wouldn’t be a problem, except for the fact the the user needs to see which record is which employee, so if they need to they can remove someone that left early, for example. Anyone have any ideas how to have it show the names of the employees that definitely are not “unnamed” and have something in their primary field?We are using Record IDs to prefill the Employees field.Thanks in advance to anyone that has any ideas or suggestions!

Is this scenario possible?I want to automate a task on my team in which a team member would create a record and attach a word doc to it. The team member would then fill out a form which allows them to attach the record they just made (or any record via the dropdown that lists all team member-made records). Once they submit the form, it triggers an automation to send a pre-determined Teams message with the record chosen from the form. I successfully created an automation to make part of this happen, but i can’t get it to attach the record (because the message is static and the attachment is dynamic?) Is there a way to make this work??

I can’t see anywhere which would state if my level has been set as builder or end user? 

Hi all,I am struggling to find a solution to this, and I wonder if it’s an easy problem. I want to upload an attachment to an Airtable base for a specific record/field; I am following the instructions reported here: Upload attachment - Airtable Web APIHowever,m I keep getting error 403. I can create and update records, but the image upload is not working. Any ideas? 

Hello all,So I have been uploading attachments to a field through a google share link and have made sure to make the file and folder public but for some reason when i click on the attachment it just comes up as a blank screen and says loading but never loads. The share link is fine as when I put it in the url bar it works perfectly. Im unsure what is causing this??

Hi everyone, I’m setting up a project management base with dependencies between tasks. I have two questions: In some cases, task 2 can begin before task 1 ends, but the completion of task 2 does depend on the completion of task 1. There will simply be some overlap in when both start (e.g. parts of task 2 can be started before task 1 begin, however until task 1 is completed, task 2 cannot be fully done). I have set up the dependency as Task 1 → depends on → task 2. However, this then shows up as an error: Task 1 begins before Task 2 ends. Is there a way around this? What happens when you have some dependencies in the same table that are predecessors and some that are successors? Thanks a lot in advance!

Hi all, Any help would be appreciated on this one. I'm working on an automation in Airtable we previously used Zapier for to try and streamline some self-fulfilling on-demand educational resources. The way I currently have it set up is in one Airtable base, but two separate sheets. One sheet has an external-facing form for people to order course content through, another sheet has the content listed by name, in zip files or individual files. The names match the form exactly, and I have tried two different methods to get the automation to grab the content from the form sheet based on the name: multiple select and link to another record. Any way I do this it provides all or none, and won't search by name. The content is currently fulfilling best in an Attachments field in a zip file as it ranges from PDF documents to videos to PowerPoint files. The actions I'm using are 'When a form is submitted', 'Find Records', and 'Send an Email'. I've attached images of the

TODAY() and some similar functions are broken because they're stuck on Greenwich Mean Time. What it's meant to do is return a value that changes once per day, at the start of the day. It does this by setting the time part of the current date and time to 0 but, because Airtable's internal time zone is GMT/UTC and yours probably isn't, the result of the function will never be the start of your day. Any formulas that rely on it will have flawed results. The effects depend on how far from GMT your time zone is, and how accurate your formulas need to be. During summer in New Zealand, for example, with an offset of +13 hours, it behaves like a YESTERDAY() for more than half of each day. In California it becomes TOMORROW() early every evening. It can wreck reports and automations.Changing the time zone in the formatting of any formula that uses it

Does anyone know the names of the colors in Airtable? Thank you.

We are looking to reply to specific Slack messages to update product status. While it looks like it’s possible through Slack conversation IDs, I haven’t found documentation on how to set it up. Does anyone know how to do this without an external automation? I checked the following thread from 2 years ago, but it mentioned Make (an external automation tool) - I don’t believe my company will allow such integrations: