Ask the Community

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:https://community.airtable.com/t5/automations/when-source-is-blank-automation-links-all-records-from-another/td-p/176602?utm_source=chatgpt.comBut the solution in that post doesn't work in my instance as I need to use the conditional actions for another process.This seems like a simple

–– 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 the two lookup fields must not have a date data type, but must be arrays.    But three things seem to contradict my hypothesis:1. the two lookup fields have date formatting in their settings2. when I applied the DATETIME_FORMAT function to those records values in a test field, I got no error3. when I sor

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 cross-link under the offspring to show the relationship. I’ve been able to do this by creating a 2nd table that links “family ties” and

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) + email archiving.Airtable / Make / MailChimp or Klaviyo: email marketing campaigns.Looking forward to your

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 RIGHT({Product ID purchased}, LEN({Product ID purchased}) - LEN({Product ID A}) - 1 ), FIND( ",", RIGHT({Product ID purchased}, LEN({Product ID purchased}) - LEN({Product ID A}) - 1 ) & "," )-1 ) ``` [quote="Ryan_de_Metz, post:1, t

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 record onto the timeline, it defaults the tas

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 integration independent of any person's outlook account but here are the caveats:When

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 wonder if I can do that for all fields with just one automation.Thanks for the help 🙂

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? Is there a specific requirement for the column headers when using this API that differs from the manual import?Code example :const res = await fetch(AIRTABLE_ENDPOINT, {method: "POST",headers: {"Content-Type": "text/csv",Authorization: `Bearer ${AIRTAB

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. 

Hi, we receive form emails in our airtable base. what's the best regex to use to extract information?Email looks like this:*Your Name* Jane Doe*Organization* Best Company*Your Job Title* Sales Manager Thank you!

I have an Airtable automation that finds a list of records and then send a Slack message that includes this list. When I send via email I get the option to include grid or list, but when I use Slack the only option is list...which I really don't like the look of.I found some older threads on here asking about this but it seems like there's no good solution. Someone mentioned forwarding the grid message from email to Slack, but I don't like how it shows up in Slack so not an option for me.Any other ideas on workarounds? 

hi please help meI select to 2 different data from Tables in an interface.now i want those selected ones for using them in an automation by clicking a button.1. How is what i selected connected to use it in an automation?Where do see the reference what is selected?2. An automation works for one table. So i have to save the 2 different datas to new table first?3. How do i save this 2 datas from different tables to a new table?

 Hi folks, I am going out of my mind! Everything was working perfectly until I deleted some data in my table and now BAM it's all gone to total rubbish! If anyone can help I would be hugely grateful. Quick summary - I have one base with two tables; ID and Conversations. I want to connect a unique numeric number to a user email so when information is zapped in it connects the numeric number with the correct email. ID table houses the unique number and email.  It was all working fine but, as mentioned, I deleted about 20 rows and it has stopped. I have reset the link/look up and it worked on the existing rows but not on anything new coming in. The screenshot below shows (with the face stickers - sorry, it has confidential data that I can't share), Columns Project ID, Email Lookup and Link to ID Record and as you can see (if the stickers were not there!) it was working perfectly and then at the end you can just see the last one worked and then the further two rows did not p

Hello, I am using Airtable for a long time integrating with N8N.I have one issue.I am using Airtable for store data.This data have to be processed in specific time.Client can set process time in airtable process_time column.I want to make trigger at that time and process date in N8N.Does anyone have any suggestions on what I could do for a consistent system?