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
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!
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.
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
My AirTable implementation deals with scheduling and staffing of courses for a university. We have a table for Professors, a table for Courses, and a table for Offerings which marries the two together with each record representing a single staffed course-section that students will ultimately be able to register for.Of note: currently our professors do not have AirTable access. Having them create accounts is currently not an option, unfortunately. Additionally, our plan does not include AirTable Portals.When we initially link professors to offerings, we need to send emails to have the professor accept or decline the position. We currently intend to do this via a Fillout form that will allow them to edit a single select field with accept/decline as the options (the “Accepted?” field below). Our issue is with the fact that professors teach several offerings every term, so sending one email for every offering would be cumbersome. Instead, we want to find a way to send a single email to eac
For the love of all that is holy, WHY!?In this most recent UI update, Airtable seems to have randomly increased the margin width on the Interface side pages, messing up many of my pages and making it much harder to fit three elements per line in many circumstances.Example 1:The lines in each section of this page used to fit the width exactly.Example 2:The Action Menu dropdown was to the right of the Status field. Now it is pushed to another line.It is no longer possible to have a section division, and fit three total elements abreast. I hope to god this is a bug and not an intentional choice...
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?
Hi all,Regarding the new UI changes, I really dont care very much about new buttons disposition, but changes in appearence colouring have been a downgrade in my PoV.The new Light appearance is extremely Light, and the Beta Dark mode, in my POV, is currently not good enough (contrasts, especially with coloured dropdowns are not good yet).Boxes marked in green used to be filled in predetermined color (in my case, green), but now it has been changed all to white. Couldn’t find a way to change that with the current UI changes.If someone knows how to, please let me know. Thanks!
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.”
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'd like to draft a prompt for an ai field to carry out actions on a specific field in a base but this field may on occasions be blank. I get a “Required field is empty.” error. How do I structure my prompt so that the ai field ignores this field if it's blank but carries out actions on it if data is present? Thanks
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.
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.
