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
Check out the Airtable Enterprise Network (or 'AEN'), the exclusive hub for Airtable Enterprise customers. Access private events, connect with peers, and ask your top of mind questions here.
Hello Airtable community, not sure it is possible, but Gemini says it is)) but when Gemini gives me the sample script and I adjust it and try to use it, it does not work. Here is what I am trying to do. I have a record (contacts database) where I have a multiple select “Status” for this record. And I have another multiple select “Services” with let’s say “Option A”, “Option B”, “Option C” and “Option D”.When I choose the option “Available” in this multiple select “Status”, I want to the script or automation to limit the options shown in the field “Services”. For example when “Status” is choosen for “Available”, my field “Services” will only display “Option B” and Option D” as an available options to choose from.Anyone thinks you can help me with some advise?
Does anyone have a current script that is parsing any emails beiing received in the new “trigger when email received”. I am trying to parse the body, but I cannot figure out the inputs from the email received.I get errors on all of the inputs. My reason for the inputs, is that the receivedDate didn’t work.// Get inputs from the automationlet inputConfig = input.config();let subject = inputConfig.subject;let body = inputConfig.body;let receivedDateRaw = inputConfig.receivedDate;// Optional: log inputs (for testing)console.log("Raw receivedDate:", receivedDateRaw);console.log("Subject:", subject);console.log("Body:", body);// Parse date string into Date objectlet receivedDate = new Date(receivedDateRaw);// ✅ Function to get the next Tuesdayfunction getNextTuesday(date) { let day = date.getDay(); // Sunday = 0, Monday = 1, ..., Saturday = 6 let daysUntilTuesday = (9 - day) % 7; if (daysUntilTuesday === 0) daysUntilTuesday = 7; let nextTuesday = new Date(date); nextTuesday.s
I am trying to convert an existing solution to airtable, and see some great enhanced functionality. however, there are relationships in my existing system that I am not sure how to appropriately recreate in airtable. For instance, i have a join table that shows several different related tables through a relationship. some of the relationships are many-to-many, and would be created in the main join table. What’s the best way to recreate that in AirTable?Thanks in advance…jesse
Bonjour,j'ai crée une table mais le champ type "Nombre" est absent de la liste des champs disponibles.. Avez-vous une explication?
I have two linked tables on a field called “customer”. This works great for issue tracking, because I can add a customer to a specific issue and know who needs to be followed up about it, or quickly get their current status. I’d like to group by the Customer field. However when I set this grouping up, it treats the following as separate groupings: A B B, A B, A, C and so on. Is there a way to view the grouped view so all of Customer A’s associated issues will show up under Customer A, rather than 1 under A, 1 under B, A and 1 under B, A, C?
Hi all, Guessing this is a popular question, yet when I am searching the existing questions I've not yet found the solution. There's gotta be an easy fix.... right??? We've a base listing our clients. Each client might have between 1-3 staff assigned to support that client. For example: Steve, Jill, Carl supporting Client ASteve supporting Client BJill supporting Client CCarl supporting Client DIf I group the sheet by 'Assigned Staff' I get a list that looks Similar to above, but I am trying to produce a sheet that looks more like: Steve Supporting Client A + BJill Supporting Client A + CCarl Supporting Client A + DWhats the easiest way to achieve this? Would LOVE it if there is a known video out there that can walk me through the steps. ❤️
Hello, I'm trying to use airtable to email callers templated information about products. I have a grid view where I can enter an caller's email, select from product list (a, b, c), then use the Button feature to trigger a SendGrid email that contains information about the selected product that is retrieved from a lookup table (a - info text, b-info text, and so on). This all works very smoothly except I would like to create a Form to enable staff to use this process without having to interact with the grid view. So I would like to somehow automate the pressing of the "Send email with SendGrid" button once the Form is submitted/record created. Is there a way to do this?Thanks for any ideas you have.
I see I can set up an automated email response like “thanks for filling out the form” but ca I set it up to include their responses so they have a copy of what their answers were?
@AasiaWhen a form is submitted from he/she. I want that Airtable to send a confirmation email for successfully submitting the form.
Hi, I have a request to set up a “tag” so that users can @mention everyone in a dept. in one new comment. I tried doing this with groups. I created a group made up of 4 users who are all Editors in the base, and gave the group the name “TechGroup”. I would like to add a comment on a record and ‘@TechGroup’ so each member is notified. So, far this doesn’t seem to work. Is there another way to tag multiple people in one mention? Thanks!
It does not appear that Airtable has AI Agents that can perform ongoing, automated functions w lots of tasks including web searching for related info? This sems like a huge miss unless I am missing something?
Can someone help with the coding of a script that converts the contents of attached .TXT files to a long Text filed?We have an attachment field [TXT] that contains one text file per field. We wonder if it is possible to copy the contents of each text file to a long text filed?I have see some notes on it, but we need scripting help to achieve it.Thanks for any advice.Kevin
AT community, Yes I have searched and used AI and I’m not getting a good answer on this question. I have a pre-filled form to advertisers. I want some of the prefilled fields to be locked so that the content cannot be change. Has anyone found a workaround for this and be willing to share step by step on how to do it. I’m very new to AT and want to learn!Thank you!
I’m getting the following error when I get or create the data from airtable in my next.js project.AirtableError { error: 'NOT_AUTHORIZED', message: 'You are not authorized to perform this operation', statusCode: 403} I’m using airtable npm module for integration.I’ve added all required scopes already but not sure why I am getting that error.Can anyone help me for that? Thanks
Hi EveryoneI’m sure that this has been done before but I can’t seem to get anything I try to work Im looking to create a forula filoed that looks up and displays the PAYE Month a date in another field falls into for example 17/04/2024 would lookup and display PAYE Month 102/10/2024 would display PAYE month 620/08/2025 would display PAYE Month 5 I am dealing with the tax year in another field so I dont want to worry about the year below is the parameters I have tried if statements I have tried a switch example but cant get anything to work I have tried setting a year start date and using dateAdd to add on the number days after the year start but I just not getting anything to work right If someone could point me in the right direction I would be really gratefullCheersJackieFrom Date To Date Days Between No. Days from start of tax year Should Display 6th april 5th May 29 29 PAYE MONTH 1 6th may 5th June 30 59 PAYE MONTH 2 6th june 5th
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
No account yet? Create an account
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.