Ask the Community

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided municipality and local chapter. This information we gather from a Typeform. I have matched the options in my Typeform and Base/Field as a single choice. It works well until den, but how to make it work in Airtable is the next step. This is not in the US. There are around 5000 post numbers that are going to be distribute in 15 "municipalities". Some chapters allocate more than one municipality.Is the single choice the best one for this purpose? Would an IF formula work?What is the most effective way to do this with that amount of data? 

Hi everyone,I'm looking to create a use case catalog to help me define the functional requirements of my clients, such as data and system integration.The catalog should include a unique identifier for each use case category and allow me to choose which categories to include in a report and which to exclude, depending on the client's needs.The ultimate goal is to create an environment for the client to experiment with the use cases and required functionality without exposing them to the full repository of use cases and their categories.The goal is to eventually generate summary insights through a dashboard/summary table that shows the use cases by data or integration slices.Has anyone come across a solution like this? Do you have any ideas on how to approach the topic?Thanks in advance for your help!

Hi there - I've set up a table that I want to use to 'score' certain projects by quarter. I.e. at the end of Q1, Project 1 received a 50 score, Project 2 received an 80 score, Project 3 received a 100 score, so on and so forth. Currently in my table, the projects are separate records, and I have four columns - Latest Score, Q1 Score, Q2 Score, Q3 Score, and Q4 Score. They are all number fields. I've inserted a photo below.Is there a formula that would enable the Latest Score field to automatically reflect the current quarter we were in without me having to update it manually? Thank you!

Hi all, I am using Airtables to set up my cost database for my cafe.For each dish, the items can come from 2 sources. 1 -  A raw material table - i.e. chicken, eggs, which i have already listed it's unit cost. 2 - From a Prep material - i.e. like pasta sauce which we make in house. This table, I've already calculated the cost per portion for each item (making reference to items in table 1) Now to build a recipe, I need to pick items from both table 1 & table 2.   I am not sure if this is possible to have a selection field that reads from 2 table.  or I need another way around it? Thanks!

Hello,My team and I have many due dates scattered around as we are show managers.I recently built in a formula based off of weeks out from show time that the item needs to be completed, and how long it takes to complete it to in order to find out when we need to start the task.I'm currently trying to send a weekly Monday email at 8am that sends to each assignee informing them on the upcoming start task dates coming up within the next week but have run into an array of issues and I don't know which angle to take it on.Is it possible to automate this or is this too many fields? I have been reading a bunch of community forums but all have one part of what I need, but not completely.Please note:Some tasks have multiple assigneesThis is for a view within a viewAny insight helps as I am fairly new to Airtable's automations and feel like I've done everything.Below are the column fields on my base.Once again, I'm trying to complete the following automation:Email individual Assignees every Mond

Hello,I'm working with the following table in Airtable:My goal is to create another table that simplifies the data. Specifically, I want to generate a single row for each unique ID, where all the text from the 5th field is concatenated into a single cell. Here's an example of the desired output:"Consider installing a longer bath handle. Doesn't completely rest on the bathtub.""Repair chipped tile due to shower column installation. Replace the shower column with a wider one to conceal the defect. Alternatively, replace the tile.""Adjust bathroom cabinet drawer."Important Note: I have thousands of IDs, each with multiple text entries like these. I need to concatenate them to streamline the process of sending email alerts. I've tried various formulas, but I'm a beginner in Airtable.I appreciate any advice or guidance you can provide. Thank you in advance !

Hi, I wonder about how to setup my base for the following?I have a simple Table with a series of records, and each record has a 'SPECIFICATION' field (basically a "YES" / "NO") indicating if we have the spec. for this item:I would just like to somehow summarize if *ANY* of the records there have a "NO" in them? I don't need a count or anything like that, just a flag or note or something to say if ANY items are incomplete? Is this possible somehow? Can I show this another 'Summary' Table in some manner?thanks for any suggestions!@Ed12_p_may

I have a list of elements in a single table I want to be able to demonstrate many-to-many relationships between them. I created a linked record to select elements, but it doesn't update in the record for the selected elements. How do I get it to appear in both places?In the screenshot below, when I link "Element A" to "Element B" and "Element C", I want "Element A" to populate in "Element B" and "Element C" records too.But "Element C" also needs to link to "Element A" and "Element D" and "Element D" needs to link to "Element E".How do I set up this kind of relationship within a single table? 

This is Conditional Logic that is very simple, one of the conditions is the "has any of" and that is selected from the single select field as  "CTC" and then it just fails and shows the result from that field as [object Object}. What is causing this? See attached screen shot.

I guess this related to an integration, but it's not an integration-specific question. We have records that typically accompany a unique number. Sometimes, we will have a record that doesn't have a number. To identify them as records where we've thoughtfully considered them to be records associated with no number, we want to use 0000 as the default, where a single 0 might mean we just forgot to enter the appropriate number. I'm using a Number field currently -- and I think the field needs to be a number field for the integration. Is there a way to get a Number field to display 0000 instead of 0? 

I have a synced table which I would like to not sync anymore, but I want to keep all the data currently in it.  I know I can just duplicate it, but that would mean I lose my interfaces and automations.  Anyone know if there's any easy way to turn a synced table into just a regular table?

Hello,So I am trying to make a column where if a user updates their date of birth it will change their date of birth in a different table. The issue I am running into is that when I change the date of birth for any user it just changes the date of birth of the first person's date of birth in the second table.How do I make it so that if a user puts in their date of birth it will change onto the other table on the line specific to where their name is?

Hi everyone, I’m a big fan of Airtable, but its lack of a spelling/grammar checker is causing me some grief. Grammarly (Chrome extension) would seem to be the perfect answer. However, it doesn’t work. At all. This is weird because it works well on other sites with text input fields - including, incidentally this community site (I can see Grammarly flagging errors in this as I type :slightly_smiling_face: ). Does anyone know a way of getting Grammarly to work on Airtable Grid view fields or indeed another solution? Thanks!

Hi all,I am using a Matix extension.  How would a user search for a value in the matrix?Using Control F only shows (and highlights) matching values that are visible on the screen (even if the value exists, but not visible on screen).Any ideas?  I recall a chrome extension that may help but have to search.Thanks,Paul

How do I change the part of my bio that says "5 - Automation Enthusiast"? I may have selected that option when I signed up as to the Community but that description is no longer accurate. Thanks!

Hi All,how would I amend the formula below to include Working Days of Monday to Friday and working hours of 9am to 5:15 pm in the out put? INT(DATETIME_DIFF(NOW(), {Credit decision date}, 'hours')/24)&" Days "&MOD(DATETIME_DIFF(NOW(), {Credit decision date}, 'hours'), 24)&" Hours "&MOD(DATETIME_DIFF(NOW(), {Credit decision date}, 'minutes'), 60)&" Minutes" 

Hi all,I see in the API documentation that there's an endpoint which can provide information about an interface (aka page bundle, aka section).But in order to use it, I need the interface ID, and I don't know how to list the interfaces. I know that as an Enterprise admin, I can visit https://airtable.com/admin/[enterpriseId]/interfaces and search or download a CSV, but as you can imagine all that proves is that there is an actual API endpoint, I'm just not sure how to access it 🙂 Making it even more frustrating, the interface IDs aren't even available in the URL when you're browsing the interface, as far as I can tell.Does anyone know if I'm missing something and there's a way to get the page bundle IDs programmatically?PS if anyone is aware whether Airtable has shared anything about developing a more robust metadata API for interfaces (list pages, list fields and their configurations, etc) that'd be awesome. 

When sharing the interface and a user requests access, the email with the access request link is not being delivered. The user is not receiving the email containing the necessary link for their access request. Could you please look into this issue and assist in resolving it? Swift resolution is essential for our workflow.

Hey there 👋Web API documentation generated for a particular base is very well built and very useful.I wonder how to share this API doc because the dedicated URL is not public.Thank you for helping.

Hi there,I have an AirTable base that has been used for over 3 years.  The original creator (owner) has not accessed it for over 2 years and now is no longer with the organization.  How can I move the permissions, so someone else has owner designation?Thanks in advance,-Robert

Hi, I would like to add a pop-up for one of my automations. It's triggered by button. Automation creates a record based on input from different table. I'd like to be able to have a communicate lik "created successfully" or "creation failed". Is there a way to do it?

I have a complicated string of formulas that is setting due dates. The short of it is I have a "complete" column (checkmark) and "Date completed" (static field). A task is completed and marked with a checkmark in complete where it stays visible all day, then at 11PM, today's date is added to "date complete" which filters it out.  The date complete is the base for a series of formulas in another table which basically determine when to reopen the task as being due again. I've been struggling to figure out why my formulas aren't behaving as expected and I think it comes down to timezone. The most granular failure I can find is a plain formula for "today" - that is the whole formula just "today()" ... the automation pulls the data from that column to drop into date completed and "today" is wrong. I've tried manually setting all date fields to CST, I've tried leaving them all as the standard GMT, I've tried "use same time zone" in formatting and I've used the "set t

Hi Everybody,I have an Airtable table already populated.There's a field called <<Status>> set as a formula that takes either the value <<OK>> or <<Not OK>>I want to set an automation that calculates the number of rows with the field Status = <<OK>> for each day.Ideally, I want the results to be shown like this  DATE                                                        Number of OKs15/01/2024                                              3216/01/2024                                              28......Thanks in advance for your help.Just for information, I am a beg

Hi, I'm looking for a way to create an interface that hold a list of records, that will display a required record only when looked for. kind of reverse filtering.for example:I have a list of of possible types of documents available to the customer.I want the list to be empty, but when he fills a filter with a certain value (for example:invoice), the record called "invoice" will appear.Any Suggestions?Nitai 

We have SKU's that are bundles and comprise of a combination of other SKU's.So an SKU can be sold individually and also be sold in a bundle.Example -SKU-1 is a bundle comprising of SKU-2 X 1 unit, SKU-3 x 1 unit and SKU-4 x 2 units.We will be pushing sales data into Airtable that will give us monthly sales by skuWe would like to see sales data of all SKUS by accounting for the components in each bundle.Sample base here.Products Table lists all products. Any SKU which is a bundle is marked as a bundleSales Table shows the sales for each SKU by monthBundle table shows all components of each Bundle and the quantity of each component in the bundle.(Multiple bundles can have the same SKU)So SKU-2 should show it's individual sales as a product (31 in June) + it's sales as a component of SKU-1 (12 in June)In the same way SKU-4 would show 76 + 12 X 2 ( as SKU-1 consists of 2 units of SKU-4)How could we approach this please?