Ask the Community

I can't figure out why an automation is not performing as expected.You can view the test base here: https://airtable.com/appvus4mpIsM95P1S/shrcfwha5Sx1NEui9Please see the Content, Tasks and Task Templates table.The logic behind the automation is that when the podcast status on the Content Table is updated to "In Progress," the automation will generate a set of tasks for that episode. The automation looks for records in the Task Templates table under the Podcast View and duplicates those records in the Tasks table.The automation is creating extra records in the task table and I can't figure out why. There is no pattern to the extra records created. I've tested and tested and it's not the same duplicate records each time the automation runs. The extra records created in the task table break the date dependencies."Start Date", "Deadline", "Duration" and "Predecessor" work as expected in the Task Templates table, but when the automation creates the records in Tasks table, those same d

In our base, there are about 10 people from 4 different departments. They are all editors, and we're on the business tier. We've started to build quite a lot of interfaces, and it's starting to get a little crowded. I wonder if it's possible to only have certain people able to see and access certain interfaces?The documentation alludes to the possibility of sharing the interface. However, I can't get it to work, as anyone seems to be able to see and access all the build and published interfaces with or without sharing. Is it possible to restrict access to certain interfaces if they are base collaborators? if so how do I do it?

Is this a bug, or am I missing something?My left side axis (first y-axis) uses a formula percent field. But I want the second y-axis (Y-axis (right)) to just be standard numbers in order to show the COUNT. The percents showing up don't make sense there. Is there a way for me to fix something I'm doing?   

Help! I'm trying to get an estimated calorie count using workout time, weight, and intensity. My workout time field is a lookup field formatted as duration. The weight is 160, the duration is 39:00 and it is moderate intensity. The formula is returning 16,770 instead of 279.5.  What am I doing wrong?Original formula:IF({Workout Type} = "Primary", IF({Workout Intensity} = "Low-Intensity", {Primary Workout Duration (Minutes)} * (4 + (({My Current Weight} - 125) / (185 - 125)) * (6 - 4)), IF({Workout Intensity} = "Moderate-Intensity", {Primary Workout Duration (Minutes)} * (6 + (({My Current Weight} - 125) / (185 - 125)) * (8 - 6)), IF({Workout Type} = "High-Intensity", {Primary Workout Duration (Minutes)} * (8 + (({My Current Weight} - 125) / (185 - 125)) * (12 - 8)), 0))), 0)

Our organization is currently on the team plan and as owner of the team plan, I want to grant owner permissions to another user but it seems this is not available on the team plan.  Is that correct?  If so, why not?  Please consider improving user management on the team plan.  It is not very user friendly and limiting.  

I have a field that sometimes has a mentor's name in it, and other times (usually) is empty.I am showing that field in a timeline - which is fine when there's a name, but otherwise it shows up as "(empty)" which is annoyingI want to create a formula field that shows the value when there is a value (a name), but shows something innocuous - like an asterisk - when it's empty.I feel like this is an IF statement - but the value of the field is different all the time - Joe Schmoe, Jane Doe, etc.IF({Mentor (from Link to Forms)}, "", "*") is what I'm trying now, but it's giving me a blank where I want the name. What is formula for "the value of the field?" Thanks for your help!

I am trying to get this to change the retention stage to month 2 when then 1st day in the field is one month ago?I have done this and whenever I am testing and changing the 1st day in the field to over a mo nth ago it does not even register the trigger on the automation history? Any ideas what I am doing wrong here?

I have an Airtable base with two tables: “PT” (where students submit a form to reserve a date) and “Available time on Math Classes” (which lists all possible date/time slots as text in the format “M/D/YYYY h:mm A” as a linked record). In PT, after a student picks the first date, I use a formula to calculate three more weekly dates. Then I add a filter to find each date in “Available time on Math Classes” and hide them, so whenever the students are willing to book a date and time the other students can't book the same date/time.Despite having matching text formats (and manual searches confirming these slots exist), the Find records step in the automation always returns “No records found.” I need help pinpointing why the automation won’t recognize an exact text match and ensuring these additional dates are properly found and marked as booked. Or I need a way that could hide the other three dates from “Available time on Math Classes”. Note: 1- the “Available time

Hi Community,I've created automation for sending an email using the 'send an email' action and it doesn't work for non collaborator's email addresses.It fails each time with the error: "invalid email address"I'm using a pro billing plan, so it's not supposed to be a problem.Does anyone know what might be the problem? Thanks.   

Another problem with the Android interface!When someone sends a comment on an interface and adds an "@" to notify a user, the user receives an email with a hyperlink labeled "view comment."When you click on the link on a computer or an iPhone, it opens the app and navigates to the correct record within the interface.However, when I try clicking on this link on an Android device, it redirects me to the base instead. My client only has access to the interface, not the base.Has anyone else experienced this issue?

Ok, This community has become my safe space and I appreciate all your help!Essentially, I have a list of content and I have multiple clients linked (with their emails) to each line item so a certain email can be sent to certain people on a scheduled date. My challenge? My automation keeps sending one email to ALL parties, thereby sharing email addresses. I need an email to go to each address. In the below pics you will see I have a 'repeat for each in List of records) and this is preceded by find records where Issue Date is today. The right records turn up, and the email works, but to my mind it is not actively 'repeating for each'.I feel I could drill down to the Client tab for that info, but I don't think I'm going about it the right way. Relevant Fields:Table 1 - Content - Send date, Lookup For Client (multiple records), Email (from Client)Table 2 - Clients - Customer ID, Email TIA,Chelsea

Is there already docs or complete process on how to use airtable webhook api to bubble? Like if the data is created in airtable it will call a backend wf then viceversa in bubble.io to airtable.

Hi, is there a way to colour the background of cells, or better whole columns? What I’m trying to do is categorize the columns into different sections in a large table. I guess it is not possible since the filter and sort features colour the background of the according columns. Is there some other way to categorize the columns? Many thanks in advance!

I would love the ability to add a color background to the cells in a particular column. This would greatly help in making the column standout. Is this possible? If not please add this functionality. It’s very easy in Excel. Thanks

I am creating a scenario in MAKE to add a new record to my student database once a student is marked as enrolled in my admission database. Everything works well, but I am facing one issue. I am able to use the HTTP Module and “Upload to Google Drive” Module to add the student photo correctly to the student database. However, I have two other file fields in the admission database that need to be synced, and they contain multiple files. How can I ensure all those files are added without missing any to the student’s database?

We currently use the Kanban interface to track our sales bidding pipeline. When a deal is ready to advance between some stages of the sales pipeline, I'd like to require the salesperson to enter data in key fields before they can move the deal. As an example: To move the deal from "Open Bid" to "Won" they need to enter a start date and a contract value for the project. Is there a way to prevent the user from moving the deal to "Won" if they have not entered data in the "Project Start Date" or "Project Value" fields? I'm happy to use a third-party tool if needed, but so far, my impression is that the only available tools are extensions for data validation when using forms. None of these seemed to work in the Kanban Interface.ChatGPT suggested writing a script that at least notifies the user that they haven't entered the data, but it wouldn't prevent the user from moving the deal. The other option was to write a script to revert the deal to the previous stage if the data is missing,

Hi there- I have a list of around 200 e-mails that I would like to search for in my table, so the “filter” function is not going to work here. Is there a simple workaround that will allow me to create a grid view of just these 200 e-mails, from a list of thousands? Thanks!

My challenge is to do a search that looks for records where my input is part of the company name. So essentially I am looking for a "contains" function.Example searches:1.Input: "sephora"Target: "company" field in record: "SEPHORA Inc."2.Input: "GoSports"Target: "Go Sports Inc."I guess the second example won't be possible but my plan is to just get all the matches based on company name, then name of the record and description and then let AI do a matching by probability and my other form inputs.I am using the search module in Make.com.My guess was to use either "SEARCH", "FIND", or "REGEX_MATCH" but no luck so far with my tests.

I have a list interface where the button to search disappeared after making unrelated changes to the interface. The search option still appears on all my other list interfaces and I can't find anything in the designer to either add or remove the ability to search the list. Any suggestions?

Why doesn't Airtable allow adding multiple pages to an interface for displaying different views?

I really like the new Overview Interface including the new Links section that allows you to connect to external URLs.  I'd really like to use the links feature on other Interface types.  For certain applications, they are better than using a button.  I don't think we can do this today.  Just thought I'd post this to make sure that I'm correct.  You never know, maybe I'm missing something.  If I'm not missing something, Airtable folks, please provide this functionality!!

We have had a number of our users raise an issue where the "Current user" value is not always being currently set as the default value when a accessing our interfaces ... it appears to be populate with the "last" user who accessed the interface!Has anyone else experienced this issue?

Hi Team,Has anyone successfully integrated Data Cloud with Airtable? I have followed all the steps provided on the Salesforce website to set up the integration but have encountered the same issue described below.@Patrick_Baker a community member, also faced a similar challenge while attempting to integrate Data Cloud with Airtable and was stuck at the same step. I am currently experiencing the same issue. You can refer to the communication thread for more detail.https://community.airtable.com/t5/automations/linking-airtable-to-salesforce-data-cloud-using-the-beta/m-p/199422#M19337It would be greatly appreciated if someone from the community who has successfully completed this integration could share the steps.Thanks in advance.

Hi everyone,In Airtable, I created the a tables with 30 records and I have already sent comments for each records in Airtable. Then connect the Airtable and Tableau using web connector."Now, I want to display these comments as a separate column in  Tableau Desktop automatically and also wants  the newly added commenting records to show in Tableau desktop automatically without any third party tools".Could you share any detailed steps or alternative methods to achieve this?Thank you...

Hello there,I am very new to Airtable (just started two days ago) and I am finding that there are so many things that can be done here so I am very eager to learn. So TLDR, me and my friend has a small business where we need to find suppliers and ask for their quotations for bidding purposes. We have been very overwhelmed lately and want to leverage technology to help us automate some of the jobs. I have a problem with configuring the database right and would appreciate any insights from you guys. Working Process:Currently, our working process is quite redundant and consumes so much time. So first, the purchase request will be decided by us on what items to buy. Then my colleague will print out those items (Row) along with some potential suppliers (columns), then we will work together to pick which supplier we will ask for each item. Also it should be noted that in each box, there may or may not be past price (if we ask them for quotation before). After that, my colleague has to t