Ask the Community

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

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 published articles will get a second review a few months after publication. This review process is managed in A

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======================================================Guarda l'annuncio:Thank you very much!

I am very new and only working on a free account and have run out of free ai chat credits. I am trying to follow a youtubers work flow to create blog articles and post to my wp site. workflow is as followsWebhook-->Airtable-->Claude-->claude-->JSON-->Cluade-->Tools-->OpenAI-->Openai-->markdown-->Google Doc-->Google doc-->Airtable-->wordpress.some of the double cluade and openai were create prompt then create article/image.Webhookhttps://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3Airtable layoutBlogs Posts RecordID | Main Keyword | Generate | Outline | Complete Google Doc | Google doc image | StatusWebhook in Airtable ( generate tab )"https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3?RecordID={RecordID}" RecordID tab RIGHT("000000" & RECORD_ID(), 6) nothing in Main Keyword tab. so work flow is  click new row in airtable = generates new RecordID and a "Generate" button I add in the "Main Keyword

Hello everyone,I'm new to Airtable.I need to administer a standardized test consisting of several questions to several people every month.I would like to be able to record the answers so that I can follow the evolution of the answers over time and according to the people.I can create the list of questions and record the answers, but I can't create separate entities for each date on which the questionnaire is taken.Could you help?Thank you in advance for your help!

Hello,I'm new to Airtable, and have been struggling to find the best way to solve my problem.I apologize if there is a similar post for this problem, but I couldn't find any that helped me to solve mine.I'm currently designing a base with multiple tables where there is a repeated and fixed information that needs to be reflected in different tables and different tables have different purpose and calculation. Thus, I would like to know if there is a way to create a reference table where I can update the data once and have it flow to other tables as needed.To give more information about what I'm trying to accomplish, let's assume that there are 4 tables.Table 1 - Reference TableTable 2 - InvoiceTable 3 - BillingTable 4 - ReceiptIn tables 2, 3 and 4, there is a fixed amount that needs to be repeatedly reflected for different calculations called and let's assume that the field is named as 'Gross Item Price'. Instead of creating a formula field to reflect the 'Gross Item Price' of $500 (whic

Hello there,I'm starting to migrate from an old Access database to Airtable.  Part of this Access DB was used to track a number of groups and the days/times they meet per week.The data is in two tables, Groups and Meetings.  Groups is just a list of groups which has a one-to-many relationship with Meetings which is a matrix of a time-of-day and day-of-week:It shows in a report like below.  The letters in the boxes are different meeting formats:I have imported the data into AT and linked the two tables.  The issue is that all of the time-of-day and day-of-week data is getting combined into fields.  I understand that is what is supposed to happen.  Is there any way to link records and keep them separated in a one-to-many relation?Here is a link to a Base with the sample data: https://airtable.com/applQ22GX9Mh4QaAI/shraUgGlLA5zlOKoiThank you for any insight you may be able to provide!Jason

Hi, i'm a total novice and really struggling with an automation, any help greatly appreciated pls 🙂My client hosts quarterly events, attendees register via airtable form. I am familiar with creating the form and the automated email reply. But thereafter the client would like to check the existing 'Contacts' tab to see if the attendee is an existing contact:If so, do nothingIf not, create a new contact in the 'Contacts' tab.I am stuck on the find records step, I'm not sure how to ask it to check the contacts table. When I look online it says to do find records, but I'm not sure of the conditions.Thanks in advance for any help

I have a single base with a single table, that we use to track a large number of to-dos that we then assign to a handful of different users. There is a "boss" who has access to an interface that has a view that can see all of their tasks that he has assigned out (Master Interface). He will go through and leave comments from the Master Interface interface within the record, and tag the individuals so they are notified via email.We have separate interfaces so that individuals can only see the tasks assign to them, but when they are trying to open the link notifying them of their comment, it is trying to bring them to an interface they don't have access to (the Master Sheet).Can someone please help me figure out a way to use this functionality the best that will keep the following true:- Each individual can only see the items assigned to them- They will be notified of comments they are tagged in via email- Clicking the link the in the email will bring them to the correct record in an inte

Hi,I am looking for consultants to help with building a relational database in Airtable with our data. I am looking for private consultations and not courses. Please email nishanthi@redabbeylabs.com with details in addition to replying here. Thanks a lot!

Is there any setting to mess with or extension to install that allows you to have an attachment open, but not fill the entire browser? Unfortunately some of our uploaded attachments are scanned & handwritten PDF forms, but ideally I would like to be able to open the attachment easily in a side panel so I can both view the PDF and still access the grid view of the records and edit a few of the fields. For example, the PDF may have a date on it, name of who prepared the form, and a task all handwritten on it. It is uploaded to the table which creates an essentially empty record that just has an attached PDF and I need info from the PDF to fill out the rest of the record. Side by side would be ideal (some of the handwriting is beyond any type of attempt at image rec).

How can I fix this? It is a mobile made interface. On desktop I can see DATE as part of the dropdown options, on mobile I can't. On mobile even if I click the three lines icon to display more DATE is still isn't there. Any help is appreciated. Thanks

Hey Airtablers,I want my sales guys to be able to click on a button, and have it perform the following functions:- Update the 'last contacted' field- then create a linked record- then open that record into expanded view <-- This is the step I'm having issues with.I can't find a script or automation that opens records in expanded view. Right now they have to click the + in the linked record field, then click the + in the drop down menu to create the linked record. It 'works' but there's room for error and I want this to be as simple as possible for them while they're on the phone. This is what that looks like:Any ideas would be greatly appreciated!Paul