Ask the Community

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?

Hi. I’m not a coder and I’ve only been using Airtable for a few months. I’ve mostly used chatgpt when I’ve come up against something I can’t figure out on my own (which is mostly anything that requires coding) and it’s mostly done OK with a little back and forth. For my current problem it keeps giving me bad info so I’m turning to you all. I’m building a database for my company to track various data points about the projects we manage. I have a table called ProjectsList for this. For each project, we get many associated elements and I try to capture various data points on each element. This is done in ElementLog table. When we receive a schedule for a project, I log ScheduleStart and ScheduleEnd. In a normal world, every schedule would be a 5-day workweek and have the same holiday days off, etc. and it would be easy to set up fields that count work days/weeks between schedules, can do countdowns from today to start date, or tally days remaining in the schedule if we’re within the sched

Hello everyone,I'm experiencing an issue with one of my Airtable bases and a Google Drive synchronization. For the past few days, a specific table that is linked to a Google Drive folder has stopped syncing. I haven't made any changes to the base, the Google Drive folder, or the synchronization settings.The error message I'm receiving is: "Unable to sync new data."I've already tried checking the connection to Google Drive and restarting Airtable, but the issue persists. Has anyone encountered this error before or have any suggestions on how to resolve it? Any help would be greatly appreciated!Thanks in advance."

I’d like to use AT to create a Directory of our 400+ members.  I’ve set up the fields + form for Members to submit their details. I would like to also use this for our internal team - so they can record notes of all calls with each member and other details.  I understand how to create hidden fields that the members don’t see, however I’m unclear on the best way to create the “member notes” piece -- should I link to a Member Notes document on our Google Drive or can I do this all inside of AT?   We will be asking Members to complete the profiles and for those members who do not, we will add them but keep their profile private.  I’m unclear how to do this also. I’m also unsure how to set up my team members to be able to access the directory backend to add notes.  I’m on the free version and hoping to not require an upgrade.  Any help is welcome!  I am not a ‘techy” but feel confident it should be relatively easy to do.  Thank you.

pro back up vs on2air. Which is the best and safest way to back up airtable data

Hi all - I am looking to see if anyone has information on the safety of using Pro Backup as their main backup program for Airtable. Our company is needing a backup for our system and this seems to be the best one we've landed on, but we can't get a straight forward answer from Airtable on if they feel like it is a secure company to work with. If you or your team uses Pro Backup, I'd love to hear about your experience and if you feel like your data has stayed safe. If you don't have experience with Pro Backup but have another backup program/system you recommend, that would be helpful as well. Thank you!

Hi,I have made a mistake in one of my automation, and what was supposed to run 1-2 times per week ran over 20 thousand times overnight. Luckily this happened on May 31st, so I did not need to wait for my quota to reset. However this made me wonder if there is some kind of safeguard feature in Airtable that would, for example, maximise the number of daily runs for each automation?

Tengo  una duda pudo con alguna automatización llevarme datos de una base a otra ?