Ask the Community

We have various sales/participation goals that change every year. My idea is to essentially store a unique formula for every goal, for every year, in a text field in a year table. Then in the main table, lookup that text field and somehow create a formula field based on that to do the actual calculation. Is that possible? Year Goal Name Criteria (single line text field) 2024 CP Sales Goal IF({CP Sales Rollup} >= 50000, 1, 0) 2025 CP Sales Goal IF({CP Sales Rollup} >= 60000, 1, 0)  Client Year (link) Criteria (lookup text field)

I need to create an interface of a table’s data.  It needs to have pages of “cells” that are shown in 3 columns and 10 rows.  Each cell has 4 rows (one column) of data, some with labels.  For example: First Last First Last First Last Date: 10/02/25 Date: 10/02/25 Date: 10/03/25 Score: 100 Score: 100 Score: 100 Distance: 1000 Distance: 1000 Distance: 1000  Ultimately, I’m hoping to be able to print the grid on Avery labels.Is this possible?

Hello,Please I need help with resolving this blocker I’m encountering with the system adding multiple records of each unique client email to the email sent. I have tried replicating the issue in the loom recording 👇🏼;  Looking forward to positive responses and best/ideal recommendations 🙏🏼 

Hi All, I try to fill a formula field with an email address based on another (email) field ( Source) using a nested formula:IF(Source = "Direct", "ulf@bayinvent.com" ,  IF(Source = "Oase" , "info@camperoase.de",

Hi, I feel this is a tough one and I would like to have some help to figure out where to start.I have a table of contacts and I want to send batch html emails to some of them only, depending on conditions, eg by country. It would also like to populate those emails with data coming from the contacts records, but also from other tables depending on what those batch emails will be about.Here’s a simplified example of what I need. One day I may need to send information about project A (from a “project” table) to my contacts in Canada. A week later I may need to send information about project B to my contacts in England.How would you do something like that? I expect I will need to use some sort of extension like Make, or maybe sendgrid? And maybe some sort of “Campaign” table, and automations?Thanks all for the help!

Hi everyone,I'm hitting a major roadblock trying to consolidate data for our care planning system. The main goal is simple: we need to merge the results of 25+ different assessment outcomes (Core Prompts) into a single Linked Record field on our final tracking table. Basically, we need the system to reliably weld 25 lists of IDs into one final master list. -Our Automation Setup  Structure: We have 25+ independent Automations, each dedicated to one Core Prompt (e.g., "Pain," "Swallowing"). Trigger: All 25+ Automations are set to trigger at the same time when a new assessment record is created. Action Flow: Each Automation executes a quick sequence: △Action 1 (Find): Finds all related Care Problem records based on a Formula field value (the core prompt name). △Action 2 (Write): Executes an Update Record to append the found list of Problem IDs to the target record.-Obser

As I create Interfaces for my database, I noticed that my record selector box for my source table, always defaults to the earliest record.  I need it to appear blank, when I first open the table's Interface.   Is there a setting that I need to change, or is an "unwanted" feature of the Airtable Interface?

This is kind of complicated and I’m not sure if it will be possible, but here goes. I’m trying to automate data entry for each record I create in my Project table. What I have set up now is a Long Text field called “Paste” where I paste the contents of an email, and several field agents that comb through the text of that email to fill out fields like Project Name, Project Type, Notes, etc. Each email contains the name of several people associated with the project’s production team: directors, writers, and producers. I have a separate table that is a Master Contact List of all the names that have ever been entered, and in my main Project table, I have a linked field called Production Team that links to the Master Contact List. Multiple linked records are allowed so that multiple people can be logged in that field in the Project table. Right now, I have to manually enter all the names. I would love for a field agent to be able to do this for m

I want to create an automation that triggers different emails dependent on record conditions. Mainly status changes but also some with multiple conditions. Automation:Trigger - when a record matches conditions - if status not emptyActions - If status is ‘phone interview’ then send email ‘1’Otherwise If Status is any of Phone Interview, Forward to Site interviewand if Last Modified is 5 days ago then send email ‘2’Otherwise If Status is any of Phone Interview, Forward to Site interview and if Last Modified is 10 days ago then send email ‘3’Otherwise if If Status is Site interview set then send email 4Otherwise If Status is Site interview set and if Site interview date is tomorrow then send email 5Otherwise If Status is any of Forward to Trial, Completed interview and if Last Modified is 5 days ago send email 6Otherwise If Status is Site Trial and if Area is any of Motor Vehicle Maintenance and Repair (Light

Hey everyone,I'm working on a personal project to automate my daily finance reports, and I've hit a wall that I'm hoping Airtable can help with.I absolutely love Airtable - it's been perfect for managing my financial data. But here's the thing: I can automate everything through the API except for creating and duplicating views. Every month I have to manually create new views and tables for the new month expenses.What I need:Create and duplicate views through the API Duplicate tables and rename them through the APII've tried every workaround

Hi! I get a “Connection error. Please check if your local block is running.” when running the extension I created locally. It works on Firefox. This was working previously. Initially, I thought it was related to a Windows 11 update that broke development with localhost, but I rolled it back, and it works on Firefox…I’m using the latest build as I plan on using the new multi table feature (I’m currently using the Web API to query a second table).

Hi all!  New Airtable user here. I need help! i have a ongoing master list of every transactions each of my credit card makes.on another table i want to be able to track the outstanding balance of each credit card. i understand i need to use to rollup function, but i cant seem to figure it out!I would appreicate any help!Credit Card Dashboard (where the it shows outstanding balance for each card) Thank you.

Hello All,Complete noob here, so, please be patient!I want to connect to the HighLevel (GHL) API here: https://marketplace.gohighlevel.com/docs/Authorization/PrivateIntegrationsTokencurl--request GET \--url https://services.leadconnectorhq.com/locations/<location_id> \--header 'Accept: application/json' \--header 'Authorization: Bearer <YOUR PRIVATE INTEGRATION TOKEN>' \--header 'Version: 2021-07-28'How can I accomplish this with Airtable? I want to poll the conne

I am new to Airtable and need help or confidence about the process. I have created two interfaces, an intake form and a directory to organize  the data collected from the form. I am unsure of how the form data populates the directory. Am I missing something?Thank you to all who reply.

Hi, right now, one of our databse APIs is down sind 2h, while all other of our databses are reachable.  Anyone experiencing something similar or has an idea what we can do? thanks so much for the help

I am seeking to set up a new base for my Podcast with all the lessons learned from using airtable the last several month, however I am unsure the best way to go about planning a whole new base.  Is there any suggestions for best practices?

I am evaluating various platforms to build a custom production scheduling application for a client.  Here are some details:Customers place orders for products they need produced Each order can have multiple line items for different products they would like produced Each order line item needs to be scheduled on one or more machines to be produced. The scheduled jobs for each line item need to be run sequentially, but not necessarily back-to-back.  In fact, some products need to sit for a set period of time after one job before it can be consumed by the next job to make the final product If the date of the first job scheduled for a line item needs to be adjusted ahead or back, the other subsequent jobs need to be adjusted by the same amount of time as well.  For example, if a customer orders “Product A”, which needs to run on “Machine 1” on 3/20, then “Machine 2” on 3/21, then “Machine 3” on 3/25, if the job scheduled on “Machin

I have an Airtable base for events I host. We get repeat attendees at the different events. I would like to send text messages to the participants at a particular event if they opt in for text messages. I have this all working.The issue I need help with is that I’d like to keep a master list of participants and their phone numbers who have already opted in at a previous event so they don’t have to opt-in every time. I’m looking for suggestions on how to handle this. When I add a participant for a new event, it needs to check the master opt-in table to see if there is a match. There will be records that don’t have a match as they have not completed the opt-in previously and opt-in records that won’t have a participant as they are not attending this event. As I write this, I’m wondering if an automation is where I need to go for this???

Hey, I’m trying to achieve a scheduled reminder for the people assigned to the records. I have the whole logic defined, but it looks like the simplest solution of using “Actionable message” within “repeat for each” within the list doesn’t work (as Actionable message is waiting for action before moving forward).  Any other ideas on how to approach it in an easy and clean way without adding extra fields in the database?Also, Airtable Team, it would be awesome if this could be actually improved on your end if possible :) 

I recently obtained a certificate in Airtable Admin but it's carrying my email address which is not my real name. Please how do I change it

Hi community! I’m trying to build a formula that generates a Pre-Processing Lot ID for each seed movement record. The logic depends on whether the movement is linked to a contract or not.1. When the seed movement is linked to a contractThe Lot ID should concatenate:{Final Initials (from Farmers)} {Program (from Contracts)} {Seed Variety (from Contracts)} The last two digits of {Crop Year (from Contracts)} {Contracts} (the contract number) The final Bin code (from {To Bin}) following these rules: If the seed is moved to one of these bins — HK 01, HK 02, HK 03, HK 48, HK 49 — the lot number should display the full Bin code (alphanumeric). Any “Bin ” text prefix should be removed. If the seed is moved to HPB1, HPB2, or GP WHPB, or the movement goes to a Cleaner (

I have enough credits that will pay for my subscription for many years, but an affilate program would be a game-changer. 

my question is regarding FormsI have a table countries with country name as main field.in my main table clients I have a field client_country filed which is a field linked to table countriesI want to create a Form view of the clients table.For the field "Client_Country I want to display a select dropdown to select a country among the list from the table countries  Instead of that, in the form besides the field Client_Country, I have a button "Add a file", which is not what I want  Can you please guide me to get the possibility to select one country from the list of countries ?  Many thanks in advance

Hi! Trying to figure out how to make a field that turns these times into a 24hr format. I’ve tried 2 different time formats examples (01:00 PM - 7:30 PM) as well as (3-8 PM). I’m have a hard time figuring out a formula that will display that in a 24hr format? Any ideas? 

This one is a little convoluted and I can’t figure out where I’ve gone wrong. I have three tables - course list, participant list, and course completion status. I set up an automation so that when a participant is added to the linked field in course list, or a course is added to the linked field in the participants table, it creates a record in course completion with that information.What is happening is that the new record will do one of three things: it will link to the correct record in the course list, it will link to a different record in the course list, or it will create a new record in the course list. I actually need to make some changes to accommodate users who get future enrollments, but I want to get this working first.Here is the automation setup:When record enters a view in Participants table, create record in C