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
Hi, I want to track employee annual leave via Airtable. They’ll input Date From & Date To (including time). There will be individual calculation fields for each leave type (e.g sick, annual leave etc) and an approval status. So this formula would be wrapped in IF conditions; IF Type = ‘Annual Leave” and Status = “Approved” this calculation will apply. Formula needs toonly calculate weekdays (ignore weekends) understand 1 day = 7.8 hours only needs to count hours if the time differs between date from & date to fields. Understand working hours are 8:30-5pm (time zones differ) So outputs for the following would be;17 June 2025 3:00pm → 17 June 2025 5:00pm → 2.017 June 2025 3:00pm → 18 June 2025 3:00pm → 7.817 June 2025 3:00pm → 18 June 2025 5:00pm → 9.817 June 2025 3:00pm → 24 June 2025 3:00pm → 46.8 I’m open to doing this more simply via the base design if the formula is too difficult to write (e.g having the employee select from a drop down to say ‘full days
Hi,I’m newbie so I really need help on changing or renaming the records of my table. As far as I know, you can name the records while creating a table, but whatif I already have a table, what should I do to changing the name of my records?
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.
Hello, I have a main base and several project bases that have a two-way sync with this main base. In these project bases, I receive data from my main base, but also have columns specific to these project which are freely editable by the teams.I would like my columns from the main base (the sync one) to be in editor access to the teams (values are editable, but not the column), and the non-sync columns to be in creator access to the teams. How can I do that ? Thanks !Agnès
I am perplexed by the labeling in Airtable Calendars. In the attached screen grab, I have two projects in a single calendar, separated by color. Great. However, it does not show the label of the fields I have associated with dates, even though it seems like there is ample room. So great, let me enable the labels I want. Except it doesn’t show the labels, it shows the date, but instead of just including the date on the specific entry, it puts it on ALL entries. Very perplexing. Why would I want to show the date of one entry on a completely different entry that falls on a different date? This makes no sense and can not imagine a case where this would be useful. Why won’t just show me the label that is already there on a specific date? Is there away to show the whole label on a given entry? In both the Interface and Calendar view I see this and can see know way to show the entire label.
Hi Airtable community, I am new to Airtable and have landed a major Interior Design project that I hope to use this resource to organize. There are a number of needs that I have that I believe are outside of my beginner level to set up properly. I’m hoping someone out there can help me. Another user @caroline_bolt posted about this very thing but I don’t see any advice from the community. Wondering if Caroline ever got it sorted?! This project is a 5,000 sq. ft. home so I need to track a lot. Rooms and what tasks need to be completed for each *Design Implementation: What phase, dimensions, etc. Purchasing: Supplier, Supplier quotes, Retail price, designer discount, sell price, production timelines, estimated delivery dates, etc. *Existing pieces: If we are refinishing / reupholstering. Tasks to be applied *so much more. *Tasks to be completed Any other interior design firms out there who are willing to share their base?? If not, anyone open to sharing a good starting point? I didn’t
When using a form, I want to offer specific choices for students to choose from, but I also want to offer them to option to fill in some option that we haven’t thought of. (As in, “how did you hear about us? Internet search, friend, Facebook, other- tell us how”) Thanks Linda
The left sidebar, which contains nothing but the new LLM button, can no longer be collapsed. In an interface that is essentially a series of excel-like rows and tables, every inch of my screen is valuable, especially on a laptop screen. This bar of empty space actively slows down my workflow as it increases the amount of scrolling sideways I have to do, and it also throws off my muscle memory by moving all of the tabs over, and pushes the actual useful information on the left side of the screen away from the edge of the screen where I am used to finding it. Please add an option to move the LLM button to the top right, next to the base history and contact sales buttons, where there is a ton of empty space already. Or, add an option to minimize the sidebar, like we used to be able to. Or better yet, give us an option to hide the LLM button entirely if we are not interested in using it. I know every CEO believes that LLMs are the next big thing that must be included in any technology, but
Is there a script that can initiate printing of a record designed in the printing extension from an interface? As in, Print This Record?
Does anyone know how to get Airtable to go back to a previous look. The new look with the status bar on the left has made airtable more difficult to work with. Left Bar down the entire window instead of across the top.
I am importing three different reports into the same table. One report’s DOB field provides the date as we wish it to appear, MM/DD/YYYY. The other two reports provide a DOB format of DD-MMM-YY. I am using a formula to convert the DD-MMM-YY format into MM/DD/YYYY and then using an automation to move the DOB Calculation into the DOB field. Some of the converted dates are future years. The formula correctly converted 23-Sep-97 into 9/23/1997, but 29-Jan-56 became 1/29/2056. How do I get the formula to create DOBs in the correct century?Some years convert correctly, others not so much.Current formula.
Hi! Do you know if it’s possible to add the text generated for an AI field to an email automation? Everything seems fine in the other fields but not in the AI generarted. I tried copying it with a formula but it is not working.
Hello!In the data layer, I can no longer find how to toggle on the setting to view other user’s Personal Views. There used to be a gear icon to the right of “Find a View”, however, I can no longer find it or figure out how to toggle this setting on/off.Can someone please help?Thanks!Sarah
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.