Ask the Community

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

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 tha

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

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-

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 pr

I'm building a planning tool, and have got a bit stuck with this.I'd like to be able to display a timeline view, which is organised by groups.I would also like to display plans that do not have a group yet assigned to them beside this. Ideally I'd be able to drag the plan into the timeline view to add it to the correct group.This doesn't seem possible, but I'm posting here in case someone is aware of a way to do what I'm after! Google and airtables AI chat bot hasn't helped too much.

Hello! I’m new to Airtable and could really use guidance on structuring a base to serve as the central hub for our content production and management. Currently, we use Asana for task management and Airtable as a content calendar, but the workflow between them is clunky and inconsistent. I’d like to consolidate everything into Airtable in the name of consistency, efficiency—and my sanity.Current Workflow ChallengesArticles: Articles are manually brought into Airtable only when it’s time to promote them, not immediately after being published. However, articles are often updated later (e.g., older articles being rewritten or reviewed). This creates inconsistencies because updates in Asana don’t always sync back to Airtable.Rewrites: Older articles that need rewriting go through a full workflow in Asana (essentially the same steps as creating a new article).Reviews: Recently publish

Hello, I have a lot of text in a cell LONG TEXT (I extract a little bit of this), I need to create a new Formula column to extra only the telephone number, what can i do? Buonasera, Chiedevo disponibilità per parziale permuta con mia autovettura MASERATI 4200 SPYDER del 2002 ASI - TARGA ORO 37.000 Km circa colore Argento scuro capotte e interni BLU. Macchina sempre tagliandata da rete ufficiale kilometri REALI io sono il 3 proprietario. La settimana scorsa ho inserito annuncio su AUTOSCOUT 24 .. chiamano in tanti ma tutti senza soldi.. Cordiali salutiRispondi ora:MARCO PxxxxNI E-Mail: praxxxxxx@gmail.comTel: 339xxxxx00===Veicolo===========================================