Ask the Community

Hi there, This is a common question that I wish it does not have to involve a formula.  But I guess it should.  Can you tell me the way to write a formula to specify how I can account the total number of active projects for one month (Feb 2025)?   I have a start date and end date.   Combo Request DateNeeded By DateDate format MM/DD/YYYY When I write the formula it is not capturing the correct records active in Feb 2025. IF(  AND(    OR(      DATETIME_FORMAT({Combo Request Date}, 'MM-DD-YYYY') >= '02-01-2025',      AND(        {Combo Request Date} <= '02-28-2025',        {Needed By} >= '02-01-2025'      )    ),    {Needed By} >= '02-01-2025'  ),  1,  0) Do I need to specify status on-going, complete, in progress?

Is it possible to add groups to combine elements when starting from a blank interface?  I have groups when starting from a dashboard, but I’d like to be able to add them to a blank interface.

Bonjour à tous,Je rencontre un problème avec Airtable : je n'arrive pas à trouver l'option pour accéder à l'historique des révisions d'un enregistrement. J'ai essayé de suivre les instructions habituelles en ouvrant l'enregistrement en vue élargie et en cherchant un lien ou un bouton pour voir l'historique, mais sans succès.Est-ce que quelqu'un pourrait m'indiquer où exactement cette option se trouve ?

I’m an airtable newbie. I’m building a base for planning production (live events) for the AV company I work for. One of the things I need to track is our pre show, show, and post show milestones in the planning process. The time frame is based on when we are loading in gear for the event. I need to make an automation that will take the load-in date and subtract 30 days for pre-show items, stay the same date for show items, and add 14 days for post show items. I have the pre, show, and post as a single select. Any and all help would be appreciated 

I'm using the Outlook automation "When a new email is received" for the first time. However, it's not allowing me to pull the Sender. The Sender is grayed out (see image), and when I hover over it, it says, "No valid nested options."Has anyone seen this before? Do you have any idea how to fix it so it will pull the Sender into the newly created record? 

I have a list of clients that I do work for. I do the same 50 tasks for each client. Each field in my table is another task. The tasks are dropdowns with the status of the task like assigned, in progress, completed, and questions for supervisor.My supurvisor wants to create a view that shows only the questions for her. I did this by filtering the view to only show records (clients) that has the choice ‘questions for supervisor’ in field a, b, c d, etc. all the way through. This works well.However, I need to unhide all the fields because maybe that field is the one with a question. So, when a question pops up in her view, she has to scroll all the way to the right until she finds the field that has a question. This wastes a lot of time especially because there are a lot of clients and by each client there can be more then one question.I am looking for a way to only unhide a field that has ‘questions for supervisor’ for at least one record. I don’t mind if then th

AS described above - I need a traditional one screen that displays 2 tables at once - a Purchase Order single record in the top half and in the bottom half of the screen a grid of many attached line items.I scanned forums etc and cannot find this kind of scenario…...HELP !!!!Very new to AirtableBig Thanks Mike

Hi everyone,I’m currently on the Team plan, and I was under the impression that commenter users were free. But after adding someone as a commenter, I noticed in the workspace settings that they were listed under billable users. That confused me, so I started searching the community — and I found posts confirming that commenters are billed on the Team plan.I'm now exploring other options, and I came across this in the Airtable support documentation for the Business plan:“The following collaborator permissions on the self-serve Business plans are billable:Editor, Creator, Owner.”What I’m trying to confirm is:👉 Is this 100% accurate – that on the Business plan, I would only be billed for Editors, Creators, and Owners, and that Commenters and Viewers are free?

I have a base indexed by project name. Each project is assigned a salesperson and a department number. I want to learn how to create a task template within this base. Each project will have the same set of tasks/subtasks. It would be great if there’s a way to automatically populate a task list when I create a new project in the base. Any direction you can provide (guides, etc.) would be greatly appreciated!

Hello, please tell me how to synchronize data exchange between two databases through formsHow to implement this data exchange logic between two databases?STEP 1: The partner fills out the “Invitation to become a partner” form. The data goes into the “Partners” database. This database records:Company Name Contact Person Logo etc.STEP 2: After submitting the form, the partner proceeds to the “Add Delegate” form (via the “Continue/Add delegates” button). IMPORTANT: In this form, the “Company Partner” field (i.e., the company name) must either:Be auto-populated, OR Allow the partner to select their company from a list (BUT they should only see their own company, not all).STEP 3: The partner fills out the delegate information in the “Add Delegate” form. The data goes into the “Delegates” database. That database will record:Delegate Name Position Delegate

Hello everyone 👋I've been working with airtable for years as a consultant and user, but have never been active in the community - that's about to change. I'm super interested in anything to do with airtable and emails as I keep seeing a few challenges: The challenge of receiving and tracking email responses. Replies to emails sent via Airtable end up in the void instead of the shared inbox Record limits quickly become a problem when saving emails as records Threading issue when parsing emails and creating records in AirtableAs I'm thinking of clever ways to solve these problems, I'm eager to hear feedback from the community.  If you've worked on something like this before, use airtable + emails frequently, or have any of the above issues, please let me know!

The app doesn’t retain login. I login into the app as normal,  go through the bases etc.. no problem. After close it by swiping the app (so it’s still running) or by terminating it, when restarting, the app asks me to login again. I just submitted another issue with Airtable app crashing on uploading images so this seems a separate issue with this current version.Submitted ticket for both issues but I am wondering if anybody else experiencing this. I live in the mobile all so this is quite a problem for me. In the meantime I need to create a Fillout form to be able to update Airtable records.  

Hi,i’m trying to create an Interface → Dashbord.Got the pivot table. I set option: “Click to see underlying records”, bo absolutely i don't know how to edit what info is shown in this list (i don’t mean “Click into record details” - detailed info is working fine).I would be gamechanging option for me, but i need to set different info on this list to correctly and fast identify entries.  

Hi,I am importing raw data periodically, let’s say monthly.Every import includes a data field with the date of import.Given the repetitive imports, the key differentiator (let's say Supplier ID) is repeating.I added a locked view where I filter by import date.=> I now want to analyse the data for two of the imports, e.g., 1. January and 1. June and see if any supplier was added or removed and what data in a specific field (e.g. performance) has changed. The closest I got was partly manual and didn't work: I copied and pasted all Supplier IDs from both import dates into Excel and then removed duplicates.In a new table with auto number index, I added that list into two linked Supplier ID fields, and each of the fields linked to the views 1. Jan und 1. June. Then, I added two look-up fields for the performance of each date.My goal was to have a list showing either the relevant performance per different date fields or bla

I’m using a 2 level hierarchy. I added color based on a condition but its acting on the child records, not the parent records. Is there any way to do this?

Bonsoir la Communauté, voilà mon problème : dans ma table “Membre” j’ai le champ (type Date) = Date_Naissance et le champ (type formule : DATETIME_PARSE(DATESTR(DATEADD(DATETIME_PARSE(DAY(Date_Naissance) & "/" & MONTH(Date_Naissance) & "/" & YEAR(TODAY()), "DD/MM/YYYY"), 0, "days")),"YYYY-MM-DD") ) qui me calcule le jour de l’anniversaire du membre.Jusque là tout va super bien, cela fonctionne très bien.Maintenant je veux créer une automatisation qui dit : quand un membre fête son anniversaire on envoie un mail.J’ai également le champ “Mail” (type Email) dans ma table. Je choisis :Automatisation personnalisée et au test tout est ok Le problème vient du mail :

 We are not using Comments and instead developed a separate “Updates” for team members to make updates to projects. We want the ability for users to “tag people” but looking for a way for those people to get an email or Slack notification. Any thoughts how to do this?

How can a newb find his webhook url so i can have vapi communicate with airtable -   i have this set up in another account and copying all to a new client account - and i can not rember how I got the url to add to vapi?  halp if you can

Hi,In my Airtable, I have a simple Work Order app, connected to Softr.My tables are: Owners, Units, Work Orders. All 3 tables are linked.I would like to automate (autofill?)  “Owner’s Name Surname” in Work Orders  tableWhen a user chooses an Unit (like in WO 6),  Owner’s Name Surname  should be automatically filled (in WO 6 -  “John Doe”).(I can rearrange  Owners  table, and make   Owner’s email   as primary field, if that will help)I have tried different Automations, but I couldn’t make it. Thank you very much. 

I just tried out automating sending some emails with Airtable. Is there a way to remove the Airtable branding? The „via Airtable“ in the from field, as well as the „Sent via Automations on Airtable“ at the bottom? Thanks!

Hi all,I have a very strange behaviour with Airtable attachments together with make.comIn a loop in make,com, I create 4 images using FLUX.  I upload the generated images using "Create a record" module together with some other data (attachment column type) The images are correctly uploaded to the Airtable. Later in the same scenario I use the “Search records” module in order to retrieve the 4 rows with the images The rows and data are retrieved correctly but in *some* cases (this can’t be reproduced) the returned data for one of the images  contains only the ID and the original URL (that I used to upload the image) instead of the Airtable data with the airtable URL and the thumbnails, etc..See the screenshots:The first one shows the Create Record and the circled field contains the URL for the upload The second shows the wrong result for one image (yellow) and the correct result

I used to have a “cool” username, now it changed and there’s no way to change it even though I was/am a rank of “5-Automation Innovator”. IT says you have to be above rank 3- Contributor level 3. Then I should be able to navigate to : Settings>Personal>username to change it but it does not exist in settings?

I’m running into an issue while trying to set up an Airtable automation that links records across two synced tables, but I’m getting the following errorInvalid filter on field A (Invalid filter value: [ { "linkedRecordId": "rec0hJCM2U7BBdWWa", "value": { "id": "recvaxWZ99uQ8cYia", "name": "12345678" } } ]) I'm trying to locate a field value in Table 1 with Table 2 using Find Records, and then link the records via the Automation.Setup Trigger (Table 2) > Find Record (Table 1) > Update Record (Table 2)I have done almost the same type of Automation in another base (which is working fine) and the only difference is I am now working with 2 synced tables in Find Records - in the previous one i created it was

Have built 4 tables to collect inventory information on our fire department’s truck inventory.Tables:cabinets i.e. E-211 Cab. #1 items i.e. 2 1/2” Brass Male to Male Coupler inventory: list and # of item in each cabinet archive inventory: because the governing body wants it.I am trying to create this using Interfaces. What I am trying to do is use a Record Review template that has the cabinets in the left pane and the inventory items for each cabinet in the right pane. I have been successful in that. I have a working Inventory Interface page. The item list is complete (2,501 items). The Cabinet list is complete (65 cabinets).Truck Captains will use an iPad to open Airtable to the Inventory interface and choose one of the truck/cabinets they are responsible for from the left hand list and check off the inventory items they find. If they find an item missing or the quantity less than that listed they will enter that num

Hello, Currently I have a date field called Date, I would like to make a formula that looks at this date and outputs the first Tuesday of the previous month.Example{date} - Shows March 13, 2025Formula - Should show February 4, 2025 (First Tuesday of Previous Month)I was able to find the 1st date of the previous month utilizing this, but I cannot seem to figure out how to get the first Tuesday. DATETIME_FORMAT(DATEADD(DATEADD({Date}, -1, 'month'), -(DAY({Date}) - 1), 'days'),"MM/DD/YYYY")