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 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! My team has used Asana to create templates for different categories of events that auto-populate tasks with due dates (e.g. 45 days before event date). What is the best method to creating similar templates in Airtable? Below is a screenshot from the Asana template. I’m looking to get each Due Date cell to auto to x days before the event date, excluding weekends. I tried using DATEADD, but this does not work on individual cells. Thanks!
Has anyone successfully engaged with the Airtable sales team via email? I have submitted the "Contact Sales" form about 5 times over the last month or so, here: https://airtable.com/contact-sales?ref=htcs.prd&_gl=1*1555h4p*_ga*MTkwODg1MjkwLjE2NjY5NjkwODA.*_ga_VJY8J9RFZM*MTY5NzU2ODA3OS4xNS4xLjE2OTc1Njg3NzAuNTcuMC4w Has anyone successfully gotten in touch with a salesperson to get pricing/information about an enterprise plan?
Hi, I am trying to set up renting hours for a local association and I am looking for the best way to do that.We have some outdoor material that can be rented by the hour. Would you have a smart suggestion for not having to write manualy 8 lines (8hours per day of renting) x 123 days (4 months of the summer) = 984 lines ?After we will see yo integrate that with a google calendar.Thanks
Hey everyone!Welcome to the new Airtable Community experience! My name is Maddie, and I’ve been your community manager since summer of 2023. I absolutely love this community, and want to say thank you to everyone for your ongoing enthusiasm for Airtable; it truly means a lot, and it makes me so happy to see how many people here are willing to lend a hand to help your peers in this space. I’d love for us all to introduce ourselves, leveraging this template:Name: Company/Role: Favorite hobby: Most used emoji: How has Airtable helped unlock your workflows? Or if you’re just getting started, how do you hope to use it? I’ll go first! Name: Maddie Company/Role: Sr. Community Program Manager, Airtable Favorite hobby: Yoga Most used emoji: ✨ How has Airtable helped unlock your workflows, or how do you hope to use it? One of my biggest use cases in Airtable is event management so I can best run our community events program! Whether it’s a user group or onboarding office hours event, they’re a
Hi,This question is a detail out from another question (here: https://community.airtable.com/t5/automations/dynamically-scalable-email-content-by-quot-tag-quot-instead-of/m-p/202260#M19754), for reference.I’m trying to abstractify our CRM’s mail setup using an automation with Find Record steps with Dynamic variables. One variable I need to use is “Tag” that links contacts to an area of interest (nature, sports, food, etc). Since I use the Tag classification in many places throughout the base (currently 8 tables), I have made it into a Linked Record instead of a separate Single Select for each table. Yes, I know that if I'd use Single Selects this would work without issues :).The problem is I can’t figure out how to use a Linked Record as a Dynamic condition in a Find Record step. I’d like to search exactly so I choose Tag “is exactly” from the Dynamic conditions. Then I only find a “Make a new list of” option, under which I can choose the tag (“nature” in this pic).Testing this setup y
I am trying to display field values within a text element in interfaces, much like in Page Designer, to support detailed instructions. For example:To create a new workscope:1) Please take note of the Case Summary Name first: {Case Summary Name}2) Click the button below to create a new workscope.I have tried using {Field Name} and converting it to code with the <> button, but that doesn't work.Other suggestions?
I have a table linked to an application form. This table has a field with a check in it.I have another table within the same workspace for people that are referred, also with a check in it.Right now, new members apply and then I have 2 records: one from the application form, another from the manual enter I did as the person got referred.I want the system to update all records when someone applies using the form, so it doesn’t create another record, but fill in all the information on the already created one. Is this possible?I can’t seem to make it work via automations.
Hello! I am organizing a large amount of photographs. I often have the year but not the specific date. I would like to use Timeline view to see all these photos in their rough year-by-year order. Suggestions? The DATE field makes me list day-month-year. Thanks!Julie
Hello everyone,I am experiencing lag issues across the different interfaces I provide to my users.Pages take a very long time to load, which makes it difficult for my colleagues to manage their work.Do you have any solutions or advice to help minimize the loading time between pages?Best regards,Zeel
Hello, I work with ships and would like to create a grams/day formula which takes the date from our last interaction (order) with that ship to measure from. I cannot work out how to have it search for the previous record to take that as the date to give the days passed value for the equation.Anyone have any tips?
Hi there, Is it possible when creating bar charts that you can have visuals like we do on Excel or powerpoint? For example On the X axis I want it to have the month, Y axis to have submissions made but the actual bar to show the each teams who have made submissions for those months. Essentially, for one month it will have 3-5 bars which represents teams A-E Thank you
Hi there,I wonder whether there’s a way to bulk print selected records with a page designer template. Currently there’s only a way to print either current record or records of a specific view. The problem: When the view contains more than 30 records it ends up in a browser freeze. So I wonder what possibilities does the community see to solve that. Thanks for your help,Florian
I want to use server-side Airtable API calls to completely replace all options in a "Multiple Select" field type. Specifically:Current options: A, B, C Via API call: First delete all existing options (A, B, C) Then write new options (D, E, F) Question: What is the correct request body structure for this operation?I've tried the following JSON structure, but always receive this error: { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." }}My attempted API call:--data '{ "options": { "choices": [ {"name": "D", "color": "blue"}, {"name": "E", "color": "green"}, {"name": "F", "color": "green"} ] }}'Key Points:Field type: Multiple Select Operation: Complete replacement (not incremental updates) Error persists despite correct authentication and field IDCould you provide:The exact JSON structure required for complete option replacement? Any special parameters needed (like enable
Originally when we created our system, we used text fields to record the Call Time and Gig Time Span. Since we have the time zones already saved for each record, I am wondering if there is an easy way to do the following: Switch the Call Time Field from a Text Field to a Time field (without having to type the time zone every time) Switch the Gig time Span Field into 2 different Time fields for both previous records and current records, a Start Time and End Time. Similarly, I do not want to type the time zone every time. Moving forward, I would like to only have to type the start start and end time for an event in separate fields (not in the text box).If this is possible, these would save a ton of time and allow us to do better, more efficient work. Thank you for your help!
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.