Ask the Community

Hello! the view bar that is supposed to be at the top of the airtable page, in particular such options as “hide fields”, “filter”, “group”, “sort”, “color” etc do not appear on my airtable app when using on my laptop. Same time, option to customise fields with the same above mentioned functions (filter, sort, hide field etc) as well do not show along with the dropdown arrow which is usually located next to the field title and is the way to see list of the above functions. Is there any way how to restore those options/functions and get the view bar with all the fucntions? thanks a lot in advance for help!

Hi Everyone!I would just like some help or insight on the problem I'm having with an automation I'm currently trying to make.The automation is supposed to send an email to the user after creating 10 new individuals (like networks) on a table. I'm stuck on how to do it and I cannot fully grasp the resources on airtable help-center so i'm here to ask for additional help or advice 🙂any thing that can help me understand better  would be much appreciated!Thankyou!

Hello All,I have a base for an order management system where I created an interface (Record Review layout) to display received orders. I added a field for the order status, including options such as "Received," "Damaged," and "Not Received."I want the system to open a new form for adding extra details (Logs table), such as the order number, description, and other relevant details, whenever the user selects any status other than "Received." for individual records or is there any other way to do it without using the third party solution and script.If required any more details let me know in this thread.Thanks. 

I am using fixed for my rescheduling logic for date dependencies in my project management base. The primary reason I am using fixed is I need to be able to create buffers between dependent tasks (i.e. tasks with predecessors). Let's say task A is request a copy of bill from provider and task B is review bill.  I know that task A takes minimal time so I set it to start today and give it a duration of 1 day. Task B is also pretty straightforward and takes one day so I also set its duration for one day BUT it takes up to 30 days to receive a copy of the bill and it's out of our control so I want task b to start 30 days after task A ends. In the timeline view addressing this is pretty simple. I just define a buffer value for the dependency of task a and b.The challenge I am having is that when creating a project using a record template I can add the task A and B along with making task A a predecessor to task B thus enabling automatic calculation of task B's start date b

Hello,  I am trying to create a formula to put together a date we expect something to be completed.Date to Client is entered by my team and is the first part of the equation.Client Timing is pulled as a lookup field from another table dependent on each client as is based in days.  Formula I have is Dateadd({Date to Client}, {Client Timing}, "days").  This equation is taking the client date (ex 12/2/25) and always subtracting one (ex 12/1/25.Is there a different formula I should be using for this type of transaction?

Hi - first timer here!I have 2 tables in 1 base.  Table A contains info about Recipes I'm creating. Table B is where I schedule those recipes for newsletter publication. Recipe names are pulled from Table A into Table B by linking fields. There are 3 recipes per date, so 3 linked fields. So far so good.I want to have the newsletter date in Table B pulled into the corresponding recipe record in Table A. See attached illustration - what formula do I need to replace the question marks with dates?

Hi 🙂I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.Here is the picture from the table I want to retrieve the content from.I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. So every time ITEM = ITEM LV it should the update.The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.I setup the automation like this but it finds no records.Tks for the help

How do I configure Stacked Bar charts? I can’t seem to find any option in the Chart properties in the Interface.

I have an automation that once an attachment field is not empty, it creates a new record in a different base with that attachment and a few other fields.Is there a way, that if the attachment field has more than 1 file, it will create a new record for each one of those files?

I have a table of transactions with a date, the date is formatted in dd/mm/yyyy.I want to import more transactions from a CSV, the CSV is also formatted in dd/mm/yyyy.Simple import right? Wrong!On the import mapping page, the CSV data is being picked up as mm/dd/yyyy even though nothing in my base is in that format. As a result it's confusing the dates and losing half of them.The only way I can make this work, is to change the date field to a single line text, import the data, then change it back to a date in dd/mm/yyyy.Am I missing something or is this a bug?Pics:My table:My CSV file:The import page:It's not even getting the month correct.Very frustrating   

I have a table in Airtable with two fields: "Child" and "Mother" (just an example to explain the structure easily). The "Mother" field is a linked record to the same table. Here’s a sample dataset:ChildMotherRaviSnehaKaviSnehaBalliPrernaMalliPrernaSnehaMotherPrernaMotherI want to add a new field, "Number of Children", that counts how many linked records (children) each mother has. The expected output should look like this:ChildMotherNumber of ChildrenRaviSneha0KaviSneha0BalliPrerna0MalliPrerna0SnehaMother2PrernaMother2I tried using a Rollup field with COUNTALL(values), but it counts each linked record separately instead of summing up the total number of children for each mother.How can I achieve this without creating another table? Any suggestions or workarounds would be greatly appreciated!

So I just purchased Airtable for our business use case. I am devastated to understand there is no support for creating new tables automatically. The only way to do this is to have a custom app script, however this would need to be triggered manually and will not run in the background… Why does the automation scripting not contain the required functionality that the blocks SDK does? Why is this feature limited to only reading table metadata, if blocks SDK can do it - why can’t the automation scripts? This is so disappointing… I CANNOT BELIEVE the standard API does not have a create table endpoint, where you can define the fields automatically. How are we supposed to develop an automated solution if we constantly have to manually press buttons to create new tables… And upon searching the community pages - there is not one response from the airtables team that shows they will work on this feature or when. What a waste of money upgrading to the pro plan to see inside the automation script

It would be incredibly useful if the Slack integration could send a message to a person pulled from a field in a table.As it stands, when using the Slack integration in an automation you have to choose (hardcode) the person(s) or channel(s) you want to send the message to.Use case: I have a table that syncs issues from a ticketing system. Each record has an "assignee" field. When a new record enters a view I want a Slack message sent to the person in the assignee field.

I tend to use the Tab filters a lot for ease of jumping between project types & clients and it would be great if I didn't have to recreate my preferred (pretty long) list of tabs each time or have to duplicate the view and edit. 

I have a table with a date field, an I want to link these dates to another table, but group them by month. This is so I can create rollups for monthly financial figures. I have tried to create an automation to auto fill in another field, using the date as its source and then converting the format to mmmm yyyy, from the usual dd/mm/yy. I then linked this field to the other table, but now the automation does not update it even if it runs successfully.Can anyone help solve this issue?

Hi there,I think I already know the answer to this but thought that I should ask. Is there a way for a user who has filled out a public form to edit the data that they submitted in the past? For example. If I have a form that invites people to provide information about their product which they do, is there a way for me to allow them in the future to "Edit" that information later if the price of description of the product changes?Thanks in advance. S

Hello! I am attempting to assign employees to presentation times and have the automation create the event and invite them to it via Outlook. I've established everything necessary but cannot assign the public calendar in the Outlook: Create Event automation. I also cannot adjust the "From" email. I need to do so because we want the invites to come from a shell email address and not from an individual, and utilizing the Public Folder Calendar in outlook instead of a personal outlook calendar that is shared so that we don't have any interruptions if the owner leaves the company. Can anyone advise a workaround or if this is a feature that Airtable is working on?Thanks!

Hi everyone! I create KPI dashboards for my coaches. It is working fine for two of my coaches but not for 1 of them. I have confirmed that all records are linked to the KPI table. Still now showing! What gives? https://www.loom.com/share/df130c440c6349ceb54177609e888d1d?sid=eacafc33-cfe9-434b-83c5-7874a32452f7

Hi all - here’s my set up: Table 1 - [3 designs] with [multiple components each] Table 2 - [many interview questions] each tagged with [a specific design component] and [one of 3 interview guide types] In Table 1, I link to the interview questions for each component. This is great! I can see which interview questions have been developed for each component. In Table 1, I also want to include which guides the component is tested in. If I add the lookup, it repeats the guide name for every single question. This gives me a set of ~10 “Student” tags and ~10 “Advisor” tags - I really just want to know which of the 3 guide options (student, advisor, instructor) each component is tested in. Is this possible?

I'm looking to send out an email when a record is updated to interface-only collaborators. I want the email to include a link to the record in question.I've got a link to the record using the following formula:"https://airtable.com/appxxx/pagxxx?xxxx=" & RECORD_ID()  But I need to link to the Details section of the record with this link. I.e., my Interface uses the 'Sidesheet' details pane. When I click the email link, I want to be taken to the correct Interface and correct page and have the sidebar pop out too. What do I append to the above formula to make the correct sidebar pop out?

Hi, I'm relatively new to Airtable - still enjoying learning how to build neat things with it!I've noticed that when I'm testing my Airtable forms, my browser doesn't pop up the usual menu of autofill options for things like my name, email, address, etc. as usual. Is Airtable blocking this somehow? Can I un-block that? It certainly makes testing slower but more importantly, autofill helps users accurately enter common information, saving them time and reducing typos and other common errors. Example screenshot attached - starting to type my name doesn't offer to fill out the rest like it does on just about every other form on the web 🙃I searched Google and this community before posting but found almost nothing mentioning this, but got a lot of unrelated things since "Autofill" is often discussed in relation to formulxs [sic] etc. Sorry if this has already been asked.Thanks!-Chris

I want to create look up field for only apartment details in a row that I have in a table called lease tracker in a base The row has 50 columns and lets say I just want 20 columns data to atomically go to the other tables in my base when updated to the specific unit number of a rental building. My current tables in my base are called, listings, building, apartment rented, calendly interaction,  and lease tracker.I want the tables to look up the data in my lease tracker table and put only the apartment details in the other bases.  I have multiple buildings and multiple apartment number listed in two different columns of the table with the other columns so not sure how to look only the specific unit number of a specific building. I already have look up on these other tables to look up the building table and put it on the other tables automatically What is the best option to do this so I can share the individual apartment details with a building with the other tables. 

Hello,I'm trying to build a form where my team can submit a PTO request.I set two date fields, one for date when they want to start their PTO and one for their return date.So I would like to set the return date field to be after the start date.Is there any way to disallow people from entering the same or earlier date as their return date than their start date? I don't really mind how it's done (ie. pop up message, greying out any dates on or prior to the start date on the calendar), but just a way so that people won't be able to proceed to submit their request unless they put a date after their start date as the return date.Any input would be appreciated. Thanks!

Hello everyone.I'm a Korean user, but there are still few AirTable users in Korea, so it's hard to find a solution, so I wrote to the community for the first time.I'm trying to use automation to send messages to Slack that mentions multiple users.I've tried several ways to do this, but while I know how to mention a single user, I haven't found a way to mention multiple users yet.I've tried the following formula and automation, but it didn't work.1. @Mention using a Slack username   <@first.last>   2. @Mention using Slack user's ID   <@memberID>   3. Dynamic @mentioning   CONCATENATE("<@", {Slack member id lookup}, ">")   All of these methods worked when I linked only one record, but when I linked multiple records, they didn't work correctly.ex.)when linking sigle record--------------------------------------------when linking mulitple recordDoes anyone know how to solve

I have a table that uses a form to enter meeting information including who was there (linked field to another table). If I need to add new people to the people table through the meeting form, is there a way to do that?