Unanswered questions

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?

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’m getting the error “Something went wrong: Unable to extract content from attachment(s)” when I’m running a field agent on an attachment field.The attachments are all PDFs. I’ve personally reviewed them all (there are only 17 rows) and they all render just fine in multiple PDF viewers, including Airtable’s.This is not a consistent error. Using some AI models I do not get the error; with other AI models I get the error on first run with one row, but running it again clears the error.What gives? Anyone else hit this or have any insight?-Natalka

We just added Portals to Airtable and to my dismay, Omni pops up in the portal interface as an overlay. Not cool, especially considering Portals is designed for external users. I had to disable Omni completely to get rid of it in the portal interface. Is there a way to leave Omni enabled for my internal users, but disable it in Portals?

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 (detected in {To Location}), the lot should take the Bin code from {From Bin} instead. Otherwise, it uses the Bin code from {To Bin}. Example (desired output):MCO-OH-FINOLA-25-070-022. When there is no contractThe Lot ID should

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 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.-Observed Problems & Failure ModesThe concurrent writing of data by the 25+ Automations is causing severe data integri

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 Course Completion Status table. The view is set to show only records in the Participants table where the Courses field is not empty.And the action settings:Course C

I’m trying to convert an Access database we use to track event and participant data to Airtable so that we can get away from Access and all of its downsides. What we have has always seemed pretty simple and straightforward, but I’m really struggling to create a similar situation in Airtable that isn’t so time consuming. What I have is two tables connected by a join table: Events is where I create records for each new event we host, with a unique number as the identifier, as it’s possible to have multiple events on the same day. Participants is where I create records for each new attendee who participates, and the unique identifier is their username. We have new events about every week, and new attendees is unpredictable. Participants may attend one event or many events, and the goal of the database is to track who comes to which events, to be able to pull data about the types of people who come to our events, and to offer transcripts of the events attended by attendees who may ask for

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???

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,i’ve created an automation to update a record (eg. personal information) when a form is submitted to update.however for some applicants, is giving me this error. anyone that can help? thank you 

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).

We are a not for profit organization involved in promoting a fascinating Indian Sport called Mallakhamb.We use a combination of Airtable for data storage and sharing and fillout forms connected to Airtable base for  use by public for signups.I would like to understand the contribution of each part of Airtable - data, calculations, automations, shared views and fillout forms , towards the Public API usage. 

I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help? 

I want to send emails via SendGrid. this is to be done through an automation baed on a trigger of when a record enters a view, like this:The email text contains many personalisations, pulled from the database. Some of these fields are lookup fields from other databases. Below are all the personalised fields: And here is the script:// Get your SendGrid API key (store securely)const SENDGRID_API_KEY = "-KEYisHERE-";// Get the record that triggered the automationlet record = input.config();// Extract values from arrays BEFORE building emaillet firstName = Array.isArray(record.firstName) ? record.firstName[0] : record.firstName;let projectLeadName = Array.isArray(record.projectLeadName) ? record.projectLeadName[0] : record.projectLeadName;let task = Array.isArray(record.task) ? record.task[0] : record.task;// Debug - verify values// console.log("Project Lead Name:", projectLeadName);// console.log("Task:", task);// FOR TESTING// console.log("All record data:", record);// console.log("Type:

Hi, all! We’re using Airtable to intake scheduling for content, and have an automation that builds a secondary record for later content updates based on information provided in the intake form.As a second step in that automation, I’m trying to send a note to a Teams channel to confirm the automation has run and alert our team that there’s a new task scheduled on the update date .. but every time I test the automation, the update date generates blank in the preview and comes through blank in the Teams message as well, even though the field itself is populated in the original record (that’s one of the conditions).Is there anything I could be doing wrong, or is this just a quirk that will be worked out at some point?

Hey all —My team and I build white-labeled mobile apps for treatment and recovery programs, and we’re finally moving a lot of our client intake and pre-development process into Airtable.We’ve got most of it built out — linked tables, a client-facing form, a few automations — but before rolling it out, I’d love to get a quick sanity check from someone who really knows their way around Airtable.Ideally just a 30-minute screen share to walk through what we’ve set up and get your thoughts on structure, permissions, and anything we might be overlooking.If you’re up for it, drop a comment or DM me. Would be super appreciated!

 I’ve been building an Airtable app for my team (about 10 people) at a foundation. We make a lot of grants across different programs, and I’ve been trying to create a central hub for all of our work. So much of what we do overlaps that it just made sense to keep everything in one app rather than splitting it up.Right now I’ve got about 15 tables:  organizations, projects, tasks, budgets, inquiries (from email), notes, annual budgets, program budgets, etc. It’s a big base, but I’ve built separate interfaces for each program, so even though the back end is large, the front end feels really clean.Some folks on my team have suggested that each program should have its own app, with a master one where everything rolls up. I’m not sure that’s the best approach. it feels like it would add more work and complexity.Curious what others think.  has anyone else gone through this decision? Does keeping everything in one well-structured app make sense, or is it better to split things out? Would love

Hello I thought this would be simple to figure out but somehow its not working for me.I have 4 tables.  They are all linked together.  Each field in everyone of these 4 tables has a common Dept Code (this is their link to each other).  Also in each of these fields is a field Associated Program.  At times we may need to edit the data in the Associated Program field.  If we do this I would like that update to appear in all the other tables as well.  I thought if I linked them this would be the case.  But they are linked on the dept code?  How can I create something that would update this other field in each of these tables.   Thank you, hope this makes sense.

Hi, I needed help with airtable, specifically on the fields of our content calendar. We have this added field that says “Updated Verbiage” and this is where we usually attach the Updated Document. We were able to use that before but recently and these past few weeks, we had a hard time using it because the field is not working. We cannot click the field and add the updated document. Has anyone experienced the same dilemma and how were you able to fixed it? 

Just posting this to check if there is some kind of systemic issue happening, or if this s***storm is unique to my Org. Airtable status says fully operational but something is definitely wrong.My Organization has several bases that are currently experiencing a complete collapse in their functionality. At the moment, we have 4 bases that cannot be accessed reliably, and 2 of these can’t be accessed at all. The bases can’t be loaded by any user, on any device, on any network. We have tested access from many locations and this issue persists.These bases do have some syncs set up between them, but nothing outside of what I have built many times for other clients with no issues.This appears to be an extension of an issue I have been working with Airtable support on for months now, but have made no progress:When updating the configuration of a base, updates take 30 plus seconds to occur, and always throw an error saying that the operation failed, even though they did not fail. This issue is

Hi there, I’ve been using Airtable for a while and using Pre-filled form for about 3 years now, but I’m having issue recently with some pre-filled form with linked records. I have 4 pre-filled linked record in this form : https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form?prefill_Session=70&prefill_Formateur=Camille+Rabineau&prefill_Entreprise=Founders+PledgeAnd only 3 show up and the last one doesn’t. It does appears in the URL though, it’s just nor displaying it. Here is the formula I’m using : SUBSTITUTE(CONCATENATE("https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form","?prefill_","Session","=",ENCODE_URL_COMPONENT({ID 2026}),"&prefill_","Formateur","=",ENCODE_URL_COMPONENT(Formateur),"&prefill_","Entreprise","=",ENCODE_URL_COMPONENT({Projet de formation}))," ", "+")I’m not too sure what’s wrong, Thank you so much for your help ! 🙏Céline

I am using airtable to push emails out via my gmail. However gmail says they’re bouncing back but airtable doesn’t seem to track those emails that have bounced in gmail. I want to be able to change the status to “Bounced” and then automate to use another email i have in the airtable.