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
Hello! Recently took over Airtable and am getting familiar with it. I set up an easy lookup between linked tables, but am having difficulty with a little more complex scenario. I have two tables that are linked, let’s call them ‘Operations’ and ‘Account Management’.Each table has fields that are: Partner, Territory and Business Line.I’m trying to set up a lookup in the Operations Table, where if all three of the values match in the linked tables (match on Partner, Territory & Business Line) - then return the value in the ‘Account Manager’ field which is stored in the Account Management table. Assuming this is possible, any ideas on the easiest way?
Hello! I’m trying to create an automation that allows me to add someone to a collaborator field without replacing any data that is already in the field. Is this possible? That is, if 3 people are already in the collaborator field and I want to add a fourth via an automation, can the fourth be added without removing the other 3 that are already in the field?
I have a single select field with options A, B, C. How can I limit a user’s ability to select an option twice? Once an option is selected they should not be able to select the same option again.
spreadsheets Hi, I’m trying to recreate the structure of the attached spreadsheet in Airtable, but I'm running into trouble because each checklist item needs a different field type. I'm a PM, and I'm building a checklist that I want to go through once per project. Each checklist item requires a different field type. After discussing with ChatGPT, I was told that if there are 10 field types, I should create 10 separate fields and input each item only into its corresponding field type. But this checklist isn't just for me — about 20 team members will need to fill it out frequently. If it's structured this way, it becomes very inconvenient for everyone to use. What would be the best way to structure this kind of checklist in Airtable?
I’m very new to Airtable, here’s what I’m trying to achieve. I have a table named Inventory: Name, Category, Price.A table named Project: Address, inspection date, images, Reno Estimate. Ideal process: From the Project I want to select items (30-50 items) (ideally a multiplier field. eg: 1x, 2x etc) from the Inventory list. (Or even just a checkbox) So for the Project I’ve selected what Inventory items I’ll need and the total of their cost.Hope that makes sense.
The back end of one of our products is built on Airtable. Its been runing fine, but in the last couple of months (since May 18th) it hasn't been working anymore. Unfortunately we didn't discover this until now, and this means a key product in our whole business is broken/down.Did airtable change its scripting system to change how attachment fields work? The images being attached work, the script appears to successfully run, logs are totally okay, just the images don't get attached at the end.More info:We wrote an airtable script that, based on data, attaches a photo to the airtable. The script stopped working recently. It gets triggered, appears to run, logs look fine, but images aren't attached. It was working before, but stopped working around may. What do you think the issue is?We’ve emailed Airtable support but haven’t heard back yet :( let table = base.getTable('Raw Data');let inputConfig = input.config();let recordNumber = inputConfig.RecordNumberAutomation; // Replace with actua
I have an Automation that updates a Multi-Select field in a different table. When the update occurs it over writes what is currently in that field. Each name has a different color. I want to augment, or add to the existing data in the Multi-Select field not over-write it. Not sure how to approach the problem within Automation. For Example, a field of user names, each name is in a color bubble separated with a space. Initially the field is updated with the name “John”. A second update to the field with the name of “Tom”. The resultI was expecting is : “John Tom”, or “John, Tom” each name in a different color bubble, but what I get is “Tom” and an empty color bubble. Any suggestions.
Hi All, Our team is having trouble with the cells running into the other pages when printed. This doesn’t affect everyone, just some people which makes me think it might be a setting issues. Any thoughts?“So the problem of the grid lines not closing between pages is still there, but it looks less messy than having long columns of text and pics in the body of the report. I tried using the Page Designer Extension or an outside program as suggested by others, but they require you to basically restart the whole template.”
Hi useful people, Our Airtable database contains multiple services with attendance data. We also log the individual names of each attendee. Airtable can easily gather the total about of attendees across a period of time - my question is, how does Airtable gather the individual data? For example, Airtable may tell us that there were 1000 attendees across a calendar year, but how many many of those are the same people? What we’re looking for is the amount of individuals who have accessed the service in the calendar year, not a total attendance tally. I hope that makes sense… thank you in advance.
Hi I’m having trouble figuring out how to properly set up a kanban.This is for contractor scheduling. I have the kaban connected to a table source called Repair Jobs. It’s then stacking fields by Assigned Contractor, with some visible fields, coloured and sorted by status. The purpose is to have an “empty” column where jobs can be dragged to contractor columns, and assigned to those contractors. I want to be able to have a drop down select for different days of the week, or a date picker. That way the admin can select “Monday”, see all the unassigned jobs, and fill up a contractors current day. In 80% of situations they would be looking at it in the context of “today”, but would also want to move forward in time to check future days. The problem with this one, is that if I use the drop down filters for “Monday”, not only is it not correctly filtering to Mondays but it makes all the columns disappear. I have “Hide empty stacks” deselected because we want all the stacks to remain visible
I am new to airtable and am having trouble. I have a cattle ranch and am working on a database to manage their reproduction. I would like to calculate each cows conception rate based on the number of times she has become pregnant vervus the total number of opportunities she has mated. For example, if she has been with a bull 10 times and has become pregnant 7 times in her lifetime, then her conception rate is 70%.I have each cows breeding records in the data. I also have a field titled “pregnancy status.” If i use rollup for this field with:Source= Cattle ID#Cattle field to rollup= Pregnancy StatusPregnancy status field is: pregnant or non-pregnantHow would I create a formula that would look up the pregnancy status for each mating and then calculate the percentage pregnant for the cow’s lifetime? Thank you so much for any help you can give me!
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.
