Solved

Automation in AirtableI have a Donations table with the field Donor that contains a Single Line Text field with the donor name in it. I have a Summary table that is linked back to the Donations table using the Link Another Record filed with Allow Linking to Multiple Records to be selected. The linked field in the Summary table has a list of Donors from the Donations table. I want to automate the insertion of a new Donor name into the linked field in the summary table when I create a new record in the Donations table.It seems it should be straight froward but I keep running into a problem with figuring out what to select in the Actions section.Trigger = When a record is createdIn Actions:I choose Update Record I Put in a description so I don’t forget whY I did this. Action will run Always Under Table I choose summary table Under Record ID I copied the record id from the table from formula in table. The Summary table is only  record so I just put in a formula in that row. Under Fields I

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

Hello all, I'm looking for some help with a dynamic date filtering challenge in automations.I have a Social Media Metrics table where each record needs to link to all previous records for the same Contact/Platform combination, but only where Date Recorded is before the current record's date.The challenge: Airtable's Find Records action in automations doesn't support dynamic date comparisons (e.g., "Date Recorded < trigger record's Date Recorded"). This means I can't filter to only link previous records—it would link to all records including future ones.I've considered:Manual linking (works but not scalable) MIN/MAX rollup pattern with formula logic (works but still requires the linking step first) External tools like Make.com or scripting (viable but checking if there's a native solution first)Has anyone solved this elegantly within Airtable? Any creative workarounds I'm missing?Thanks in advance!

Hello all,I’d like to configure my Airtable so that when the category for a record is labeled ‘Uncategorized’ it automatically triggers a certain ‘Status’ label. I’ve been following this tutorial: https://support.airtable.com/docs/repeating-groups-of-automation-actionsBut I get stuck when I reach the last step for the action as I’m not sure what to put in ‘record ID.’ Every time I run it, it updates the same record, but I want it to search for all records that have been labeled ‘Uncategorized’ and update their status. How do I do this? Thank you! 

Creating a field agent to do a simple task. I want it to find some text in a document and copy it out. It’s doing great on the “finding” but being a bit too creative with the “copying”. Is there any way to set temperature for the model to 0? 

As of today, our airtable automations that react to action triggers of certain fields in not really large tables are incredibly slow and sometimes freeze, so we have to disable and re-enable the automation.In addition, navigation in the backend is tedious and slow.Our tables have a very manageable size, the largest tables have around 1500 rows.Since we also use Softr as a UI, we also notice very poor performance here.What can we do?Edit: To make the severity a little bit clearer: Action Trigger was set at 2:54 pm and the automation was finished on 3:49pm! It simple copies a row from Table A to Table B! 

CONTEXT: I am a Film and TV Producer (on a Pro (Legacy Team) account) with PEOPLE, COMPANIES and INTELLECTUAL PROPERTY bases that I sync (i.e. “push out”) as relevant to seed specific FREE client/project bases so a handful of (<5) different team members (respectively) can update content specific to their projects.EXAMPLE: I maintain box office data on movies, track streaming, broadcast and cable series ratings, statuses and talent (ShowRunners, Actors, Writers, Directors, etc.), actors’ bankability stats, everyone’s credits linked to their IP, who’s moved company-to-company in the relentless musical chairs and vertically integrated morphing and consolidating - it’s A LOT to track! LOL! :-)If I’ve done the deep dive of complicated music licensing research on a specific song - or have an actor’s whole suite of (also constantly evolving) reps’ contact info, I don’t want to have to keep manually updating that across a ton of different project bases. I USED to have this all syncing perfe

Hello the Community !I received a message informing me that I needed to upgrade my Airtable access. I assumed this was because I had reached one year of usage, so I proceeded with the payment of the requested USD 240.However, after logging into my account, all my databases disappeared. I can no longer access any of my bases, and I would like to know how I can recover them or regain access.Last year, I paid for Airtable with my personal email/account, and this year I made the payment using my professional email/account. Could this be the reason why I no longer see my databases?Thank you in advance for your help — this data is essential for my work, and I realy appreciate your support.Kind regards,Alexandre

Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be 5-15 resources assigned. We assign these resources through their own single select linked field so that we can utilize the timeline/utilization function. This makes doing things for the entire team complicated - such as creating a distribution list for the team members -  as we have to create a lookup field for each resource's email, another field to combine them, and another field to format it. I thought a simple automation could address this issue. It is pretty simple: when one of the 15 single select linked records is updated, it updates the multi select "team" field with all the assigned resources. I am running into two issues: 1)If I don't put a separator, then the multi select merges them all together (Instead of the field h

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

I have an automation that 1st Finds Records from a table then Inserts the Found Grid into an Email. I have static Emails and also want to Use Emails from the Found Records.  If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:I imagine maybe a script but do not know how to write those. Bull

buongiorno a tutti, ho bisogno di aiuto perchè non riesco a concludere quest’operazione:mi occupo di vendita di merce, ho creato una griglia con varie informazioni, tra le quali esiste la colonna nella quale viene visualizzata la data della merce in uscita.mi piacerebbe che quando questo cliente risulta “uscito” venga spostato in un’altra grigliacosì da avere un elenco di clienti da consegnare, e nell’altra griglia merce uscitagrazie 

Hi all!I've created an automated email and am trying to include our company logo as a footer.The code I've used in the input is: <img width="200" height="50" src="https://www.the-page.co.uk/psoostoo/2022/05/The-Page-LOGO-2048x486.png">In the preview, this works perfectly (see image), but when I ran a test to my own email address, the image didn't render and I just saw a grey box (see other image).Any idea on what I'm doing wrong or what the issue may be?Thanks!

I'm trying to set up an automated email to email our clients with a feedback form (not an Airtable form, we use a different platform). The feedback form needs to be tailored to each individual, so I've added a field for the link for each record. In the automated email, I'm using the "choose data from" tool to insert the form url from the record. However, when I generate the preview, there is nothing left. I've attached screen shots of the draft email vs the preview. How do I make the link appear in the email??

I have an automation that reminds me to complete a task once every month, however, I realized what I actually need is a reminder specifically on the second Wednesday of every month. I’ve been having a lot of trouble figuring out an automation for this new reminder requirement and would love some assistance if anyone has any tips or advice.

Hi, EDUsers,My name’s Sean---I’m the fellowships/scholarships advisor at the University of Wisconsin-Eau Claire. I’m reaching out to all of you Airtable EDU experts with a question about accessibility and WCAG compliance.Some background: I use Airtable for awards/fellowships tracking, on the back end to automate student contact points, and on the front end via a public database of award opportunities students can explore. I’m a one-man team charged with advising several thousand students, so Airtable has been crucial to my scaling up my capacity for advising.My state-funded, public university has scrambled over the past year to update our student- and public-facing resources to WCAG 2.1 standards, in line with the latest Title II digital accessibility rules. For most offices, this has meant new PDFs, new website content, different PowerPoints, and so on. For me, this has meant figuring out how to make the external components of Airtable (forms and interfaces, especially) digitally acce

Hello the community,I want to write a script which will read the data from a csv file which is in the attachment field "doc"  in the table "fileImport"The csv has 4 columns:Nom,Ligne,Jour,Valeurhere is an example of the data:Nom,Ligne,Jour,Valeur Bornet Marc,AL / ASD,2024-04-01,2Doe John 85%,AL / ASD,2024-04-01,17I want to parse all data and to create/update/delete records in the table "Planning" and writing the data in the appropriate field:Nom,Ligne,Jour,SV how can I do such a script 

I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by another API and saved to an output folder. When a file is uploaded to the output folder we would send this back to airtable.Can someone give me some general direction in writing a script to enable this? I understand I will need a presigned URL from AWS which is well documented, but I'm struggling on how I might do this using Airtables API. Any help very much appreciated!Many thanksEdward

👋 Hi all - wanted to share something I thought you might enjoy!We just launched Whalesync 1.0 - the easy way to 2-way sync Airtable with your CRM, DB, spreadsheets, and other tools.https://whalesync.com/Hundreds of fast growing companies, like Webflow, Descript, and Clay, use us to bring the power of Airtable to their other apps with true 2-way sync.Popular use casesWhen you can two-way sync Airtable with your other apps, you basically unlock super powers. A few pretty awesome use cases include:Creating programmatic SEO pages in WebflowUpdating leads in HubSpotConnecting project teams in Notion/Google Sheetshttps://www.whalesync.com/connector/airtableTools you can 2-way sync with AirtableWe support >15 connectors you can two-way sync with Airtable includingGoogle SheetsNotionSalesforceHubSpotZoho CRMSupabaseMS DynamicsWebflowTry it outWe have 2-week free on all our plans which you can try out here -> https://app.whalesync.com/If ever have any questions, also fee

I create a Make.com automation that sends out a transactional email to the customer when a new record is created in my enrollments table.  The last step in the automation is to update the Enrollment record so show that the Confirmation Email was sent out by updating the record with today’s date.It’s a rather basic setup, but every time I test it out I am getting a “404 Not Found” error when Make tries to update the record.I have checked the Input / Output in the error, but I’m not finding anything useful.  The OAuth connection is working fine to pull the records, and the Base / Table / Field names are all pulled from the dropdowns.  I also checked the Base ID, Table ID, and Field ID from the output bundle, and they are correct.Airtable Update node 404 Error  Input Bundle  Output Bundle  Airtable Field 

I have two separate bases. When a form is submitted in base1, a record is created. When a specific record matches a condition, i want to use an automation to create a record in base2.Ive tried using the sync feature in the data layer, which appears to pull base2 data layer into base1 data layer but when i go to the automation, the table I want to create a new record in is there, but is greyed out and cant be selected. I went through permissions with someone from airtable, but we still can’t figure out what the issue is. This is from the automationIn the table field i can see the table i want to create a new record in, but it is not selectable. IN the data layer, it is listed as grid view   

I want to update a record when a field condition is met, and currently the “Update Record” automation only seems to use any value/change to the field. What I am trying to do when the “Status” field is updated, and ONLY when it’s Value is changed to “Used” do I want to execute the update. Right now when the value is changed from Used to Unused, it runs the automation. Any guide on what combination of actions I can use to do this?

If I use an automation to update fields, does it update the fields in the order listed in the automation? So can I copy data from the existing fields first then update the fields with new data all in the same automation? If they update in order why can't I rearrange the order? just have to delete and reorder them all manually...

I have a Single Select field field that I want to allow users to be able to add new options too when they are in Create Form interface. Since this is not possible, are there any workarounds/alternative designs that anyone has used?My thoughts:1. Using Linked Record is also not possible, since it doesn't allow new record creation from the Create Form interface. 2. Using a text field and then automating creation of the option in Single select also is not possible since I believe it doesn't allow update of the Single Select options through "Run Script" in automation?

I have an email table with field agent that extract information from an email. I want to use data from another “events” table to match the result from the field agent and get the best possible match. Any suggestions on how to achieve this?Regards