Ask the Community

I am trying to set up an email automation that sends an email the next day at 9am after a status change. I have created a formula field: IF(  {Status Changed},  SET_TIMEZONE(    DATEADD(      DATETIME_PARSE(DATETIME_FORMAT({Status Changed}, 'YYYY-MM-DD') & "T09:00:00"),      1,      'days'    ),    'Europe/London'  ))The automation is triggered using a status condition and when the formula field is ‘today’. and This creates the correct time and date in the formula field, but it is not triggering the automation.  

I am a big Airtable fan, I am very careful, but every now and then I create empty records by clicking on sections, etc. Now, I always figure it out and clean up but can only notice beginners do that almost systematically. I am sure certain there are UI enhancements the Airtable team could implement to make people aware they are actually adding entries in a table.

https://airtable.com/invite/l?inviteId=invuYBzw8FmryWGPT&inviteToken=3e8b535eecb350617997aaa9c9e0c49b3be2d1c99a73fb32aed8f54c4befe51b&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi there,  I’ve created a pie chart in my dashboard interface, and I selected a field to group records by (Gross Margin %). It seems to work well, but it sometimes displays multiples of the same value as separate slices (see multiple 14% and 40% in the legend below). Is this a bug, or am I missing something in the chart setup? I’m really confused why the same value wouldn’t group together automatically.  This is what my setup looks like: If anyone has any ideas, I’m all ears! Thanks so much :)

Hi everyone,I’ve set up an automation in Airtable that is supposed to trigger once a day at a fixed time. The automation is configured to send an email via Gmail.Here’s the setup: Trigger: At a scheduled time Interval: Every 1 day Time: 1:30 PM (local timezone +07) Start date: Jan 9, 2025 (Screenshot 1 shows the trigger configuration).The problem:Instead of firing once, the automation is running three times: Once at the correct scheduled time (1:30 PM) Once again almost immediately after (same minute) And another run about 2 hours earlier than scheduled Screenshot 2 shows the run history: 13:32 → executed once (2 hours early) 15:52 → executed twice in the same minute Screenshot 3 shows the action setup: It searches in the table 11. Einsatzplanung Using conditions (Einsatztyp = Installation, Start = in one week, Projekttyp has value, Willkommensmail senden = true) So far, we can’t figure out why Airtable is running the automation three times when the schedule is set for on

Bonjour, je cherche à faire un formulaire d’inscription à des cours de qi gong.Je souhaite avoir le nom, prénom adresse mail et numéro de téléphone,le choix (case à choix multiple) du forfait choisi (cours unique, forfait 10 cours, ou cour annuel)avec le prix qui s’affiche de chaque forfait Comment dois-je procéder, car j’ai une table “client” une table “forfait”mais le formulaire ne convient pas, puisque le champs “forfait” est un champ texte, alors que je souhaiterai un champ à choix multiple. Merci de votre aide

Hello Airtable Community,I’m receiving an array from a Fillout form via webhook into Make (see attached image)I would like to use this array in a Search Records module for Airtable to find all records where the primary field matches any of the values in the array.What’s the correct formula syntax in Make’s Airtable module to achieve this?Thanks in advance   

I am trying to create a call log for our company, but the issue is that I want to figure out how to display multiple back and forth or escalations relating to one call case without adding many rows. I think this could be done with linked records. but here is the schema: Last Name First Name ID Date Type Relation Reason Description Phone Email Link to Assigned Staff / Assigned Team for follow-up. Status (for follow-up) with Resolved or Escalated. I want to demonstrate if it is Escalated that it would move to another person, and allow them to do the next level of response. Or to have multiple entries documenting communication attempts at various levels before Resolved Does that make sense? Feels like I need a sophisticated Junction Table

Hi AirTable Community, I have a commercial dry cleaning and laundry business. I’m trying to create an Airtable app that will let my clients share an itemised list of the garments they’re sending me for cleaning each day. I’d like to create an interface with a form at the top, that lets the client enter each item for cleaning with relevant detail, then a table directly below which lists each item, so they can see a summary of the data they’re inputting in real time. I’m confident about designing each element, but can’t figure out if/how I can put them on the same interface. Any guidance would be much appreciated. Thanks! 

When in data view I click a button that opens a URL, each time a new tab opens. To avoid that, I tried the trick of pressing the ⌥ button while clicking the button, but this time a .TXT file gets downloaded onto my computer on the clicking of the button.This is quite annoying, especially when you have to perform a button clicking multiple times. Do you have any solutions in store to circumvent this?I would appreciate your help on this.PS: I saw that this topic had already been covered in previous threads. But I thought that Airtable might have fixed this since the last time it was brought up.

I need to generate an image link that ends in .jpg or .png for the purpose of registering the product to GS1 (to assign a barcode). Is there a way to change the URL of my product image in Airtable so that it ends in .jpg? 

Hello,I'm wondering if it's possible to get a pivot view in Airtable similar to those in Excel and Google Sheets that would show multiple values ​​at once, e.g., the sum of the values ​​along with the share of the total and the percentage change year-over-year. Like in the example below.Many thanks for help

I need external parties to update existing records. I have successfully created a second base that serves as the receiver of the updated fields. I accomplished that by creating a form in the second base and using the URL from the form to create a formula field in the first base that will pass a record identifier to the second base. The URL works well and the record identifier from the first base shows up in the new record (RequestID) in the second base to match the record being updated from the first base. My problem seems to be with the automation. I am using when the form, from the second base, is submitted to trigger the automation. I then added update record to the automation. Based on a video covering the topic by Julian Post, I list the second table called New Update as the Table in the configuration. I list RequestID from the second table as the Record ID. For testing purposes, I add just one field in the Field section. I set it to dynamic and map the corresponding field wi

I have a base called "All Owners."  How do I allow the individual records within that base to see and update their information ONLY?

Hi all,I’m trying to set up a self-linking “Related Records” field in Airtable (Team license) so that when I link one record to another, the linked record automatically shows the same relationship in return, within a single field.Right now I have: A Related Records linked-record field (self-linking within the same table) Airtable’s automatic “From field: Related Records” mirror field, which shows the reciprocal links Functionally this works, but the relationships appear split across two fields.My goal is to have all related records appear together in one field, even if that means creating a new combined field.I’ve tried to figure out if a formula or automation could merge the two linked-record lists into a single multi-value linked field, but haven’t found a way that works.Has anyone successfully combined self-links and their reciprocal “from field” values into one linked-record field?If so, could you share how you set it up (automation, script, or other workaround)?Thanks!

I have this formula that is working: IF({Start date},DATETIME_FORMAT(DATEADD({Start date},14, 'days'),'MM/DD/YYYY'),"") I want to incorporate these conditions to it:IF(Category = "Playbooks",14, 'days')IF(Category = "How-to-Guides",3,’days')  

🚨🚨🚨🚨🚨🚨 SIGN-UP USING THIS LINK 🚨🚨🚨🚨🚨🚨🚨🚨Hey!!For the last few months the idea of running a Community Led Airtable Hackathon has been lingering in my head. When, how, and what is not clear at all to me yet, so I wanted to open up the discussion early on to make sure this is really community led.Brainstorming:Format: Virtual (for sure). Synchronous (everyone builds during a given time frame) or asynchronous (projects submitted over a few weeks). Themes: Specific theme (e.g. procurement, marketing ops, nonprofits, etc.), or leave it totally open to “build whatever you enjoy”? Why I think this could be fun: A chance to show off creativity. A way to learn from each other’s builds. An opportunity to meet new peers. A reason to push Airtable to its limits in unusual or inspiring ways (different to the day-to-day work we do for our clients or within our organizations).  Would love to get some input from the usual suspects here, and from any other Airtable enthusiast!​@Scott

Hi Airtable Community,I’m trying to reproduce the Record Review layout shown in Airtable’s setup preview, the one with an employee list on the left and a large profile card on the right. In that preview image, the record detail area shows:A profile picture (Attachment field) on the leftAnd, directly to the right of it, several fields like “Team,” “Start Date,” and “Manager” displayed inline, where the field label and its value appear on the same horizontal line, for example:Team: CreativeStart date: Dec 28 2022Manager: Julia Harris I’m attempting to achieve this exact side-by-side layout in my own Interface. Here’s what I currently have:I’ve successfully positioned the Attachment field (Profile Picture) on the left, and I can place other fields (such as “Contact Type”) to its right.I’ve set the Style of “Contact Type” to Pills, which correctly displays the values (“Expert | Partner”).However, the field label (“Contact Type”) always appears above the values rather than beside them.In ot

Good day.I have a base that receives forms.  The form is a default for ALL events, and each event, via a formula, creates an unique form link that hides the event’s ID so that when someone submits a form, that ID is autofilled, and thus populated to the proper event.Now here’s the thing, I have another base where I have dropdown selections, but again this is tied differently, as the first one is tied to an unique even, so that won’t work. The dropdown selection allows us to see only those that meet certain criteria, however, in this case, for the event, it would be different for each event, maximum users if set, are met, then it would no longer show US their names.At least that’s the thought.So I was thinking in the attendees table, where the form is linked to, I could have a view that first is sorted by date created.  Then, there are lookup fields from the table with the event info(linked to the attendee table), of count of attendees, and max # attendees.I was thinking that there shou

I’ve got a nice little script within an automation to auto-categorize transactions in a bookkeeping base. It relies on a table for transactions with various fields, as well as a table called Rules, with the rules I want to create for my categorizations. The Transactions table has the following fields: *Name - single line textLowercase Name - formulaMatched Terms - single line text*Vendor - single line textPayment Type (tax purposes) - single line textPayment Type - single selectCategory - Linked fieldMerchant - Linked fieldTransaction Year - formula The Rules table has the following fields: Match Term - single line textLowercase Match Term - formulaPayment Type - single selectDesired Vendor Name - single line textCategories - linked fieldUpdate Rule? - checkbox It all works great, but now I want to add another parameter to the Rules table, a linked field to my table called Operational Expenses. The Transactions table already has a linked field called “Operational Expenses.” I want the

I’ve been trying for a few days to create a budget in airtable, enlisting chat gpt’s help.  It’s been a disaster.  Wondering if anyone has successfully created a budget here yet?  I’m a therapist, this would be a budget for personal and business.   I would import csv files at the end of each month from all the credit cards, venmo, bank accounts (presumably) to fill out the data.  My best, Brad

Hello all,I'm encountering an automation issue that I thought adding a delay action would resolve—allowing sufficient time for all record data to populate before triggering the email. The setup: Our work order base captures information and automatically emails the assigned technician. While most fields transfer correctly, two field agent fields consistently fail to appear: "Job Name" and "Scope of Work." The first field: The second field: The workflow is: The PM manually enters the Scope of Work, which then populates both the Job Name and Job Summary fields. These should all be included in the technician's email.The inconsistency: Manual testing of the automation shows all fields displaying correctly, but live submissions of new work orders result in missing Job Name and SOW data. I need the automation to run reliably without manual triggering, and populate those fields to the technician  Email output:  Message body:Any insights into what might be causing this? What am I doing wrong? 

Hi everyone,I’m trying to set up an inspection workflow for electrical equipment on construction sites using Airtable as the main database.Each construction site has several inventory items assigned to it through a junction table.For every inspection visit, a technician should be able to:Start a new inspection report linked to one site. See all inventory items connected to that site automatically listed in a form. Record for each item: condition (OK / Defective / Needs repair), comment, and photo. Submit once → this should create: one “Inspection Report” record, and multiple “Inspection Entry” records (one per item). After submission, a PDF report should be automatically generated and attached to Airtable. I’m looking for suggestions on which tools or integration methods could handle:dynamic data loading from Airtable (linked items per site) creating multiple related records from one form submission automated PDF generation mobile-friendly use for on-site inspections  Any recommendat

Hi chat, My coworkers are running into issues with the filters for their interface. They are finding that they're interface filters are resetting frequently throughout the day. Filtering is critical for our workflow and often when they're viewing their pages, it will remove their last filter. Has anyone experienced anything similar?Specific issues:Filters clear without user action. In other cases, filters revert to an old or unexpected state. For example: Our team commonly filters on the Assignee field. Most of the day, users apply Assignee = Themselves (10+ times per day). Occasionally, they apply Assignee = A Coworker (1–2 times per day). However, the Interface will often revert to the less frequently used filter (Assignee = Coworker) as the default, even when that filter has not been recently applied.What's been confirmed/tested:The issue affects multiple users across the same Interface. Users remain on a single Interface page and are not navigating between other pages within the In

Hello - I have a table for 'Booked Calls'. New entries come in when a call is scheduled and when the call time is passed an email goes to our client asking for feedback. The feedback is creating a new record and not updating the current records. I've recorded a Loom to add context: https://www.loom.com/share/b24fb5b8f11b4a18a786075e2966d681?sid=7454058e-7874-482e-9696-99a4cbde75c3 Looking forward to hearing your support.