Ask the Community

Hi,I’m relatively new to Airtable and I want to use it to help track inventory. I’m not familiar with coding or complex formulas and I’m thinking those are the exact things I’m going to need to pull this off…Ideally, I want a base that has a full list of inventory and user capabilities to allow checking in/out different items. I want quantity to auto-update based on in/out. The user facing side needs to be very simple and easy. Originally, I was thinking a form where the user will type in the ID and whether they're checking it in or out and it will auto update the quantity but now that I’m trying to work through that- it doesn’t seem very straightforward. A form recording every single response as a new line item is not useful in this case.Quantity number will be very important because I want a dashboard that displays what items are available and where to find them. Any guidance would be incredibly helpful- other posts, help pages, formula suggestions, general layout, literally anything

I found this post: Help creating a script to tag products with keywords from product titles.  Using the code with the adjustments the script runs, but not well.  I am hunting keywords in course descriptions for a sustainability tracking and awards system.The problem is when this searches for keywords it's too literal. If the course description has "...equal.." then it will attach that link. If the description has "...equality..." it will not. Originally the keyword list had the asterisk wildcard, which meant there was a lot of things it wasn't finding because it doesn't seem to recognize that as a wildcard, but that lack of wildcard means it's missing possible links now. I would prefer not to add every iteration of "equal" to my keywords list though.How do I address the problem I’m experiencing programmatically?

Hi Airtable Community, I’m attempting to send an email every time a new record is created. The message of the email should include the contents of every field that has data in that new record. Our fields are added to regularly, and I do not want to edit the automation every single time a new field is added to our table.  Is there already a known solution to this, that will automatically include all fields with data in the message of the email without pre-coding the specific field into the automation?  Thank you,Danny

I am having users attach photos and I would like a way to show the size of a file so that we can have an indication of the size of the file attached. Doesn’t anyone have a solution for this? Thanks in advance for your help.

So, I have some data that looks like this: 二代目 歌川広重; 1826 - September 17, 1869I want to sparate the japanese name, at left, from the dates, at right. It’s not always Japanese, but it is always seprated by a semicolon. Formula suggestions? Thanks in advance!

My table has two checkbox columns that are set to show different symbols for True. “Actively Working” column is set to show a yellow star. “Hide” is set to show a red “x”.Both of these columns are showing a mix and match of both values (see photo). It is happening in the app on both ipad and phone. Individual records opened up show the correct value in the correct column. Anyone else having this issue? How do I resolve it?

I want to put a hyperlink within a long text field called "notes" on my calendar. I can't figure out how, so any help would be great.

Hi,I have two tables - one that has projects with tasks and one that has employess. Each task field from the different projects is linked to the employee table. When I want to assign an employee to a task, I link the employee record to the task in the tasks table. This works fine.However, when I go to the employee table, I want to see a list of all the tasks assigned to each employee.How do I make it show up automatically?

I’m new and just learning Airtable. I know that other flower farmers use Airtable already, but I haven’t found many resources about how exactly their Workspace is set up. I’d love some input regarding keeping track of items such as a master crop list, year to year crops, maps, task calendars, inventory, clients, products, newsletters, vendors, etc. It doesn’t necessarily have to be flower specific as the veg community has a ton of overlap. 

Lets say I am linking a People Table and a Projects Table.In the People table I want a column that has all the Projects Associated with that specific person. In the Projects table, I already have all the projects listed along with the associated person. When I ‘Link from Another Record’ from People to Projects, nothing populates. I’ve tried the LookUp as well but nothing populates as well. 

I'm encountering an issue today with the Airtable interface. When I try to add a chart, table, etc., by clicking on the plus sign, nothing happens. Do you have any ideas about the source of the problem? I don't think I've exceeded the limit of 50 pages per interface, as I have deleted some content, yet the issue persists.

Hello everyone, I have a pretty specific question form a form I want to have connected to my site. So I want to have a contact form on my website that is kindoff a two step process. First step is the user inputs their name, number and address of the property. Once the user inputs this info and clicks get a quote, it will take them to the second part of the form where they input just a couple more details.Ideally what I want to happen is this:If the user completes the first step but upon moving to the second step decides not to complete it because of time it would take to fill out, I still would like the info that he submitted in the first step to be submitted to airtable. Is it possible to do this? 

Hi everyone, I have a problem with Lock view. I have a view that I lock so that other people can’t modify/change my data listed there. but when i try to share this view. the toolbar for fields, group, sort, etc is not locked and the person that is using the shared URL can use it.Is this a bug or thats just the way it is?if yes, then is there a workaround for this?thank you in advance  

Hi,I am having an issue using automations and having a message sent in Slack as the final step. I have a formula that looks to an estimate and creates a budget off of that number. I then want to take the data from that field and enter it into a slack message. The problem I am having is the number I am using from the field ( as an example) is 75.6. It is being output from the Slack automtion as 75.61953142857142. No matter how it gets formatted in the formula cell (i.e. with no decimal points, ROUND formulas, etc. the long number always gets output from the Slack message. Is this an inherent flaw in the automations or am I doing something wrong? Thanks for any help in advance.  

This formula is very handy DATETIME_PARSE({WEEKNUM}&’’,‘w’) however I need the first day of a work week to be and Monday and the last day of the workweek be Sunday How can I modify this formula?

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 that field will be there f

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?In my case, I’m the only Editor/Owner, and I just need to invite a few commenters, who would only access the base through Interfaces (they don’t need full base access).So the difference in pricing would be significant, and I want to

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 Email And a link to the “Company Partner” field (from “Partners”).🔄 WHAT SHOULD HAPPEN AUTOMATICALLY:TASK 1: When a new delegate is creat