Ask the Community

I could really use some help!I want my formula to return the correct Ship Deadline taking into consideration the time the order was submitted. If it came in before 4:00 pm on a weekday, it needs to ship the next day. If it came in after 4:00 pm on a weekday, it needs to ship in 2 weekdays.This screenshot shows that order 5014021 came in at 5:15 pm correctly shows it needs to ship 2 weekdays later. But for some reason, order 5014020 that came in at 7:15 pm on the same date is showing it needs to ship in 3 days instead.I can’t for the life of me figure out what I am doing wrong. Formulas are not my strong suit so I use AI to help write them. Any advice here would be very much appreciated. It will be so awesome if I can get this to work with anyone’s help!My formula:IF({Store Name} = "Retail",IF(

HelloI’m currently working on a Production Planning base, which is essentially a way for us to communicate with factories on the projected production they can expect from us for the forthcoming months. Currently there are two sets of data:Projected Units  Quantity attached to a “Launch” or a “Deal”.  Confirmed Units. Quantity of confirmed units which have Purchase Orders attached As an example, we have a deal across “P6 & P7” (period/phase) with a customer and projected around 500k units. The problem is that the factory is not going to produce all 500k units at the same time and this deal stretches over a period of time - which based on the customers sales calendar is Feb-Mar-Apr. That is their sales window, so we need to work backwards around 10 weeks for shipping and then an additional 30 days for production.I’m currently trying to figure out the best way to disperse the 500k

Today I noticed an issue with Lookup values—Airtable formulas are not recognizing them in conditions. Is anyone else experiencing the same problem?

Hello Community,Is there any way to update the two fields from the interface when I click an button using form or some other way. Current Problem:I have an automation which triggers on record update. My table as two date time fields: Start Time and End Time. And as you might know we cant enter date and time together in date-time field in Airtable. So when I set both of them it consumes 4 runs of the automation which is not efficient.Solution I am looking for:We would be mainly creating tasks from interface like this Now I dont want to have the Start Time and End Time as editable fields because then the above problem will be posed again. Is there any way where when I click the Update button it askes for Start Time and End Time and then it gets updated on airtable upon confirmatio

Hi,I have workspaces and bases created where as a user I am configured with “Creator” permissions. I have created a personal access token (PAT) and have applied ALL available read permissions and have set the scope to all resources. When I run for example a “list bases” API call, I get a successful response (code 200), however I get an empty list returned like it doesn’t see any of the bases I have created. From my perspective I have given all necessary permissions across the user and PAT, but I still can’t get any bases to come back via API. Any suggestions on something I might be missing or how to further troubleshoot? Thanks!

I would like to add a logo to an Invoice Interface .... but cannot see the option to add an Image element... I am on the free plan. Help please.

Hi everyone 👋I’m building an Airtable base to track and analyze daily puzzles from the NYT Letter Boxed game by The New York Times, and I’d love some advice on optimizing my structure and automations.Here’s what I’m currently managing in my base: Daily puzzle date The 12-letter grid (grouped by sides) Valid solution words Two-word solutions (minimum solve goal) My solve time Community solutions collected from different sources Difficulty level (manual tag for now) What I’m Trying to Improve: Better relational structure Right now, I have one main table for daily puzzles and another for words/solutions. I’m using linked records, but I’m not sure if I should normalize further (e.g., separate table for individual words across multiple days). Automation i

Hello all.I’m wanting to run an automation that will create x number of new records in a table, where x is a number entered into a field (on another table).So someone wants 5 new records, the enter 5 into the field, the automation runs 5 times.I’ve seen this: But not entirely sure I understand how to implement this!Help muchly appreciated.

Hi Community, I have created a form, with a number of single select fields. When you got to enter, a blank field appear above the single select options - you can click on this, but it is not showing in the field in the back end. There are two options there, but the user end you can select a third non-existent option?The single selects are required fields, and the form has existed for a while without these glitches. Any tips welcome - though FYI, scripting (which the Airtbale bot told me to do) is a bit beyond my capabilitiesThanks 

Hi AirtabliansI have a date column which I have set to DD/MM/YYYY . . when i try to cut or import data into it sometimes it works, sometimes it doesnt, i have realised that even though I have set the field explicitly as DD/MM/YYYY format like most of the known world, it still wants in input in MM/DD/YYYY then it represents that back in the format I want to see it i.This is causing havoc with automations.I am guessing that there is a central “what format is the date in this entire table/workspace in” setting but I cant find it? My date settings field input still wanting me to enter in it appears this is why i cant

I am currently working with Airtable Interfaces and noticed that the Label component provides only basic formatting options such as Bold, Italic, and Underline. In many dashboard scenarios, we require more advanced capabilities such as: Adding dynamic field values inside the label Including conditional formatting Displaying additional contextual information Adding icons or visual indicators Supporting richer text formatting or layout control At present, the Label appears to be static and limited in customization.For reporting dashboards and operational monitoring use cases, enhanced label flexibility would significantly improve clarity and user experience.Is there any current workaround to achieve this?If not, would this enhancement be considered in the future roadmap?  For the Reference I have just a

All records in the timeline have a WBS code, for example 1.17.2, and also a zero-padded version like 001.017.002. In a grid view this allows clean hierarchical sorting without any issues.However, in the timeline view the records are still arranged primarily by start date. As shown in the screenshot, the configured sort on the WBS Sort field is not reflected in the vertical order.Is there any way to force the timeline to display records strictly according to the hierarchical WBS order instead of by start date?

I recently got a new Ipad to use when referencing my Airtable database. I noticed that a number of data entries. were missing. I cleaned that up a best as I could. Today I saw that this was still happening between the old IPad and the new one. I cleaned that up, them login to the database with my laptop, and it is missing everything I put it today. Up until recently if I put something in on the IPad it was immediately available on the laptop. I refreshed, relogged in. I’m not sure what is going on.

I have an interface that I use to visualize key data for our clients. There’s a record picker at the top where the client name can be selected. However, we have some clients that fall under a larger parent company, and for those I’d like to aggregate their data into 1 dashboard per parent org.I tried to create a version of the interface in a dashboard layout, but when I do and create a new group from the Clients table where most of the data is stored, it won’t let me create a filter based on the client name (only other fields in the client table show as options).Please help! Has anyone else encountered this? Have you figured out solutions/workarounds?

Hi ThereWe are a UK company using Airtable to manage / power all areas of our business.We absolutely love the product but are becoming a little nervous with downtime incidents.This is because our companies workforce is simply paralysed without it.We would like to implement a basic form of 3rd party backup / restore service.We’ve just setup an account with On2Air to evaluate their offering.Appreciate there’s a bunch of previous posts on this topic but would appreciate links to any recent services or with what you may be using successfully. Thank you for your help in advance. 🙏 

Is it possible to create an automation that sends new records created at the end of each day? Each Record would have multiple sub records and each sub records would have a photo as one of the fields. I would like the email to display the Record and sub records with the photos attached so that an email recipient who doesn’t have access to the Airtable database can view the photos. Maybe there is another way to do that without creating attachments? Can this even be done?

Hello all Have a script that creates new records in a table and then populates select fields in these newly created records with values from previous values. Works good, but I am interested in adding a new conditional argument that will do the following: IF: “Previous Assessment Status" is any value other than “First Assessment" or “Not Assessed";THEN: “Current Assessment Status" should be the value of “Previous Assessed";ELSE: the value of “Current Assessment Status" should be “Not Assesed" Hoping someone can help with the structure of the conditional logic. Script is below: let {foundRecordNames, foundRecordDate, linkedRecordID, valStartupID, prevStatus} = input.config()//Set the table to create the records inlet table = base.getTable('TRK: 360° ASSESSMENT')let recordsToCreate = new Array; for (let i = 0; i < foundRecordNames.length; i++){    recordsToCreate.push({

Airtable is down again. 7:20am Australia time now and it’s been down for over 90 mins, with no status update posted in 70 minutes since the last one saying ‘we’re working on it’. Our business is just at a standstill - I can’t even log in to find any of out client’s data to call them…. I doubt I’m alone. Not having any kind of update for over an hour is unacceptable when businesses need to rely on this service. I get that things go down, i get there are outages - but the communication surrounding such issues from Airtable is abysmal. This kind of outage during business hours costs us thousands of dollars an hour and I can’t help but feel the support/communication during these times needs massive improvement. 

I deleted and redownloaded the app, didn’t help. 

Hey allI have been losing my mind over the last 5 hours.I have a trigger when a record matches conditions to see if some fields are not empty.Then I have a conditional logic step that checks to see what data is in those fields and then execute if they are true.If it does execute, I find a bunch of records. And then I run a nested Repeat for each using the list from the find records step.In the repeat loop, I am going to create a new record. But...none of the data from teh current item is getting passed into the create records step.The weird thing is the preview shows there is data coming in...but the create record step, or a script step because I tried that too, is just not getting the data from the Current Item.Here is my automationHere you can see the da

I cant load any of my Airtable Page.Can anyone help on this please?

am currently experiencing an issue where Airtable is not working on both the mobile application and the

For everyone desperately waiting for Airtable to come back up, like me 😭, here is Airtable’s site for keeping up with the status. You can also subscribe and they will email you updates. Airtable Statushttps://status.airtable.com/#

Airtable web is not working in El Salvador. Does anyone else have this problem too? 

Bonjour, je n’arrive pas à ouvrir mes bases Airtable ?! Quelqu’un sais ce qui ce passe ?Merci d’avanceGabirel