Ask the Community

“Client Table” contains clients in column A. One client to a row. Each client belongs to a group (Group 1, Group 2, Group 3, etc), which is listed in column B.  “Project Table” contains projects. The name of each project is in column A. Each project has one or more clients. One project could have clients from multiple groups. I’d like a column in the Project Table to list all the groups represented in a project.  Thanks!

Hi, I'm currently trying to display my teams averages in an interface. In my table, I have a user field where records are assigned to a team member, a date completed field and a status field where the team marks "Complete" when finished.In my interface, I would like to display the average count completed per day. I know this can be accomplished through lookup/rollup fields but I'm struggling to get it to work properly and would really appreciate some assistance.

Hello,I am celebrating my automation is now working, however, whenever it seems that Airtable is sending me an automatic email titled, "Something went wrong with an automation...". I've pasted the email and error screen below.Can you help me understand if there's actually a problem, and how I can get the emails to stop?TIA,ML   

Good morning.We are experiencing issues with email sending from automations. We have detected a change in behavior with email dispatches when several emails are entered in the "TO", "CC", "BCC" fields.When the action is triggered, it appears that Airtable sends multiple independent emails instead of a single email. For example: If "Email_1" is entered in "TO" and "Email_2" in "BCC", then "Email_1" receives the message, but "Email_2" does not receive a copy. Instead, "Email_2" receives a direct email, as if "Email_2" had been set up as "TO".The expected behavior would be: "Email_2" receives the same message that was sent to "Email_1".We have observed this change in behavior today, 2024-03-07.##### Message edited to detail the case ####.To detail our case I have conducted a simple test, easy to replicate; creating a basic automation where I have only added a time-based trigger and the action Send an email,

Hi All Through automations you can: Create an outlook meeting Update an outlook meeting But I can’t find a way to cancel a meeting? Is it impossible? Thanks in advance Matt

In my account, on both the free and paid workspaces, I have the option to update a record's date field with "A specific time" -> "Actual Run Time" in an Automation.  However, in a clients account, they only see When a Record is created (or Form is submitted, or conditions are met, etc., for the trigger) and Base Structure. They do not have the option for "A specific time."Is this something that's only just now being rolled out and not every account has it yet? Like I said, I can see it in both paid and free workspaces that I have, so I don't understand why they wouldn't see the same option for their Automation to update a date field with the date/time that the automation is run. 

Hello,I'm looking for help on Airtable Automations. I'm trying to Find a record to update based on Table:Sessions field matching Table:SignUps field. Both fields are "formula" fields that make a text number because the original Sessions field is a linked record, and the original SignUps field is a Primary Key.I don't know why, but I keep getting the error message below saying, "No valid nested options". It won't let me pick *either* the text field or the original Primary Key for Finding the match, and I have no idea why.I already went through this post explaining how both of the "Find" fields have to be congruent... but as far as I can tell, mine *are* congruent, but I'm still getting the error. How

I created an automation that creates task records when a new project record is created. It finds the matching records from a "task template" table and creates new records in the "task" table. It runs fine except for records that have a user group populated in the "assignee" user field. It won't create those records. Both the "task" and "task template" tables have matching user group fields, so this isn't the problem. In the example below, the automation will create 2 records where the assignee is a single person, but won't create the 3 records where the assignee is a user group.  

Is it possible to change the position of the menu in Interface so that it appears at the top? Or maybe on the right side?I would be happy to helpthanks! 

Hello - I want to have a form that has different paths depending on your answer, but all link to an Airtable base. Is that possible? I think I need to use Zapier for that, is that correct? Basically, I do research - so I want the client to be able to choose the type of record they are seeking, and then it will pull up different fields depending on that answer. Once the rest of the form appears, they’ll proceed with their research request and submit it on my website. On the back end, the Airtable would have a combination of some fields that are awaiting input (e.g. their name, contact information, notes, etc.) and some fields that I already have the choices populated (repository, record type, etc.) I’m just trying to gut check that this is possible before I go creating. I would use the forms within Airtable alone for an easier solution, but it’s too complicated to include ALL the fields when some are only needed for certain types of records. Thank for any

I need to use Gravity Forms on my website because it allows me to take Paypal payments as part of completing the form. Can submissions via Gravity forms add records to an Airtable table configured with the same fields?

Hello, I want to show “0000009” in my cell inside Inventory table. I tried to use roll up but it shows “0000009” and “0000008”. How can i only show the latest one only (in this case is “0000009”) Thanks

Good morning guys,I need help with an automation for my base. I'm not an expert at all, everything that I already did, I figured out very slow and with a lot of help, but I can't figure out how to put this automation..... 🙂So, I have a base for my company. We are exporting different products to other countries. Therefore I have an order and sales table, as well as business expenses. In all 3 tables I have business cycle that shows the month and the year - it is automatically updated when the purchase or sales date is added to the table. Now I have another table that I named business cycle. Here I want to get an overview of my cash flow - money that comes in and goes out every month. I created an automation to create on the first of each month a new business cycle.Until here all good, now the problem:Once I add to my purchase, sales or expenses table new data I want them automatically added to the business cycle table in the ri

Hi everyone, Following Situation: I have Projects, Reports, and Tasks. Projects are linked to Reports, Report are linked to tasks. Tasks are not directly linked to projects. Now in Projects, I have a Lookup field for Tasks from reports. I really need to filter this lookup field by two checkboxes in Tasks. But unfortunately I can only set filters around Reports: "Only include linked records from the reports table that meet certain conditions..."Is there any way to filter the Tasks directly? Or is there any clever workaround that I am missing? Any help or ideas would be appreciated!Cheers 4

Hello friends,I am looking for an automation/script that does the following.1. When the field 'Start date' is updated in a record in the table called 'Projects'... I would like...this new 'Start Date' to replace the current date on a field called 'Deadline' in a record which is always called 'Project Start Date' in a linked record field of the triggering record called 'Tasks'.If it helps at all:- the linked record field 'Tasks' is linked to the table called 'Tasks'- The record which I want to change called 'Project Start Date' sits under a field called 'Task', in the 'Tasks' table I have no experience in scripting, Gemini provided me with the following, but it doesn't appear to be workingNote: My trigger is When a record is updated - "Start date" - on the "Projects" table:async function updateLinkedRecordDeadline(record) {const linkedRecords = record.getCellValue('Tasks');// Ite

Hello! one of the recipients of the marketing email unsubscribed by mistake.As i understand the mail was blacklisted in baseNow he wants to restore the subscription   Is it possible to manage in Base or by user   Sincerely, Kirill 

Hi all, So this automation was working and I don't seem to know what happened. Now when I test an unchanged record, everything is fine, but then when i change something, it doesn't update google and gives me the screen shot alert. I have permissions in the google calendar to change, modify, manage (I'm the owner). I tried reconnecting the accounts and it didn't help. Any thoughts?

Is there a complete list of these options for record "names/terms"? 

Hi, I have a few tables for different marketing teams, and each team has their own campaigns and dates. Some campaigns have more than one date. I created a master integrated marketing plan where i pull in information from each marketing teams table. The dates end up living across multiple columns in each record, making it impossible to create a timeline view. I've tried formulas, rolling up dates, flattening, but nothing has enabled me to create a timeline view based off one date field the way airtable requires. Any suggestions or workarounds out there?

I am fetching specific cryptocurrency data from CoinGecko using the Data Fetcher and populating it into a table called Tokens. Additionally, I have a table called Positions, which is linked to the Tokens table. The Positions table is where I track my Liquidity Pools.The challenge arises because the order of the Tokens table can change dynamically since it is populated with live data refreshed several times a day. Changes in market cap or the addition of new coins may shift data up or down in the Tokens table. This can lead to issues in the Positions table, where the linked entries might display incorrect coins.For example, let's say my Tokens table initially contains the following coins: BTC, ETH, ARB, USDC, SUI, FET, and MATIC. Suppose I’m tracking the MATIC/USDC pair in a Liquidity Pool within the Positions table. At

Is it possible to select a range of records in grid view using the checkboxes and apply a sort to just that range?

I deleted a couple of records from my inventory base (on purpose). Then I accidentally deleted a whole field. When I go to my Trash it says nothing has been deleted for 7 days. That’s not true. There should be two or three records AND the entire multiple-choice field in there. What do I do?

I have a Projects grid and a Tasks grid.The Projects grid has fields for Project name, start date, and end date. The Tasks grid has fields for Task name, start date, end date, and reference to the Project name.  For each Project, I would like the start date to be the earliest Task start date among all the Tasks that reference that Project.Similarly, I would like the end date of each Project to be the latest Task end date among all the Tasks that reference that Project. Thank you in advance for any help!!  

Hey All,I'm trying to get this formula to produce one of three outcomes based on a products variance % from its target FOB, but for some reason it is not producing anything. I have used this formula multiple times successfully on other tables, but for some reason it is not working for this case. I have rewritten it a couple times and have checked the reference field to see if there are any issues and still can't figure out why its not producing an outcome.   Feel free to ask any clarifying question. Any help will be greatly appreciated!- Erich IF({Precost FOB % Variance} = BLANK(), BLANK(),IF({Precost FOB % Variance} <= -0.05, "RED: More than 5% off target",IF

Hello, I have a question regarding Gmail automations in Airtable.I'm starting a business and am new to the world of marketing. I have extensive experience using Airtable automations, as I've been using it for years for other purposes, but I have many questions about email marketing tools and the limitations related to email contacts, spam, etc.My goal is to collect interested leads through a form. After receiving a form submission, I want to automate sending an email via Gmail with details about the services I offer. I also plan to create follow-up automations to re-engage the lead if they don't convert within 1–2 days of filling out the form.In addition, I want to send other emails periodically to offer new services—but not in bulk on the same day. For example, instead of sending a service offer to everyone in my contact base at once, I’d automate it so that an email is sent only when a lead completes 15 days in the database. In this way, there would never be l