Ask the Community

I don't believe there is this functionality but can gmail SEND email to an Airtable Base?  (like forwarding an email to airtable)

Does anyone know a way to save Outlook emails for future reference? Something where you just click and drag the email in to Airtable and open it in Outlook when you click on it. I guess you can drag it in as an attachment but it won’t then you have to download it to again it instead of it just going straight to Outlook and opening it up. Anyone know the best way to store emails on Airtable?

I’m working with a list layout interface. I’ve toggled the option on for users to filter, but the dropdown is not offering me all fields, only a (unknown what) selection. (Sorry for huge images, I still can’t figure out how to resize.) The field I’m looking for is called © Email. It’s a single line text field and it is the primary field in table. Instead I can only some other fields with email in the name. Is this an Airtable limitation or am I don’t something wrong? I can’t find documentation on it. Thanks. 

I am hoping someone can help me with this! I have tried and tried to find a solution, but I’m having trouble. Currently, records are named using a PDF filename that is synced from a Google Drive folder. (ie -- 123456789.pdf) The number of digits before in the PDF range from 4 to 9 digits. Currently, the record name becomes G-123456789 in our table.However, we have a new naming convention for our documents. So, I need to pull only PART of the filename to name the record. The new naming convention looks like this:123456789 North Smith 04-03-2025.pdfI need it to pull just the first number (123456789) to use to name the record in Airtable. I hope that makes sense, and I hope someone can help! Thank you!

hi im really struggling with something that i think should be easy but is very challenging to get right. I’ve been tinkering with scripts, automations and apps now to basically just manage one field in one of my tables. I am creating a scope of work configurator that has a list of components in one table and in another table i want to create records for each distinct project that I create. What i would like to happen is to have a checkbox in the components table and then run a script to fire at my command, to then have a chosen record in the projects table to link to all checked records and then pull in the data it has to run a simple calculation/formula on to get a result that totals an estimate for the amount of hours it would take to complete all the checked items. I need each project to be distinct so i can continue to update its unique record based on what’s checked in my script/app without having to create new tables or new bases for each distinct project. I can make the calculat

I am looking for a way to upload csv files of data into different tables but have them linked. Is this something I will need to do manually, or through an automation?I have one table Companies and the other table with Employees. I need the employees linked to the companies table but I am unsure the best/easiest way to do this via csv upload.Thank you for your help!

Hello, Our office has an Intranet using Microsoft Sharepoint. I am trying to embed our Airtable database onto the Sharepoint using the native “embed” web part. We have had success using this component with data from other sites. When we attenmpted to embed the Airtable we got this message: “Embedding content from this website isn’t allowed, but your admin can change this setting. They will need to add ‘airtable dot com’ to the list of sites that are allowed” Our admin followed the instructions and added ‘airtable dot com’ but we are still getting the same error. Does anyone have any advice? Thank you!

Hello,I don’t have a lot of scripting experience but feel like this one should be simple. However, I can not find my error; it’s probably something super simple and I’m just not seeing it.Here are the two simple tables I have: So in the Day table, when the Week linked field is missing, I want a script to automatically update the field. Here is my script: The error is: I know the weekID is correct because I can paste the result in the Week field and it works but unfortunately the script can not do it. Thanks in advance, I hope this is easy one!

Related topics: (announcement about improvements from 2 years ago)  Suggestion/feature request:I find the automations list almost unusable. I’ve added sections to my automation list which helps a bit but ultimately end up clicking into each automation which is really annoying (as is this forum upgrade?)As a user, I cannot find automations that I’ve previously created because I do not have a search bar. I want to be able to quickly locate the automation I’m interested in without  As a user, I want to be able to expand the width of the automation list in order to view the whole list. This will help me avoid creating unnecessary automations and to understand what I’m looking at. As a user, I want to be able to see the complete name of the automation so that I can continue to use the naming convention we’ve established. (I can neither expand the frame with the names of the automations nor see them when I hover over the automation.) And because this forum post was so difficult to make,

I have created a form and I upgraded it.  I have published it, but when I try to copy the url so I can share it, it doesn’t copy.  Is there an alternate place to find the form url?  When I go back to my base and click on the Form View, it shows the old version, not the upgraded finished version.

Hello. An unexpected problem is that suddenly it is no longer possible to move views through the list of views in any table. The icon in the name of the "move" view remains, but the view does not move. What could be the problem?

Hi, I'm getting this error, and I have no idea what it means or how to fix it:Any help with fixing this is much appreciated.Thanks

Hello!I use a table daily to track my students' test scores for a standardized exam. The exam has three components: math, reading, and verbal.Each row is used to give details about a student's score in one specific section. For example, if Amanda sends me her test, she will actually get THREE rows in the table, like this:R1: Jane Smith | Math Section | 75 points | January 8 2024R2: Jane Smith | Reading Section | 21 points | January 8 2024R3: Jane Smith | Verbal Section | 36 points | January 8 2024The math/reading/verbal cell is a "choose one" cell. I cannot pre-fill the cell because it alternates between Math, Reading and Verbal. I wish there were a way to click a button that was like "create 3 new rows", and have them pre-filled with Math, then Reading, then Verbal in the section column. Any suggestions?

We use the page designer to generate commercial invoices. We are running into the issue where we have multple static lines of text that often have a $0.00 value. These are no longer being accepted so we need those static lines to hide when the corresponding value is $0.00.  Is this possible to do? I’ve played around but haven’t found anything yet...

Hi Community I have created my bases to keep track of our cold email campaigns. Now I have a lot of data that I would like analyzed as much as possible in an automated way. Can you suggest a workflow where I can have AI go trough the data and provide a summary of all the content of the base as well as suggestions for optimization.As an example I would need AI to analyze all 500+ replies that have been received, shortlist the personas that show the most interest, the messaging that works best, what industries are the most engaged. I have tested 2 approaches thus far:I have created a custom prompt indicating exactly what I need to happen using the AI feature of Airtable. This is the response I get  I have also tried using Data Fetcher to integrate with Open AI but it suggest messaging rather than analyzing the information 

Hi Dear community I'm new on airtable and looking for how to control my stockInventory management Purchasing Need your help or if you have sample database Most welcome  Thanks Tarik 

I have a make.com scenario that populates videos from Google Drive to a table. I’m trying to create an automation in Airtable that takes all of the data from that original record, and simply creates a new record in a different table with that same data.Ex. Record goes into Table 1 > Automation Triggered > Same record goes into Table 2 Should be absurdly basic, but I keep running into an issue with the video attachment field when trying to test the automation.I’ve tried every single type of data from the video column. Same error every time.I don’t understand how this is so difficult lol I’ve literally tried every type of data… the base/table structure and just choosing the video field ID, and then every form of data within that specific field as displayed above.The error I’m getting Structure of Data I’m trying to pull from Record 1 - to create in Record 2 

How do i  find duplicate records based on an email address and remove them autmatically? I have a table that is bringing in registrants for a free event (via zapier) and I am seeing there are some duplicates that are showing up.  Presumably the person forgot they already signed up. I need to track accurate numbers.  How can I do this? Via formula? or automation? Thanks in advance

Interface viewable on mobile, when is this happening???  I need this like yesterday! and please don't comment use 'glide app' it doesn't work for our needs.And why are list views limited with features that are available in grid view - particular the colour filter 

Hi Everyone - I am very new to API development and coding all together. I need some help with a script I am trying to implement. I keep getting this error thrown Error: Request parameters failed validation. and I have no idea why. Any help is greatly appreciated. // Get the table and the newly created recordlet table = base.getTable('Table Name');  let recordId = input.config().recordId; // The ID of the newly created record let record = await table.selectRecordAsync('recordId'); // List of users to assign randomlyconst users = [' User1 ', ' User2 ', ' User3 '];// Pick a random userlet randomUser = users[Math.floor(Math.random() * users.length)]; // Update the Assignee field with the selected userawait table.updateRecordAsync( 'recordId', { 'Assignee': randomUser});

Hi there, How do I convert date to text in a new field by formula? I have one date filed(2021/5/16 9:00) and need to convert it to text data. Does anyone have a solution?

I have a formula that displays a new volunteers' mentor on a schedule for staff - basically, if there is anything in the field {Mentor (from Link to Forms)}, show that, or else show * (to prevent the field from showing up (empty) on the schedule. Here’s that formula:IF({Mentor (from Link to Forms)},{Mentor (from Link to Forms)}, "*")What’s happening is that this information is pulling through many deployments later - when a Mentor is irrelevant.I want to change the field so it is dependent on the Experience field - which I hope would make it go away when that field is NOT “This is my first deployment.”So:IF(({Experience (from Link to Forms)}, "This is my first deployment",), {Mentor (from Link to Forms)},{Mentor (from Link to Forms)}, "*") But that is not doing it for me. What am I missing?Thank you!~Lisa

I am stumped on how to solve this problem.Our team has 1 table set up that is pulling data from a synced table. We added in new columns to the right of the synced data to be able to add in subtasks and a few other pieces of tracking information.The issue we are running into is there are other ad hoc tasks that need be done that are not on synced table but we need to be able to put the synced data in the same view with the ad hoc tasks.Our only commonality is that we have a linked record for both from an overview table of projects.Is it possible to bring together a synced data table and an ad hoc table into 1 new table for the team to work from?

Hello,on calender view i want to default to 30 min records shown on calender at present it is 60 mins by default.I have been trying to create a script and automation that will fill an end date and time field automatically to 30 mins after the appointment date field has been updated and then using thsi end date and time field to set this as the end of the appointmentANyone any ideas how to do this??  

Hi everyone,I could use some advice on setting up an automation for a project I'm working on.I have an Airtable base structured like this: A Rooms table (corridor, toilet, kitchen, etc.) A Products table A Proposal table A Line Items table where I create the Proposal Items which is linked to the other tables. Each product has a payback calculation (e.g., how long it takes to pay for itself) What I'm trying to achieve is to automate the creation of a graph for each job that: Plots Rooms on the X-axis and Payback Time on the Y-axis, showing all relevant products linked to that job. Either: a) Automatically generates this graph and uploads it as an image attachment back into the respective Job record in Airtable — OR — b) Exports the necessary data to another 3rd party tool (e.g., Google Slides, Canva, or similar) to generate the full proposal externally, and then uploads the final proposal document or image back into the Job record. I'm not sure which approach is more feasible