Ask the Community

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. 

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

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?

Hey Airtable Community! 👋As @GCheung, @MaddieJ, and the incredible Airtable team gear up for the exciting re-launch of our community, you’ve probably noticed we’re heading into some “read-only” days (Feb 21 - Feb 28). Whilst we wait for the migration to take place (and eventually the big reveal 🎉), I wanted to make myself available if you need any help, have burning Airtable questions, or just want to chat about automations and solutions in the meantime.Feel free to reach out to me directly via Private Message (if they will still work?), or most probably via email at mike@automaticnation.com — happy to be a resource while the community gets its well-deserved glow-up! ✨

Hello Team,I'm trying to connect my Voiceflow Project with Airtable, but I received a "can't send request," "Make sure the domain is publicly available or try a different URL".  I tried to enable the API public access but I don't know to do that.  Any help would be greatly appreciated.  Thanks. Regards,louise