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 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 everyone! Our library uses an Airtable base for approving programs, some of which are one-time and others are repeating. We’re running into a problem where we’re sometimes overbooking on a single day (this is across multiple branches, so we have the room, but we try not to host too many programs on one day) and we’d really like to see all our programs on a calendar view. The problem is with the recurring programs. Right now, the base is set up with a text field where programmers put in their dates (e.g. “every third Wednesday from 11-12”) but obviously Airtable can’t read that. We could set up individual date fields for each occurrence, but some of these programs are staples, held dozens of times a year and would necessitate dozens of date fields. As a work around, I tried making a separate “Calendar” table with the dates as primary fields, and then in the main table, the date field became a linked record field. In Calendar, I created a calendar view and that technically works, but
Good DayI have generated a base and from that base a form. Once submitted the form automatically adds the information to the base. When the new record is generated in the base I want to send an email to the person submitting the form. There is a field in the form where the person adds there ID I used that field in the To part of the automation and I am getting an error. The below is the layout of my automation In the Body of the text is a member number that is automatically generated when the form is submitted.When Generating a Preview I get an Error Message I have checked the field of the new record and the email address is displayed.. I dont know how to resolve this. Many thanks
Hi, wonder if I can relate data in different workspaces. Or it will be completely separated?
HelloI have two tables Customers and Orders. They both have a CustID to link the order to the customer that placed it.I need to import a CSV file to Orders and this includes the CustIDI can import as a regular field but can't figure out how to import it and have the Link to the customer tableThanks in advance for any helpMike
Hey! We are a prop tech startup from Germany that pretty much has all of our operation based on airtable. We are only hiring people with significant airtable experience and drive. The jobs we offer are fully remote. Contact me: david@furnestate.com if interested!
I hope someone can help with this please Connecting from n8n and I’ve created a personal access token and entered it into the Credential to connect with field, Below is the scopes and access permissions I’ve checked that the Base name and tables are correct I’m not sure what I’m missing here , will be grateful if someone can assist
Hi AllI have a Base A with Table 1 and Table 2. One of the fields in Table 1 is a linked record field to Table 2.I also have Base B with Table 1 synced to this base.Rather than showing a linked record from Table 2 in the field in Base B Table 1, a text field with the entry in the primary field for Table 2 appears - is this expected behaviour? If so, how should the setup be structured to show the linked record? If I have a Table 3 in Base B that has a linked record field to Base B Table 1 and I want it to have a lookup field to the linked record field already in Base B Table 1, is that achievable?Thank you.
I have a very simple automation that runs every 15 mins. It finds rows from a table that have data in a specific column and then uses a repeating group to send a slack message to each of the channels listed in those rows it found. This typically works 90% of the time but usually a handful of times a day it errors out for Slack API rate limited. Sometimes it errors out with 4 groups that it found but will also error out with 1 group. Experiencing similar issues related to the repeating groups for slack messages. Any help is appreciated.
Hi there, I am looking at creating a line graph in the interface. Is there a way to show multiple teams as the lines? What I am hoping for is X axis to have the months and the Y axis to have the number and each month to populate the number is this possible? Thank you
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
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
How to make new inventory items automatically link to the corresponding room in our building by linking or with a formula or automation.When a new item is added, how can I make that item auto populate in another tab by room (multi select)?This is the base. We have a robust inventory with “ALL ITEMS” and items by room. We want each item entered into “ALL ITEMS” to populate in the room selected via “multiselect.This shows the multiselect tab. Any assistance is greatly appreciated!
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.
