Ask the Community

hello everyone, is there any way to filter the return using a GET call, I need it to return only the information of a column, which I call ID, I need my API return to show only the information corresponding to an ID, I can do that?

Hey there heavy-lifiting Airtable power users (i.e. full time consultants, developers and similar)!I recently engaged in different discussions with fellow consultants on what factors affect base performance (e.g. speed) the most, trying to come up with a robust conclusion and hopefully a list of factors ordered by magnitude of impact (not the list below which is just me putting some of the factors out there to kick-off the discussion). •Number of Records: Probably super big impact?•Number of Fields: Does having more fields significantly slow down the base? How much vs other factors?•Number of Views: How much do multiple views -even if not opened- affect performance? vs other factos?•Complex Formulas: Are complex or nested formulas a

Hi,Does anyone have an idea on how to embed a stock chart into airtable that depends on the record chosen?  I have an example of an iframe:<iframe referrerpolicy="origin" width="100%" height="470" style="background: #FFFFFF;padding: 10px; border: none; border-radius: 5px; box-shadow:0 2px 4px 0 rgba(0,0,0,.2)" src="https://jika.io/embed/area-chart?symbol=AAPL&selection=one_year&closeKey=close&boxShadow=true&graphColor=1652f0&textColor=161c2d&backgroundColor=FFFFFF&fontFamily=Nunito"></iframe>The symbol of the stock (eg symbol=AAPL ) I have in a coloum/record; so I would need the option to pass the symbol to the iframe to change the content displayed (stock item) depending on the chosen recor

I've seen record templates for adding physical location addresses. Where can I find this so I can add to a from scratch table? How should the address be structured to allow bulk uploading?

Hello,as explained in the title:I have a table "User" I have a single select field named "Color" 3 value possible: Red, Blue, Green Using make.com, I want to add dynamically a 4th option "yellow" So that the new possible value for this field would be: Red, Blue, Green, or YellowI am planning on doing it via Make.com using the API module and a PATCH but i wanted to check if it was possible to do it from an airtable perspective?thanks

HiThe Find Records action has a bug.I have an automation when a new record is created, use the 'Find Records' action to find a record in another table and link them together. Very straightforward and works.However if the new record created has empty fields for the conditions of the lookup, it returns ALL the records in the other table when it shouldn't return any records since an empty field does not equal to a non empty field.In the screenshots you can see that the record selected to test automation has an empty email and phone number field.But the Find Records actions returned all the records in the lookup table.This is a bug and not the first time it has been raised as mentioned in this community post:

–– Post with many screenshots –– Hi guys, I have a problem with an automation that contains a 'Sort List' module which sorts records depending on a date.    The record values the module is unable to compare come from a {Start Date} field. This formula field outputs the value coming from one of those three fields: {CALC LinkedIn Conversation Start Date}, or {CALC Email Start Date}, or {RAW Miscellaneous Start Date}. As you can see, the values in the {Start Date} field are not formatted the same way depending on their source field – some values come from a date field, some from lookup fields. This had me hypothesize that the values coming from th

hi everybody,I have an airtable actionable message in slack working... it gives me 2 buttons, which then correctly update a slack record.  However, after I click a button in Slack, it always changes to then say "Processing..."   This never changes... leaving our users unsure if the action actually ran (it did).I have tried with a new table in airtable. Not sure what else to try... Has this happened to anyone else?  Any ideas on how to solve/troubleshoot?? Thank you

Hi everyone!Im using automations to send updates of records (a list of 5 at a time) to a slack channel... I have the data I want to showing up correctly, but I'm wondering if there is any way to customize the style/spacing of the output of the "List of Records" in the message block?For example, I want field names to be bolded, to have the field and data on the same line (instead of next line), and make a different separator than "-----------------------".The "List of Records" content option in the Messages block has no options to customize that I can see (screenshot)... Maybe there is another solution though?  Wanted to ask!!

I’ve become pretty proficient in Airtable over the last year and have used it for countless purposes. However, this one is stumping me a bit. Within the same table, I want to link record A to record B, and have that link show up in two separate columns indicating the relationship. Example… I’m creating a base to track cattle for a farming business. One table will have “inventory” to track all of the cattle; previously and currently held. Some cattle will produce offspring and I would like to track this in the same table by using linked records. I would like one column to indicate the parents and a separate column to indicate children/offspring. Here is a basic example: Obviously, the table would track much more information than this, but the link is where I’m having trouble. By adding “parent” to one column, I want the linked record to show a

Hello,I am a beginner and would like to use Airtable both as a database (clients, prospects, accounting) and as a CRM to schedule calls, SMS, and emails, similar to HubSpot, Zendesk, or PipeDrive. If Airtable allowed these actions directly from the database, it would closely resemble a CRM, but I’m not sure if this is natively possible.Since its interface already looks like a CRM, why doesn’t Airtable include built-in features for call reminders, SMS, or automated/one-click emails? If this isn’t available, is there a specific reason?From my research, it seems possible to achieve this using integrations with Make and external APIs, but a native solution would be much simpler.Here are the solutions I’m considering:Airtable / Make / Twilio or Messagebird: call reminders and SMS sending.Airtable / Make / Gmail / ChatGPT: automated email generation and sending (with manual validation) + em

I have been playing around with @Justin_Barrett’s excellent script “Parent Child tree hierarchy” (Parent Child tree hierarchy). The output of this is a text field with any separator you like, for example: World > UK > London > Hammersmith > Elspeth Avenue > Joe’s Cafe World > France > Paris > La Defence > BNP Paribas World > USA > New York > Manhattan > Central Park Question - is there any way to extract the #3 item (or the #2 or #4 for that matter) from these text strings? In this case, to pick out “London”, “Paris” or “New York”. I assume this should involve counting 2 instances of the separator (“>”), and then selecting the text from there up to the next separator.

Hey everyone, I’ve been spinning my wheels on a simple issue for the last few days and hoping someone can put me out of my misery. I have the above dataset and hoping to split it up automatically using a formula. The data comes in via Zapier and the delimiter is always a ,. I need a solution that can run automatically. Few keynotes on the data; Could be anything from 1-3 records. They won’t always be the same The length of them will also vary FWIW I have only two records now and have formulas in place based on searching around. They are; Product ID A IF( FIND(",", {Product ID purchased}), LEFT({Product ID purchased}, FIND(",", {Product ID purchased})-1 ), {Product ID purchased} ) ``` Product ID B

I am trying to create a formula that will take the latest date from a linked field (Appointments) and enter the latest date in a new field called "Last Appointment." I tried to generate a formula using the AI which gave me this formula:DATESTR(ARRAYSLICE({Appointments}, -1, 1))but it keeps coming back with an ERROR. Any help would be appreciated.

Is it possible to create a publicly accessible Interface whereby access to a given record is based on a unique string that is entered in by the end user? I have records (of students) and want an individual’s information accessible only be entering a unique string. Ideally, I wanted a field where you enter in a string and then gives access to one record along - can this be built out within airtable? Thank you all!

I have a default value of "not started" set for a single select "task status" field (see screenshot of field settings). In an interface, I'm using a button to create a new record from a Timeline view. The view has filters applied, which include filtering [records without "Completed" in that status field] OR [records with "Completed" in the status field AND Completed Dates within the past 7 days.] (see screenshot of filter settings)The new record form attached to the button also has "not started" selected as the default option for the task status field. (see screenshot of form settings)The problem is that when I click the button, the form defaults the task status to "completed" rather than "not started". I suspect it might have something to do with the filters applied to this timeline but I'm not sure. (see screenshot of new project task form)This problem also occurs if I allow users to add/delete records inline. If they draw a new rec

I'm using Airtable's Interface Designer to manage vehicle inventory, and I'm struggling to add more items to the side of an image (as shown in the screenshot). I'd like to display additional fields or components in the empty space to the right of the image, but I can't find a way to do it within the interface settings.

I am trying to build an automation that updates a record if the status dropdown = Offer Accepted. If Offer Accepted is selected from the dropdown, I want the automation to update a checkbox field (to no longer being checked).

Hello - I'm fairly new to Airtable and I have a base with 5 tables, each table contains the schedule of a different project that I am tracking.  I want to create an interface calendar that displays milestones across the 5 projects, but I can only see how to source from one table.Is there a way to connect your interface to more than one table? Thank you in advance for any help!

This may be an issue more with our organization's strict IT rules but here is the situation:We have a type 2 email account that hosts all of our events on its calendar.When we initially started with Airtable, we used the outlook integration and was able to access that type 2 by using one of our work emails that subscribes to that type 2 calendar as the sync configuration source.ex. connected accounts>raethgu's outlook>events calendarOne day the sync was broken and in an attempt to re-establish the integration, a coworker updated the sync configuration source through their outlook accountex. connected accounts>coworker's outlook>events calendarIt looked fine until we noticed all the tasks and subtasks and comments were gone. We believe using that different source erased all the existing records and replaced them with the same records (since it was the same calendar).Our goal is to make the

Hello,We have a table that syncs with our outlook calendar that we have been using for a few months now. Our organization adds events every week, for some reason when they were added to the outlook calendar today, Airtable made dupes of each one. I can confirm there are no duplicate events on the outlook calendar itself, but I do notice that Event 1 and Dupe 1 have different outlook IDs. Has anyone experienced this or have a solution to remove the dupes? Thanks.

How can you export all the PDFs/images/etc in attachment fields?

I have 2 tables setupThe first one has a single select field with animals names followed but a long text field which should be related to that animal.The second table has the name of the animals in a field followed but a long text field with some information.I would like an automation that triggers every time a new record is added to the first table and that updates the long text field on that table with the information from the second table for that specific animal. The thing is that the update should only be made when the single select field from the first table is set to NO. When the choice is YES it doesn't need to fill the long text field from the first table.I know how to do it creating different automation for each field but I won

Hello everyone,I’m encountering an issue when trying to use the Sync API to upload a CSV file to Airtable. Every time I send my request, I receive the following error message:“Column names must be non-empty strings.”I’ve carefully checked my CSV file, and everything seems fine. The column headers are properly defined, and there are no empty values. What’s more confusing is that when I manually import the same CSV file into Airtable through the UI, it works perfectly without any errors.I have double-checked that:• The CSV file is correctly formatted.• Column headers are valid and properly named.• There are no empty column names.• The same file works fine when imported manually via the UI.Has anyone else faced this issue with the Sync API? I

Hi. Has anyone managed to integrate Airtable with Canva using Zapier? I have only seen the option to integrate with onlizer so far....we've been trying with Zapier but the designs aren't appearing anywhere on Canva.