Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
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 am using the Typeform integration and one question (single select) has 750 options. In Airtable: It is possible to massively add options to the single selection or multiple selection. Instead of paste it the 750 options one by one. thanks
I have a form that someone may fill out multiple times using the same email address. I want to use that email address to update the original record created with the new information (if it is new). Can someone guide me through the automation to do this?
The bases I create are labeled “External” (even after accepting my Organization's invite) and lack the same functionality as bases created by the Big Boss. Are there currently settings that ensure bases created by users within the organization are internal (and benefit from the functionality associated with our price plan)? Would changing my permissions level from “Creator” to “Owner” make a difference? I guess I’m confused that a user can belong to an organization, yet the bases they create do not. Put another way, in practice, every user other than the Big Boss is individually on the “free” plan and creates only stripped-down “External” bases. I'm told we're in the process of migrating from Teams to Business. Will that remedy this? It doesn't make sense to me that only one person has full functionality, regardless of number of users in the plan. I don't have access to the organization's settings. Are the ones with access simply overlooking something?I appreciate any clarity provided.
Hi Airtable folks, I’ve got this really fun bookkeeping base I’ve created, which I use in conjunction with Fintable.io (a way to push bank transactions into Airtable – highly recommend!). Since Fintable downloads the transaction names from my bank statements in all sorts of different ways depending on how the banks format them, I wanted to create a formula to extract the Vendor name from when I receive or send money through Zelle. The thing is that this can show up in a variety of ways:ZELLE FROM FIRSTNAME LASTNAME ON DATEZELLE TO FIRSTNAME LASTNAME ON DATEZelle Payment to FirstName LastNameZelle Payment from FirstName LastNameZelle Payment to FirstNameZelle Payment from FirstNameAnd so on… What I’m getting stuck on is how to combine two formulas I ended up creating: one that returns both the first name and last name of the person (but when there is no last name, returns some of the random extra characters after the first name), and one that returns only the first name, whether there
Hi, wonder if I can relate data in different workspaces. Or it will be completely separated?
Hello! I’m trying to make a templated onboarding document that we can easily update with information fed from Airtable. Here’s the direct use case (Integrations are generally off the table in a corporate security setting): Hire Roster (lives in Airtable, holds new hire data) Microsoft Word/GDoc/OneNote (whatever!) that is complete with specific fields waiting to be fed new hire data, will serve as new hires’ onboarding document. Is there a way to automate the process of filling out a document without manually doing it?
Hello all, We have recently implemented Airtable on our team to account for hours worked by employees. To gather the information, I created a form in which they answer at the end of every work-day to take into account the actual hours worked. These answers feed a database that groups every reply by week/employee. In the database, I created a column of “Work-day” which is the employee’s weekly hours divided by 5 business days. This way, when they answer the form, I would have the daily overtime and then it would be grouped weekly and it would give me the weekly overtime.However, the team is mainly composed by part-time workers and that’s where it becomes tricky. We don’t really enforce a fixed start/finish hour, so a person who has a contract of 18 hours/week, may work only 2 days one week and then 5 days the next week, picture below. What I would like for it to do, and that I wasn’t able to, is to calculate how much overtime (or time they didn’t work) they are doing per week, based of
Let me first preface these questions with I’m a vet tech not a computer programer/data person, and I’m only doing this for my hobby. I have these two PDF files that I would like to add to my air table to help me classify my model horse show string. I would like to put conditions on the drop down list so If I select one general breed or specific breed or class only a certain list comes up, Is this possible? What is the best way to do this? Thank you for your help- Sirena Breed Cross refBreed/show class reference
What are some good software options for automating generation of word docs using data from a record in Airtable? I would like to be able to trigger the automation in an Airtable interface (as opposed to an extension on the data side).
Hi my name is Jerry. I am not at all new to Airtable but my experience is not particularly broad. I built our Airtable base 8 or 9 years ago and haven’t done any development work on it since. I am not a programmer.My problem:I am creating a package receiving solution for our freight forwarding business. We receive packages, log information regarding that package and place it in the racks for future handling. I am looking for a way to easily add a photo to the package record during the receiving process.The process: A new record is created by scanning a preprinted, barcoded label which is then applied to the package. The scan gun is then used to scan other information from the package such as shipper and tracking number. The customer name is selected from a linked field followed by entry dimensions, weight and comments. Then the box is opened and a general description of contents is scanned into a field from a prepared list on the wall. While we have the box opened we would lik
Some field types including single selects, multiple selects, linked records, and collaborator fields will show “List” or “Record” instead of the values you may be used to seeing in the Airtable grid view. This is consistent with how the Airtable Web API returns information.
Hi community I have the following question. I’d appreciate any idea how to active it. I'm organizing my data for AI analysis and need it to be both structured and easy to interpret.To achieve this, I'm grouping the data by a key variable — in my case, Persona. This approach is working well and displays the information mostly as intended.However, one thing is missing: I would like to include a summary row (e.g., a SUM or total row) directly below each Persona group to aggregate key metrics (such as totals, averages, etc.).My question:Is there a way to automatically add a SUM row beneath each grouped Persona to display aggregated metrics for that specific group?
Hi there, If I have data that is pulled in from another file and in one column it is showing this - Project department (John Smith)How do I grab the (John Smith) part and let it populate into the column next to it? Adding to that once I have the names do these names need to be added to the base in order for them to view their assigned things in an interface? Many thanks
Hi, I’m trying to build an event management board. Some of my events are recurring, but the current date data type does not allow multiple ones. Do you have a best practice for it? One way I’m thinking about making a separate date table, and link the event with the dates. But the calendar view looks odd for this date table, as it use dates as the primary id and does not allow me to display big event name on it. Also, I don’t know how to filter the ‘date’ data based on conditions in the event table. i.e. if I want to only show the dates where the event has been confirmed. Wonder if you have better options? And if yes, please show me!! If not, how to make my current date table better looking?
Is there a way to customize airtable form based on the user. I have a dropdown box that is selected by the person, then it shows the applicable questions based on the drop down. Is there a way to autofill in the dropdown based on the user filling in the form. I need to keep all of the questions in one form for convenience. What would be the best way of doing this. The reason I need to do this is because each person is required to fill out a form each month, selecting a name then shows what forms a person has not completed yet. Thank you
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.