Ask the Community

I unable to add a new record by searching and linking to employee by searching for first name. I have two tables. A occurrence table, and employee table.This inputs into occurrence table. Only link between occurrence and employee table is employee ID. Any recommendations?   

I am experiencing issues with  pages that i created in the extensions.  Issue 1. i have created buttons to load different pages in extensions , and when the extensions are loaded its not scrolling to the right option. which was working as of 2 days ago. Issue 2.  once i try ti print these pages the print preview is showing blank pages and when i try to print its also printing blank. these issues had also started in the last 2 days.  I am using the Firefox browser on the air tables website. When i tried to use the Chrome browser the first page comes blanks. 

Hi all, I wanted to see if anyone had a troubleshoot for this error we get just on one particular computer terminal but no others. Refreshing the page as suggested does not solve the problem, it happens every time the person tries to submit a native Airtable form:  

I've created a summarization in excel that I want to replicate in airtable, I can't for the life of me figure out how to do it.I have a production operation for large machines. Here are the main steps: I pick up inventory on Date A, at a cost of X I predict I will sell the inventory on Date B, at a revenue of Y My data table is: Machine Build #, Date A, Cost X, Date B, Rev YI want to summarize a bunch of things on based on those dates, costs, and revenue.A. By week, how much am I going to spend buying inventory (sum of Cost X, by week based on Date A) B. By week, how much cash am I going to generate selling my inventory (sum of Rev Y, by week based on Date B) C. By week, how much inventory do I have (Sum of Cost X, based on Dates A and B)Any thoughts on how to do this??

Hola, tengo una una tabla con 2 hojas que alimento desde un formularioAhora necesito hacer una vista KABAN que me salgan todos los registros de cada hoja, pero no lo consigo, me hace agruparlos por un campo Que estoy haciendo mal

Is there a solution to sync Jira which is an on premise version NOT Jira Cloud. When in the office I have access to both Jira and Airtable which are behind firewalls. Are there any solutions maybe with MCP Browserbase or other type of way to extract data not via API but through the browser and sync with Airtable. 

Here’s my thinking. I like the simplicity of Airtable’s own “Export CSV” function. Data in a spreadsheet as a simple backup is all I am after. If “Export CSV” could be triggered via a script, the entire process could be automated. A new record could be the trigger to run this script. Does anyone know if this is even possible? Thank you!

Hi, I’m trying to roundup the following formula: ({GROUP PRICE}+({EXTRAS}*3))/3Where GROUP PRICE is the pricing for a group to which I add extras * by number of guests and then divide by 3 to obtain a price per person. The formula is working and in this case I obtain a pricing of 101.667€. I’m trying to roundup this number to 102€.Thanks

I have a database, which is extracted from our CRM. We sell and install equipment. There are two key dates, which are important: sign date (i.e. when we won the job) and install date.I have created two formula fields (‘Sign Month (fx)’ and ‘Install Month (fx)’) to give the month in YYYY-MM format. I then have an automation in place to copy these calculated fields into ‘Sign Month’ and ‘Install Month’, which are linked fields.Finally, I have created a Summary table where I would like to roll up various metrics by month (e.g. revenue).This is where I come unstuck and can’t figure out a way forward…I would like to see, for example, revenue by sign month and by install month. That way, I can summarise both our sales performance (what’s signed in a given month) as well as our operational performance (what we install in a given month).Where I’ve got to is I think I need to differentiate the months, perhaps with a prefix such as I-YYYY-MM for Install Month and S-YYYY-MM for Sign Month. I find

Everytime I start Airtable, I get the message ‘Sorry, the page you were looking for was not found’. Does anyone know how to get rid of that message? I do not know where I look for a non-existing page...

Hello, I have an airtable app that supports our HR and Finance teams.  As part of the build, I am looking to reference the employee ‘start date’ and ‘end date’ to determine how many days, or workdays that employee worked in a specified month (assume each month starts on the 1st and ends on the last day 30/31) Example fields:Start date: 01-10-25End date: 01-25-25Month Start: 01-01-25Month End: 01-31-25 The month start and ends fields could be done without referencing the fields if needed and handled within the calc using datetime parse/datetimeformat or the like. In many examples the end date of the employee will be after the month end but have kept the duration short for this example.In theory, a simple formula like the below should work, but I’ve tried so many different options of doing this and the formulas keep returning a 0 or error. The fields above are all calculated as date fields.WORKDAY_DIFF( MAX({Month Start}, {Start date}), MIN({Month End}, {End date}))I’d expect a working f

The customer > order > product linking example use case is clear to me.What’s less clear is having 12 tables of similar data for 12 clients and how to link them into a master table.The 12 clients share 8 core fields including a unique identifier for records. Each client has 4-6 fields unique to their business. Those 48+ unique fields make one table cluttered, and in my opinion, necessitate 12 tables linked into a master table. That way, each client can have their particularities, but I can have a master table, master calendar, insight into potential staffing issues, etc.How do I set up a master table to pull all records (and 8 core fields) from 12 tables that all share the same unique identifier format?

Hello, I have a database with 2 tables. The first one is the list of invoices (Airtable - Grid view), and the second one is for all the invoice lines (https://airtable.com/shr7SIHWwTSG0oM9H). I want to create a form to add products in the second table. But first I need to create an entry in the first table (the invoice number) before I can add the items (table 2). I want to make the process simple, and not have 2 forms to fill in. Do you see a solution? The only solution I have found is to make a first form to add an invoice, and in the reply message it links to adding the rows (Form) but it is not very user friendly, and people can get confused. I don’t know if I have made myself clear, Thanks in advance to the community Guillaume

I have a field with multiple select options in a table. When I click the Approve field (checkbox), I want the data (the selected options) to be copied to a namesake field in another table. Currently, I have the namesake field in the 2nd table as a single line text and so it works. However, in the 2nd table, it does not appear as multi option data. The challenge is that I am running a marketplace app and I want to create a filter-based search option and single line data doesn’t work. There is a video posted in a previous question but that doesn’t solve my problem. I also tried to link the 2nd table’s field to the first but no luck. Would this be possible in the first place? As always, many many thanks for the tips. 

Hello everyone, I embedded the Airtable form into my website but the font size of the answers is too small. Can I make it bigger somehow? Thanks in advance

Hi If it’s doable, I’d like to solve this problem. For the sake of simplicity, there are two tables in the base: Projects and RFPs. In the Project stable, there’s a single select “Project Type”, with options “Project; RFP”. I would like a lookup field in the Projects table that’s only enabled when “Project Type” is “RFP” to look up the relevant record from the RFPs table. Can it be done?  

My base has a subtask column - I can an unlimited amount of subtasks I need to be able to have a dedicated status option for each subtask. I also need to allocate each subtask to a different user

Hi everyone!I’m working on a workflow in Airtable where I want to automatically generate rows in a second table (CostComponents) based on new or updated records in a first table (Employees).In my specific use case, I want to create a predefined set of rows depending on the “Resource Type” of an employee (“Existing employee”, “New hire”, or “Freelancer”). For example:    •    For “Existing employee” → generate 16 rows    •    For “New hire” → generate a different set of rows    •    For “Freelancer” → generate yet another set of rowsEach generated row has static fields like “Cost Component”, “FTE”, and other data pulled from the Employees record.I’m currently using Airtable Automations with “When record created” and “When record updated” triggers, combined with a Run script action. The script seems to run, but doesn’t create the rows. I’m curious:    •    Is this the best (or most scalable) approach?    •    Are there other ways to handle this kind of row-generation logic within Airtabl

I am running a scraper to fetch data into my Airtable. Sometimes, the Company name is in full; for example, International Business Machines.I want to batch convert (correct term?) them into IBM. I am half done with the automation -- When a Record Matches “International Business Machines” .But what comes thereafter is the challenge -- I assumed it should be Update Record but unable to input the “IBM” text. Any help would be greatly appreciated. thanks

I’m trying to use the SUBSTITUTE function to get rid of emojis so I can have a “clean” version of some fields my client want to have as downloadable in .CSV I need to have a formula with a bunch of substiutions, but I started from the very first and I get nothing but errors, formula atm looks like this:SUBSTITUTE({Respuesta Pregunta 1},'✅','')I realised the error has something to do with the type of field of {Respuesta Pregunta 1} as it is a lookup field, just for testing I created a single text field next to it, copy the data of the lookups to the new text field, applied the formula to the text field, and it works. So I’m suspecting SUBSTITUTE doesn’t work with lookups? Any ideas to work this out?

Hey Guys! Hoping everyone is well. I'm finding myself wanting to bulk-update records by a specific field and I'm wondering if this is possible? Does anyone know? Is there a script or anything? See the two fields? "Goes out to" and "Status"? Both are single select and currently I need to update each record individually which is time-consuming on some of our tables. They can have hundreds of records that need updating. What I would loooooove to be able to do is select multiple records and update the statuses on the selected records in one action. Anyone have a way to do this?

I’m creating an event registration form, and pulling in the event through a linked record, but the only field displayed in the form is the name of the event. Because I have multiple events with different dates / times and the same name, I’m wondering if there is a way to pull in additional information into the form for each event. Thanks! Clay

Hi all — every time I try to import a Google Sheet into Airtable, I get this error:"Can’t import from Google Sheets — Something is wrong with Google API."This happens regardless of which sheet I try. The sheet is shared properly and I'm logged in with the right Google account. Is this a known issue with the Google Sheets sync or a permissions problem? Would appreciate any tips on fixing or working around this (besides switching to Excel!).Thanks!

I have to put into place a secure Data base that I can generate a form from and when it's completed populates the Data base. I would like the feature where for that particular information I can generate a QR code, so if scanned the information associated with that form can be read. when scanning the QR code 2FA authentication is required. Is this possible in Airtable. If so could I have directions as to how to get this going. I want to try and do this myself if I fail I will ask for assistance or a developer to do it for me

I apologize- I feel like this is probably already asked and answered, but I’ve run out of search ideas. We have a form with lots of conditional logic- it’s being used as a call script. There are several places where folks may jump off and want to hit “Submit”- dead ends on the tree. Is there a way to do this?