Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Please excuse the long explanation..I have a spreadsheet showing some factories producing a number of products. For the sake of the example, let’s assume that the factories are the primary records and the products that they produce need to be split out in to a linked table.So the source spreadsheet looks like this:Factory City Country Product Acme Tools Denver USA Spanners Acme Tools Denver USA Screwdrivers Western Hardware Paris France Spanners China Supply Shanghai China Hammers China Supply Shanghai China Screwdrivers I can create and import this spreadsheet in as a new table called Factory.But I don’t want duplicates in the Factory table. I want to have a Products table that would look like this.Product Factory (linked) Spanners Acme Tools Western Hardware Screwdrivers Acme Tools China Supply Spanners Western Hardware Hammers China Supply This obviously works fine, and the Factory table would only have 1 row per f
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.
Hi all,I am desigining an interface and using newly released Portals add-on of Airtable to share the interface with guest users.While the login is working fine, the base name, notification and profile buttons are still visible on the interface. Ideally for whitelabelling, these options should be removed.Note: I am on Team plan
Hi all! I’m relatively new to anything beyond simple in Airtable, but I’m learning through trial and error. I’ve ran into a problem I can’t solve though (yet) and would greatly appreciate any and all help. When using the following formula i end up getting error messages. IF( {Kontroll intervall}="Varje vecka", DATEADD({Senast kontrollerad}, '7', 'days'), IF({Kontroll intervall}="Varannan vecka", DATEADD({Senast kontrollerad}, '14', 'Days'), IF({Kontroll intervall}="En gång i månaden", DATEADD({Senast kontrollerad}, '30', 'Days'), IF({Kontroll intervall}="Varannan månad", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="En gång per kvartal", DATEADD({Senast kontrollerad}, '120', 'Days'), IF({Kontroll intervall}="Ombyggnad, ej aktuell i nuläget", DATEADD({Senast kontrollerad}, '60', 'Days'), IF({Kontroll intervall}="Ej evenemangshemsida", DATEADD({Senast kontrollerad}, '365', 'Days'), IF({Kontroll intervall}="Behövs i
Anyone know if/how to change the default behavior of clicking Interfaces when in Data Mode. It defaults to design mode so I need to click Interfaces and then click Open. I could have sworn it took me straight to interfaces prior to the most recent UI changes.
hi, does anyone know how to copy a group of records. It's for selecting materials for our manufacturing business. If we have standard jobs we don't want to have to select the same group of items (records) repeatedly
I don’t want to be overly negative as I love Airtable, as do my clients. But can Airtable slow down in integrating new features without proper testing. In the past couple of weeks since developers integrated Interface/data layout into one in the home view, there have been so many bugs in the system. I am all for new integrating and love the direction the company is going. However, don’t be premature about it. Every time I am using Airtable now there are new bugs and I don’t have time to send Airtable developers feedback and examples... It’s hard to keep up (more a clients perspective) with new features, new layouts and new bugs. To the developers, just make sure your ready before publishing new layouts and features please 🙏
I tried posting this question previously but I don't see it posted, so apologies if it appears twice.I have a simple database with two tables, each of which has a few fields.I want to create an interface that shows different list views of one table based on different filter criteria chosen through tabs.I created an interface with eight tabs on one page and was able to configure the filter criteria for each tab. It works fine in the edit mode.When I preview or publish it, only five of the tabs are visible. I thought that it might be there's a limit on the number of tabs on any page, or the length of their names, however when I tried rearranging or renaming the tabs to shorten names the behavior was the same. Only the five originally visible tabs appear, whatever I name them and in whatever order I arrange them. The other three tabs are never visible.I then tried copying the page to another page in the same interface, so that I could experiment further without deleting my original work a
Hey everyone! I’m new to this platform and just getting started with Airtable. Looking forward to learning from you all and improving my workflow. Any tips for beginners are most welcome! 😊
Hey FolksCurious what techniques people are using to get data out of their agent fields. It’s easy to send data to Agents from fields, but as far as I understand it, Agents can’t currently return this data back out to other fields. So, let’s say I have an Agent extract the ‘date’ from a document, that data stays in the field output, and cannot be sent (using the UX) to a date field. I’m not seeing any documentation about this.My first thought would be to have the Agent output a JSON object, then use a formula in another field to get (e.g. REGEX_EXTRACT()) the data from the object.Anyone else exploring this solution?
Hi, I’m building a page to track hours — comparing what we’ve budgeted versus the actual hours spent. We’re tracking time in Harvest, and at the moment I’m manually entering that data to match it up, which means there’s no direct link between the two systems. We use the same standard phases for every project (example: B01-B09). Each time a client signs a fee proposal, I want to add these same phases to the new project and allocate the initial budgeted hours. In Excel, I’d simply copy and paste multiple rows, but in this system I can’t duplicate more than one row at a time, which is slowing things down.Ideally, I’d like to be able to duplicate all phases (B01-B09) and assign them to a new project in one go, then input the hours. I also update the actual hours weekly, so it needs to be easy to maintain. I’ve been exploring whether an interface with a button (plus an automation) could do this — so that with one click it would add all the phases for me — but I’m a bit stuck on how to set t
Hi Airtable Team,Last week, I received an invoice on the personal plan associated with my MVP plan. It seems that my plan was adjusted to a Team Plan, Monthly on June 25 and I was charged for the remainder of that month + the upcoming month. I haven’t seen any updates in this community that the free team plan with AI was being removed, so I wanted to confirm that was a mistake. Workspace ID is wspRhbYK4IzKW729u.
Hello everyone! For export and invoice purposes, I think it would be nice to be able to inherit the filter from an interface to a detail page or at least within the detail page to the buttons (for exporting).Right now when Month Link is set on a specific month, the visible list is changed but the button in the same frame ignores it! Would be so great if it would recognise a filter or the dropdown elements!Does someone has a workaround? I want to make it as easy as possible for the back-office to export a month of choice. Thanks in advance! This is what the detail page looks like:
In one of my first projects, I have a table with a multiselect field "names".Can I add a new column with some formula that shows the name that was last added or removed in the "names"-field ? (with automatic update for every change in that names-field)
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.
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.