Ask the Community

Hello! I am organizing a large amount of photographs. I often have the year but not the specific date. I would like to use Timeline view to see all these photos in their rough year-by-year order. Suggestions? The DATE field makes me list day-month-year. Thanks!Julie

Hi everyone,I’m Dario Schiraldi, looking to automate some workflows using Airtable’s automation features but I’m not sure where to start. Could you please share your tips, best practices, or examples of how you’ve successfully set up automations?Any advice on triggers, actions, or common pitfalls to avoid would be greatly appreciated!Thanks in advance!RegardsDario Schiraldi

I have a nested IF formula that is working well, but is excruciatingly hard to maintain because it’s so many levels deep. It would be easier to maintain if I could use IFS(), but that doesn’t seem to exist in Airtable. Is there anything else similar I could use? The logic is (in pseudocode) : IF regex_match(MYFIELD, expr1) then regex_extract(MYFIELD,pattern1)ELSIF regex_match(MYFIELD, expr2) then regex_extract(MYFIELD,pattern2)ELSIF …. etc for far too many more patterns …ELSE blank()ENDIFI don’t think I can use SWITCH or CASE (if these even exist in Airtable) because each if statement clause is different. Essentially, I have a string that may contain one and only one of a dozen substrings, and I need to detect and extract these substrings whenever they show up. Fun times.

Hi everyone,I wanted to share some feedback regarding the new Airtable design.The new interface feels less comfortable to use, mainly because of the extensive use of bright colors and white across most of the page, unlike before. It feels tiring on the eyes during long work sessions.Also, I noticed that the sidebar can no longer be resized, which reduces the flexibility we previously had.Is there any way to switch back to the old interface, or at least adjust the colors and sidebar size to make it more comfortable?Thank you.

Hello,I made a CRM with interfaces that my company uses (all mobile). There must have been an update because the UI looks different. The primary concern is that when someone tries to comment on a record within their interface, it says “an error occurred” , backs out of the record to the interface, and then when you go back in to the record to click comments there is no comment. I nor anyone else at the company have touched the CRM and it was working perfectly up until this “update” - Also there are a few other issues that have popped up. Is there an explanation or a possible fix to this?

Hi everyone,I’m building my own CRM and want to filter for e-mail domains and create company records based on it. But I do not want to create company records for typical free e-mail-providers like gmx, web or gmail. That’s why I want to filter before running the automation. Can I input more than 1 value into the conditioning “does not contain”? And if so, how? I tried putting a comma inbetween the options but that did not work. And I do not want to setup a condition per domain that should not be included.Thanks for your help!RegardsJonas 

I got back from vacation and opened my airtable mac desktop app and it looks really different. I’m having an issue with the bottom of my screen. I have lost the left to right toggle bar so I cannot move between columns in a view. The bottom of the entire screen looks cut off. I have tried everything - deleting and reuploading the app, restarting my computer (x 2), zoom in, zoom out, full screen… nothing has worked. Does anyone know how to fix this issue as I am currently unable to work on the bases due to this? Also anyone know how I can get the older version back? Is that possible? When I go to a base, I see I know have “omni” as an AI helper and when I go to the my account it says my appearance is “beta”.  I really need help figuring this out. Thanks, Katie

How can I accomplish the following: In a form I want to dynamically alter the choices available in Field B when a certain option is chosen in Field A. E.G Field A could be a single select list of countries Field B could be a single select list of states (All states in all countries) When a specific country is selected in field A, a corresponding subset of options is available to select in field B.

Hi - I am new to Airtable and am looking to create a form that can only be completed by personnel during business hours ie: 9-5pm on Weekdays. Is there a way to automate these date parameters within Airtable? Thanks!

Can anyone tell me if there’s a way to perform web scrapping on Airtable and fetch changes related to the tickets? For example, I change the status of my ticket to In-Progress from To-Do, I need a custom scraper method that would parse the data and store it into my database. I am using Node.js and puppeteer. 

Hi All, Struggling to get the following functionality into a base and hoping you can help a novice here. We are attempting to use Airtable to track & visualise AWS logs for interactions with our service. I the graph above I have outlined a rough schematic on what we are aiming to achieve however we are running into issues with tracking on a daily basis. I’m not sure how to structure our base so that we can gain the ability filter by day, see which products were trending, measure performance based on view count and feed that back to the client’s tag. Ideally we want to enable our clients to change a date field and see the product list re-order as such, with views, revenue etc following. We can populate the records via an API, we are just struggling with the base design.

I'm running a handful of automations with Zapier and am now getting a 429 error for too many requests.I've turn off EVERY automation related to AirTable. Nothing has run for 4 days. But I'm still getting 429 errors, despite AirTable docs saying to wait 30 seconds. Any way to reset this? Or anywhere in AirTable to see a log of API requests so I can figure out what might still be hitting as an API request?

I have a single table with 2 varying date formats, one that is in date format (i.e. 6/30/2025) and another one with single select (i.e. 2025). I’m trying to figure out a way to link the two together, that way when I update the actual date, the year updates accordingly. A lot of times we have multiple people working on the same table, and they update the date column, but not the year. Simplifying this to where the year updates automatically would allow us to keep things consistent. Any help would be greatly appreciated! 

I am trying to create an automation that will send a personalized email to a list of recipients. I have a record that triggers automation when matches conditions.I have several records linked to one field of the triggering record that link to the recipients table, where email addresses are stored.I use Find Records to obtain a list of names and email addresses from a linked records.I want to iterate sending Gmail to each of the addresses individually, addressing the person by name and sending the message only to one person at a time.If that is possible, how do I use the input source data in the To: field and in the email body to address one single person - not the list of them at once.If I do not use Find Records to create the input list, then I can only use ID and Name from the linked records and can not pull out their emails from the table where those recipient names, emails and other data are stored, leaving me with useless set of

I have a working formula in my table to calculate the job duration from "job start" to "job end". I am trying to use the same formula to calculate a job response time from "Job Creation date" to "Job start". The formula is as follows:CONCATENATE(FLOOR(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes') / 60), ":",RIGHT("00" & MOD(DATETIME_DIFF({Job Start}, {Job Creation Date}, 'minutes'), 60), 2))However, this doesn't seem to be working as I have a job created date of 20/06/2025 13:00 and a job start of 20/06/2025 13:08 and the result it is giving me is 0:52 - I cannot seem to get this formula to give me the result of 0:08 which is what the actual result should be.My job duration formula works exactly the same way and gives me the correct answer. Job Duration formula is:CONCATENATE(FLOOR(DATETIME_DIFF({Job End}, {Job Start}, 'minutes') / 60), ":",RIGHT("00" & MOD(DATETIME_DIFF({Job End}, {Job St

I can’t access my bases. When i try, I get “An error has occurred, Refresh the page” and when I click on the provided “contact us” link, a very general page opens without contact options. Now that page is not accessible and results in a 504 error. The “error has occurred” message is accompanied by an error code of  pgluwBBDyL62GtnawThere aren’t any other ways to check status of Airtable, and this is directly affecting my businesses day to day operations. What can I do?Thanks.

I’m using airtable as a project management tool amongst other things in my business. It’d be really great to have the time in a date field default to 5:00PM (EOD) for every date entered instead of the current default which is the current time. Is there a way to do this other than using a formula as I’d really like to use the new timeline feature which doesn’t seem to support formulas. Thanks for the help!

I have a requirement to delete all records from my Airtable base. Currently the documentation says I can delete only upto 10 records from a single request. Is it possible to delete all records at a time (Instead of sending multiple URL’s with 10 records id’s each)?

HiCan I get some advice on a simple Swimlane Application or tool for a beginner, I have been using sheets of paper up to now, but need something to help with a workflow that is a little bit more complicated with more stake holders.I have created a list of tasks in a google sheet, assigned stake holders, and grouped tasks for an Aircraft Maintenance Inspection input to a Maintenance Repair Organization (MRO), Pre Maintenance Input tasks, Arrival tasks, During Maintenance Tasks, Departure Tasks and Post Maintenance Tasks, I now need something to sort them out into swim lanes.

Hello!We have been using Airtable to great success as part of our curatorial process (choosing puppet theater productions from around the world to appear in our annual festival.) Now we would like to use Airtable for other processes like - assessing financial feasibility of each show, documenting production needs for shows that will be appearing in the festival, and archiving information for shows that have appeared in the festival. We also have many venues, many artists, and many countries that the artists are from and we want to track all of that easily as well. We often use forms to get info from artists directly into the Base.  The way I am planning on doing it is with - 1 Base with 4 Tables (Shows, Venues, Artists, Countries), and the Shows table has over 100 fields that are used for various stages of the workflow. And I plan on making lots of views so that people at various stages of the process only have to see the data they need.  (I had or

I want to be able to count the total amount of times all “jobs” has had all “job type”. Example: Job - “Contact Customer” is Job Type - “Enquiring”. If we get a hit the type will change from “enquiring” to “prototype” however I want to log that is was an enquiry permanently and count how many total “enquiring” we have had. Then I will be able to track on a graph how many “enquiring” has converted into sales or failures. ​Here are my two linked tables. I have set up previously a counter to +1 every time the record “enquiring” had updated however my problem lies with when the job changed type it will still +1 on removal also. Basically I want “If

In my setup, each of my clients has their own base and interface. They can submit support tickets through their interface, and those tickets feed into a synced table in my team base. I just got my 21st client and it says I cannot add any more sync sources to my support ticket table.I have the support tickets going to a second support ticket table right now, but our support team doesn’t get them in their support ticket feed. I thought maybe I could create an automation that copies the support tickets from the second table into the original support ticket table, but that won’t work because I can’t create an automation to create a record in a table synced to another source. I thought about creating a new base just for support tickets and then syncing that back to my Team Base, but then my team can’t edit the records once they get to the team base.  Is there another way to create a table that syncs all of my clients’ support tickets into one table in my team

So I have discovered that automating a PDF into an attachment field is not possible from page designer at the moment. I was curious if anyone has found a way to view their page designer block in an interface? If not I will have to go back to the "data" side of the base and move it over to an attachment field and then go back into the interface. I think if I could just view the page designer in an interface I could screenshot the page and drop it into an attachment field without leaving the interface.

Hello! We encountered a number of systematic errors when accessing our Airtable databases inside Make (former Integromat) scenarios via APIWhen accessing an Airtable module in a Make scenario , Airtable consistently throws one of two errors:1) Error 4292) The operation timed outBecause of this, all our Make scenarios automatically stop and we experience great difficulties. Re-running the scenario results in similar errors.Please help fix this issue.The screenshots with errors are attachedThank you in advance

Hi. So the only way I can read-only share an interface with an external user is through Pro or Enterprise plans? Also is there a way to automate the sending of an interface dashboard for updates weekly, monthly, etc?