Ask the Community

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 “Machine 1” is changed to start on 3/21, then the job on “Machine 2

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

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

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 

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? 

Hi Community, I would like to know if a status change in a chart can trigger an email automation flow in another program like Klaviyo? Basically, if we generate leads from a fair and add them to our airtable and move their status to “email recipient”, can a specific email flow “fair visitors” be started? I am new to Airtable and was unable to solve my question via YT-videos, so I´m hoping that you guys can help me out. Thanks!!

Hello! When I share my forms link, even though nothing is checked to restrict access, it is requiring everyone to sign-in to Airtable? I use to be able to send the forms link and it sent the form, now it is requiring folks to sign-in. Any fix for this?

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:

Hello! I’m trying to create an automation that allows me to add someone to a collaborator field without replacing any data that is already in the field. Is this possible? That is, if 3 people are already in the collaborator field and I want to add a fourth via an automation, can the fourth be added without removing the other 3 that are already in the field?

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

Hi everyone,I’m trying to create a line chart in Interface Designer that shows interest rates over time. My table structure is simple: Date (date field) Rate (percentage field) Type (single select) In the chart settings: I use Date for the X-axis, Rate for the Y-axis, And I apply a filter so that only records with a certain value in the Type field appear. However, I noticed that Airtable automatically applies an aggregation (e.g., average, sum, etc.) to the Y-axis values, and I can’t find a way to set it to “none.”Since each date in my table corresponds to exactly one record (no duplicates), I’d like the chart to simply plot the rate as-is, without aggregation.Is there a way to disable aggregation or make the chart use raw values for each record instead of aggregating them?Thanks in advance!

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

I understand there is an Admin panel available on the Business and Enterprise plans that looks like a one-stop-shop for organizing user settings/permissions, but that this is not available on the Teams plan. Isn’t there a way on the Teams plan to see all users in one place to see what they have permission to and at what level with the ability to edit the settings right there? Currently it seems like a disorganized mess as I have to go to each element to see who has what and frankly that’s not very clear. An Admin panel seems like database 101 and should be available to all paid plans. Am I missing the boat here? (I feel like I’m missing something obvious.) A specific question: In our workspace, under the Collaborators tab, it shows three users:Me - Workspace OwnerMy boss - Workspace EditorEmployee - Interface Editor Would this setting allow the employee to interact with the base itself, or do can they only see the interface (which is the goal)?