Automations

Hi Everyone,I have an idea that I am really struggling with and would appreciate some help. GoalCreate a script/Automation that loops through table 1 to find matching record based on multiple conditions and link those records with table 2.Base structure:ListingListing contains all the properties we have in our portfolio and has various field types. For this specific idea, here are the ones that matter:House_Listing_Price (number)House_Budget_Range (single select)House_ViewType (multiple select)House_bedroom (#)House_land_type (single select)House_property_type (single select)House_region (linked records -> third table containing list of region)OpportunitiesList of all active house searches we have for clients. For this specific idea, here are the ones that matter:

Hey all, I noticed that my automations that rely on new rows as triggers on Google Sheets no longer seem to be triggering. I created a new base and a new sheet and tested, just to discard issues on my sheet or AT base, but it looks like this new automation didn’t work either. Is this issue happening to anyone else? I checked the status pages of Google and Airtable, but couldn’t find any info. 

I’m wanting to automate posting of Slack messages using the Block framework, to simply have a nice  URL button, but when I submit even example code pulled from Slack’s API docs, the code simply posts as text, the blocking doesn’t seem to apply.What am I missing? Is there something either in Airtable or Slack to turn Blocks on? 

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?

What are some good software options for automating generation of word docs using data from a record in Airtable? I would like to be able to trigger the automation in an Airtable interface (as opposed to an extension on the data side).

Hello everyone,I’ve created an Airtable to help manage pre-production workflows and am struggling to get what I think is a simple automation running; I’d like that when a record is assigned a contact person (The “Assigned?” field is “Yes”) and given an “Assignee” to carry out this task, that the status of that record be updated in the “Interviewees” table to “Contact Assigned.” This is the automation I’ve set up so far but no matter what I do, I keep getting the “Record does not exist” error.

Hey everyone! I just launched ETL++ on the Airtable Marketplace. It pulls data from any API into your base with clean field mapping. What it does: Connect to any REST API (Yelp, Google Places, HubSpot, Stripe, your internal tools, etc..) Map JSON fields to Airtable columns visually Smart upserts: updates existing records, no duplicates Schedule auto-syncs every 30 min, hourly, daily, or weekly  I’m actively collecting feedback and will build custom features for users.Give it a try and let me know what you think or what you wish to be added! Check it out here →  

Hello all.I’m looking to have a column (field) of field agents run/process once a week on a Monday morning. FYI these agents a prompted to go out to the internet and retrieve x information. There are no automation options specifically to do this - am I missing something or how else can this be achieved?Currently I’m thinking about having an automation that changes a field in each record (say make it today’s date), and that is something the field agent is monitoring to kick it off and run. Feels a bit hacky, but if anyone has better ideas please let me know. 

Hello! I need some help with an automation setup.I’ve created an automation that ends with a loop step, and I would like to add one final action after the loop completes — for example, sending a notification once the last record in the loop has been processed.However, Airtable doesn’t allow adding steps after a loop, so I’m not sure how to handle this.What is the best practice to be notified when the entire automation (including the loop) has finished running?Is there a recommended workaround or pattern for this?Any advice would be very helpful, thank you!!

Hi Guys, Has anyone found a way to schedule an export of a view and send it as an email attachment as a csv natively in Airtable (possibly with a script)? Thanks

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 t

We built a WordPress Plugin for Airtable that does not use embed or syncing (copying).This means the info from your bases will be displayed in real-time alongside your webpage, matching the same theme and styling, and it will look great on any screen size.I'm curious to see if you have a use case for this at your organization.Since we're still adding more features, I'll set up the first 50 organizations for free (WordPress users only). Just send me a message or add a comment here or . Please be patient till we get to you 🙂The plugin connects using Airtables API, currently it will let youCreate Unlimited pages with Cards, Tables, Calendars Layouts using Airtable dataCreate WordPress based Airtable logins and Portal pagesReal-time Info from Airtable. No EmbedsUpdate and Create Airtable records from WordPresshttps

Hi everyone, I have a question about automations and what the best practices are when dealing with external API calls.We have an automation that enriches records by pulling data from Google Maps. Every time a new record is added to the table, a second automation is triggered: it uses an enrichment API to find an email address from the website, verify it, and then update the record.The issue is that this enrichment step takes a few seconds for each record. Because Airtable runs automations one-by-one and queues them, this causes huge backlogs of pending automations, which slows everything down and sometimes causes the system to get stuck or bug out.My question is:What’s the recommended best practice to avoid infinite queues or stuck automations when using external APIs that take a few seconds to respond?Should we batch records? Or is there a better architectural approach?Any guidance or suggestions would be g

Hey all - I need your helpBasically - am trying to create an expense reimbursement form that will then create an automated email to trigger approval/payment.I have created a form in Fillout that has a form and a sub-form. Users can use the sub-form to input 1 or more items to their submission. Once filled out and submitted it gets ported over to Airtable. (all good - this works)What I originally wanted to do was to have it take all the records that are created in Airtable from Fillout consolidate into a different table with a roll-up field to get the total payment needed. (for example, if you have 3 items for reimbursement, fillout creates 4 records in Airtable - 1 for each item and 1 for the overall form info). However, I had to create a workaround because the info for each item for reimbursement was being ported over to Airtable from Fillout immediately upon creation. The workaround I created was to add a trigger at a t

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! 

I have over 30 Google Forms to Airtable automations setup which have been running very smoothly until this week when suddenly none of them are running anymore. I’ve tried resetting the connection but none of them want to trigger when a new form is completed. They only seem to work when I “run as configured” but that’s not really automated. 

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! 

New to airtable. I’m looking to have Airtable create a record when someone submits a Google Form. See image below. Action Type > Google form/create response Connect Google Account + Select Google Form Spreadsheet: select spreadsheet. Worksheet: select worksheet Help: 5) Row data… I select the relevant rows from the spreadsheet, but then within each of the “Columns” I don’t see any data to pull on. Confused as to what I need to do next.

We're trying to send a email with a unique booking code from a list of booking codes sent to us when a form is submitted.

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?

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

Hi everyone,I’m facing an issue with an Airtable automation and would appreciate some help.In my automation, I’m trying to Find records whereProject Number  contain  Project Number fxBoth the values are sameIt give error:-  Invalid filter on Project Number (Invalid filter value: [ "P454" ])Could you please the solution for it.

Hello - I duplicating an automation and was able to make 7 duplications but I am not able to duplicate anymore. Is there a limit on how many we can duplicate? 

Hi!I have setup email automations through Airtable (trigger: when a record enters a view - action: to send email through gmail).The issue is the email is being sent at midnight, which makes it evident that it is not a personal email from our team. How can I setup either the filter on the view, or the trigger/action so that all of our emails are sent at 8am PST? We have an enterprise account, so I feel like this has to be an easy solution, however everything I'm finding seems to incorporate like four additional columns and formulas, which seems really inefficient...

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