Ask the Community

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?

Hello, I have a primary field that is a number field that contains sequential invoice numbers. I would like to know if that number field can be converted to an autonumber field that starts at and continues the sequential numbers. It seems silly to have to keep track of the sequence when a computer can do it.Thanks, Scott 

Hello. I am encountering a small problem with a Make.com scenario Goal: Scrape info from an API and update a table inside of Air Table API is running smoothly, all data is being pulled. Currently, the scinerio is only running and creating 20 records total inside of air table. I have a paid subscription and am running into this problem It should run continuously. Anyone have any info about this? 

I have a collaborator that I successfully down graded to read only. They have left the organization and I want to remove them. I am also planning on going from free to team and I do not want to pay for this person. I believe they are a workspace collaborator.  How do I remove them to not have any access to my Airtable workspaces and bases and not get billed for them after upgrading? Thanks, Scott

Is anyone seeing their automation freeze after a trigger?

In the interface section, when I create a form page, is it possible to retrieve the id of the new entry created by the form?At the moment, I have the impression that the only one I can display is a free text like "Congrats, your answer has been sent" or something similar.Thank you for your reply.Julien

Hello everyone,I'm currently working on an automation project where I'm facing a challenge with embedding images into a Google Slides presentation. I am using Make to lift the images from airtable and replace the placeholders in Google Slides template. I am able to pull in all the text information but have hit a roadblock with the image embedding part.Here is the issue:* I have a Google Slides presentation with placeholders for images.* My Integromat scenario successfully retrieves image URLs from an Airtable base.* The URLs are accessible and lead to a download option for a `.png` image when opened in a browser.* However, these images are not being uploaded or embedded into the Google Slides presentation.Sharing a screenshot of my Make scenario.This is the templateAnd here is the settings of Upload Image module The url that I obtain from the previous module looks like thisIt seems the URLs might not be in a format that Google Slides can embed directly, possibly because they initi

Dear Airtable community,I'm working on an automated email sendout where I would like to let the recipient know which order and delivery dates will be applicable within a holiday week. To make it as easy as possible for the reader, I basically joined one big text field based on the data input, for example "order will be placed on 28-12-2023 for 02-01-2024". Now, I'm looking for a way to aggregate my output - kind of like a pivot before showing all fields. Data format:CityRecipientTextBerlinBerlin1order will be placed on 28-12-2023 for 02-01-2024BerlinBerlin2order will be placed on 28-12-2023 for 02-01-2024HamburgHamburg1order will be placed on 29-12-2023 for 02-01-2024FrankfurtFrankfurt1order will be placed on 28-12-2023 for 03-01-2024How can I aggregate the information so my vendor only receives the following information:CityTextBerlinorder will be placed on 28-12-2023 for 02-01-2024Hamburgorder will be placed on 29-12-2023 for 02-01-2024Frankfurtorder will be placed on 28-12-2023

Hi all, I love the AT community and can often find solutions within articles but can't seem to find anything that helps solve my current situation:I have a multiple-user assignee column and often people from lots of different teams get pulled into one task. We also have a multi-select team column showing which teams are directly involved with the task. I currently have automations set up to add the relevant team into the team column when any of the team members are added to the assignee field. But as conditional automations only run until one condition is satisfied and then stop without making updates for any other satisfied conditions, I have had to create a new automation for each team, to ensure it updates for every assignee. I am currently trying to write a script to combine all of these automations; I have coded the part to input the table and source (assignee) and destination (team) fields, but am stuck as to how to define each team and the relevant team members and then get

Is there a way to get notified of a new comment on a record? Either through the API or within Airtable itself?