Solved

I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again.I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link).  I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time.  The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error.  The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter.Any suggestions will be greatly appreciated.Thanks,Ray Porter 

 This thing is extremely annoying and interferes with editing the table. The only way I’ve found to disable it is to turn off Omni for the entire base. Is there any simpler way?

ContextI have my base created, and my main table is named the “Event Plan”, within this table, each row is the record (event name).In the second table, called my “tasks” lists all the tasks that an event requires. The Problem I’m FacingRight now, my airtable reuses the same task records across multiple events. So I have ONE "Copy Creation" task that links to all the events (because each event has this task). But this creates an impossible situation: that one task can only have ONE start date and ONE end date, even though the events run on completely different schedules. Your GoalI want to create an Airtable where:Each record/event in the table is a separate project with its own timeline Every record/event has the same 27 tasks that need to be completed (Copy Creation, Brand Review, Registration Page Live, etc.) Each task has its own start date and end date specific to that event's timeline I don't want to manually create 27 tasks every time you start a new webinar Ideally every time I

Hello,I’m trying to automate the population of resumes as attachments to a candidate table once a form is submitted.  I’m having trouble getting the resume file to attach to the resume field.  When I do it like this (within a loop through the uploaded resumes), I get an error saying “Invalid String”.  That’s likely because the “ContentReference” is a JSON formatted string.  I don’t see an option to insert the resume file itself, only metadata.  How can I actually auto-insert the resume file itself? Thank you,Robert

Hi All. I have a problem that I hope is just a result of me missing something simple. I have an automation creating Outlook events from a list of Airtable holidays and birthdays. The “create” automations work fine. I was also able to capture the Event IDs from the Outlook events in the corresponding record in Airtable. Now I’m trying to generate a second automation for record updates using the event IDs and am running into an issue. When I input the data, the “Event ID” field shows up in the “Calendar” field, and the Event ID field is blank, so the automation won’t run. Photo included. Any ideas?  

Hello team, hope you’re doing well.Is there any way to share or extract the schema of an automation in the aim to share with functional people, non technical just to make sure that we are respecting the functional specifications.

Hi, I am trying to construct a daily email to summarise data. I have all the data I need, but I cannot get the email to structure correctly. I have used HTML to make a table for the data, but when the email sends the formatting is awful. I’m looking for a way to get the table to display correctly, does anyone have any ideas? Ideally I want the table to sit in the white space with the other text I have attached a copy images to show the issue and what the raw form looks like

I’m looking for help with integrations: My nonprofit uses Airtable heavily to track lists of people and their contact information. We also use MailChimp to send out updates to our partners, newsletter subscribers, etc. using that contact information. My question is this: Is there a simple way to establish a “Two-Way Sync” between Airtable and MailChimp so that they will always contain the same data, regardless of changes made on either side? I need a true “sync” that will: Update MailChimp with any changes entered in Airtable (add, remove, edit), and Update Airtable with any changes entered in MailChimp (subscribe, remove, edit). I’d rather pay a small fee per month for an established app to do this than build it in Zapier/Make, but either way is fine if it works. TIA, M p.s. If you know of a fix for this with an email marketing program other than MailChimp, please let me know. p.p.s. As of today’s writing, Outfunnel can do most but not all of this (like adding un/subscribes to Airta

Hi! I need some help, we have a team of people who are linking their gmail accounts so we can send email automations through their personal gmail accounts. I have the automations set up and each team member is going in to link their accounts. Four of the team members were successful, but two people are having issues.The drop down to add their account is not available (greyed out so they can’t click it and add their account). Any ideas on what is going on and how to fix it?

Hello Community.I want to create a form where the user is inputting an on-call schedule. They will add a technician’s name and the dates he is covering, then if they have another technician, then they add the next technician’s name and dates he is covering.Since Airtable Forms does NOT support “Add another” button in the same form. I need a work around for a form that would have repeatable sections.An internet search told me I need two linked forms – but I can’t find anything to help me do thatThis is what I have. A table for the On-call schedule where a year of weeks is set up with the start and end dates for that week, and the property.I then have a On-call Assignments table that has the technician’s name, the work week they are assigned.Then I have two forms that I want it to seem logical for the user to fill out and,  I want the tables to logically be; This technician → belongs to → THIS schedule → At this propertyAm I on the right track? How to I wrap this up in a bow? Thank you a

We have 800+ bases, each with several automations, and each automation can be sent to any number of recipients based on the project type.  They are primarily external to our org and non-AT users.  I’m trying to find a concise way to audit those email addresses to ensure they are still current and relevant. Can anyone give me any idea of a way to download/query/export this data without querying each base individually?Thanks

I am going around and around a lot on this problem and still trying to fin. d the right way to go.I have a table of invoices. The invoices are numbered sequentially. Right now I have to enter each invoice number by hand after checking a summary table I made that lists the latest invoice number used +1 from a formula.I would like to have the “latest number used +1” inserted into the invoice number field of the new invoice being created. I imagine that it I not as hard was I am making it. I will tell you that I am TERRIBLE at automations. I find them unintuitive and frustrating. It’s probably me.But I am guessing that an automation is what I need..So invoice table is “Invoices: House” and summary table is “Invoice: Next invoice Number”. The summary invoice numbers in the “Invoice: Next invoice Number” table are in a rollup field and the Invoice Numbers in the “Invoices: House” field is a numbers field if that matters.Any help is appreciated.Best, Scott

Good afternoon, everyone, I’m now trying to set up my tables so when “Shoot Date” is updated in the “Shooting Schedule” table, the box is checked under “Interview Scheduled?” in “Interviewees’ Contact Status” for the corresponding interviewee, in this case, Alan Barker. Shooting ScheduleInterviewee Contact StatusHowever, I’m running into issues when setting up the automation. I think I’ve pinpointed what the issue is based on reading previous threads in this forum with similar problems to mine which is that the Record ID is not changing from the ‘Trigger’ to the ‘Action’ step:AutomationSo, I’m kind of stuck as I don’t know how to find a different Record ID so I can get the ‘action’ to work successfully.TROUBLESHOOTING I’VE DONE SO FAR:For the trigger step, I’m not entirely sure how many fields I’m supposed to select. I only selected “Shoot Date” initially and the automation didn’t work so I thought the issue might be I didn’t select “Cast” which is a linked record to the database of in

I have a table (Invoices: House) that uses a sequential Invoice # entered in a field type: Number. I am currently entering each one manually as I create a new invoice record in the table. I would like to automate the process of assigning the next sequential number as I create a new invoice record.I am trying to figure out if I can do this with a formula or if I need to use an Automation or a Script.Does anyone have a way to do this?Thanks, Scott

Hi -I need to collect data on the number of projects per month that change from “potential” to “launched”. We currently have this field set up as a single select drop down that we manually update once the project status changes. I am assuming in order to track this I will need to add a time stamp or something to the changes being made? Or can an automation do this? We need to track over the entire year the total number of product status changes, but I am unsure how to collect this info. Maybe a monthly report that gets emailed to me showing the changes that I can then tally?Appreciate any help/ideas! Thank you!

I’m trying to automate period assignment in Airtable and want to check whether I’m missing something or if this just isn’t possible without scripting.I have a Periods table where each record has a Start Date and End Date for a 13-period fiscal year. In other tables like Orders, Packaging, and Transfers, each record has a single Date. What I want is for a record to automatically link to the correct Period when it’s created or when its Date is updated, based on whether that Date falls between the Period’s Start Date and End Date.I haven’t been able to find a native way to do this. Automations don’t seem to allow comparing one date field to another date field, Find records can’t evaluate date ranges using the triggering record’s Date, and rollups and filters don’t allow referencing parent record fields. Because of that, the only options I can see are manually selecting the Period or using a script.Has anyone in the community has found a native way to automate date range based period linki

Hello everyone,I’m new to Airtable and hoping someone can point me in the right direction.I run a small insurance and finance company (about 2 years old), and I’m trying to sync data between two tables: Insurance Policies and Insurance Documents. The goal is for any changes made in the Policies table to automatically update the corresponding record in the Documents table.I’ve tried linking records, but that causes unwanted behavior (for example, it creates new records in the Policies table when I select Policy IDs in the Documents table). I then tried setting up automations, but I keep running into errors and loops.Below is the automation prompt I was attempting to follow:“Create an automation that keeps the Insurance Documents table perfectly in sync with the Insurance Policies table. Whenever a record in Insurance Policies is created or updated, find the matching record in Insurance Documents where the Policy ID matches the Policy Number. If a matching record exists, update:• Carrier

Hi,We run a photography studio. The customer journey starts with a discovery call, before proceeding with a deepened consultation call for some, and then the actual photo session. The bookings for the discovery call come primarily from Meta ads.When monitoring that we have enough bookings (and potentially need to work on the Meta ads to get more bookings), we need to see historical data for how many bookings we’ve had. This would be on either daily or weekly basis, the problem is the same. For example, we’d like to see a table showing how many bookings we had for the coming two weeks and have this for each day, and see what the historical levels have been.This is how I tested: I first created a new table with one record per day. Then I linked the event bookings to each record (day). I then created a lookup field that would select all events of the type Discovery and wanted to add a filter for including only those events with a date “on or later” than that record’s date, which was not p

I want to look up certain related Procedure Records in my “PNP” table, then I want to add all the related Procedure Records to one field in every Work Record in another table. SO: Triggers: Possibly every time a Work record is created? or on a time schedule? A button?Step 1: Look up all related Procedures records based on a Work Record category fieldStep 2: For every Work Record, add all the related Procedures records to a “PNP” fieldShould be easy right? Just some ideas here but it didn't work at all.. 

Hello everyone,I am trying to make a nested IF/AND formula to do the following:IF the ‘Date First Contacted’ = blank, status = ‘Not Contacted.” IF the ‘Date First Contacted ‘= not blank and ‘Follow-Up Date’ = not blank, status = “Followed up.”Is it possible to write this into a formula given that ‘Date First Contacted’ and ‘Follow-Up Date’ are separate fields?  Thank you! 

Is there a way to automate the following scenario using any of the automation tools (like Make, Zapier)A change in a field in airtable triggers a 'create a campaign' on mailchimpThe campaign is reviewed and sent manually.The sent campaign triggers a 'change in status column' in the airtable.Is this kind of two-way sync possible?Thanks!

Hi guys,I'm relatively new to scripting, so I've mostly used scripts I find in this amazing community and adapted them to my tables. Once such script I've tweaked to create junction tables. It automatically creates entries in a junction table when a linked record field is updated. It has been working pretty well for a 5-6 months now, then all of a sudden earlier today, it started giving the error:ERRORTypeError: Cannot read properties of null (reading '0')at main on line 38"Usually I can figure out what is going on and fix it, but this really has me stumped. I didn't touch the script today (I'm the only one who manages them). I took a snapshot of the base from this morning and the script works in that, so I tried to copy/paste the code from that to the live version, but it still didn't work. Which lead me to believe that has something to do with a change in the base, like a changed field or table name. So I thought, okay maybe someone accidentally changed a field name. Double chec

I’m trying to filter using linked records but i must have a mental block. Table A is People Records. it is linked to: Table B: Service Records (multi records) Table C: Congregation (one record) Table C is Congregation. It is linked to: Table D: Districts (one record) Note: it is NOT linked to Service Records, but does have a lookup field to Service Records (from People). Table D has lookup fields for: Service Records (from Congregations) I want to report the number of Districts that had at least one Congregation that has a Service Record that meets the following criteria:Service contains “2025 11” {Service is the “Name field”} Service does not contain “Cancelled” {Service is the “Name field”}I also want to report the number of Congregations that have a People Record with a Service Record that meets the same criteria.Service contains “2025 11” {Service is the “Name field”} Service does not contain “Cancelled” {Service is the “Name field”} The problem i’m running into is that some Pe

I click the + below.The form opens.I click "Save" but nothing is saved.

We all know about ChatGPT. It’s profoundly expanding the possibility of creating some very smart systems. Pervasive and near-free access to LLMs (large language models) inch us closer to AGI (artificial general intelligence), which can be applied to apps and data in several ways.Airtable, of course, is readily able to enjoy the benefits that services such as OpenAI provide to developers. Integrating the power of LLMs for text and code completion is almost trivial. These are magical capabilities, but they aren’t the only capabilities.Most AI experts and analysts agree - AI will become pervasive in all solutions, and the ones that create the greatest customer value will blend application data, user context, and LLMs to create extremely relevant and powerful outcomes.Rows That Have MeaningAirtable search is not a pleasant experience at all. The findability of discrete records in a table is terrible. Locating key data across multiple tables and bases is almost impossible. I have explored t