Automations

Hello,This is my first day with Airtable and I have a question. Ill be importing data via a webhook. Just one location per import (or filled out form that is imported to my Airtable). I I've connected each location to a individual ID for future export. I connected the ID's to all possible locations to choose from, and I want the ID for the imported location to show up besides it. However the ID's dont show up automatically.Probably a bit of a messy explanation, so here are some pictures:The first picture is where I want the ID's to show up. So beside the "ort" column is the "ort ID". I added this ID manually to make it more clear. On the second picture are all the possible "ort" and their respective ID's. So when importing a "ort" from my website form (automatically) I want Airtable to pull the correct ID from the other table and display it beside the "ort" on the first place. How do I do that?  

Need help with a Running Total automation script. Here is the script I have doctored from Airtable sample called Running Total.Need to update current record Balance field  (X) by adding the value of previous record value of Balance (Y) plus current Income value (I) or minus current Expense value (E). Formula should be X=(Y+I-E). Here is the logic:Trigger: When Form Is SubmittedAction: Run ScriptHere are my data fields: Date, Income, Expense, Balance, Autonumber.Previous Record: Autonumber 113 has a Balance value of $4,400.93Current Record: Autonumber 114 has a Balance value of null, Income of $1, then updated Balance value is $4,401.93.Next Record: Autonumber 115 has a Balance value of null, Expense of $5, then update Balance value is $4,396.93.Need help updating my script to look at any null Balance value and update it with the Balance value from the preceding Autonumber. Also needs to update all Balance values. If Income or Expense is updated on a previous record, it should

I have two tables, Projects and Employees. Employees are assigned to a Project as a linked record. I'm trying to create an automation that on record updates and creation of the employee field on the Project, a note field is updated with something like "Employee A assigned to Project B on X/X/XX" to keep a history of the assignments. How do I find the note field of the Employee to update when the change happened on the Projects table? The Find Records action won't let me select the Employee Name or RecordID. 

I have an automation that is sending a payment receipt to a client The document of the receipt is in an attachment field of my base and I want to attach that one file to my Gmail using the native Airtable automation.Please see my Loom below for details.https://www.loom.com/share/635ea73ecb1b46b390f91e25fcedf0a6?sid=3b203e01-804c-4550-831f-abac3537c332

Hi,An erroneous automation setup has cost all my automation credit all 50,000 in a fee hours.  Hoping to get it temporary increase in credit to run our business function.  All our workflows have stalled. Need urgent help. Much appreciated  

I would like to ask the Airtable community users - what is your experience integrating Airtable with platforms for online courses and online community, like Teachable and Thinkific??? Are these platforms friendly to Airtable integrations?I am asking because my nonprofit has been using Kajabi, however, it doesn’t play nice with Airtable or other integrations. Because of this our operations are unnecessarily complex. Anyone had success linking Airtable with these or other e-course/online community platforms? TIA!

Hey friends'I'm building an automation that will detect when a customer is in "Followup" status + 3 days have passed since he entered the list.I want that when this condition is met (I have already built the condition) - the system will fire me a webhook with the customer's information.I understood that this can be achieved via Run a Script but so far I have not been able to find the correct code.If it is not possible to fire a webhook with the customer's information, I would appreciate your help in firing a webhook only with the record ID.Has anyone tried and succeeded yet?Thank you!

Hi, I have a many to many relationship within Airtable and trying to link them with the "Linked To" Field.One distributor can be associated with either multiple manufacturers, or other distributors. A manufacturer can also be associated with another manufacturer.--- Project ---My goal is to find the most commonly used manufacturers between distributors.The manufacturer is for Packaging Automation equipment, namely a manufacturer who has a machine that can fold up a box automatically, around 20 per minute.There are many distributors though, that sell a box folding machine, but also with some sensors, some conveyor belts, and then maybe a machine also at the end that can fold the box, or stack the boxes, etc.In my example (real life), there are manufacturer names Syntegon and Econocorp. And then there is a distributor called "Bay Pack." Bay Pack uses both Syntegon and Econocorp machines. And they also use another distributor who specializes in Conveyers, called SLR Systems.I decided to k

Can anyone help me? I have an airtable set up with a start date and time and and end date and time for workshops I'm holding. I need to export it to google sheets so I can upload them into my ticket system. When I export the date it come in the wrong time. I've been playing with sheets with NO LUCK! This is a link to a public sheet of what I am trying to do if anyone would look at it and help I'd be forever grateful! See notes on the sheet in red. https://docs.google.com/spreadsheets/d/1m1nd5eKUod2kap9ELEctocg9BptIzKMogjJert5XCUM/edit?usp=sharing

I'm sleuthing but not getting anywhere - would be grateful for pointers for the following which is the crux of my business.  Is this an automation? Or a script? Should I start looking at Make? Thank you so much. Table A - Long List of People (500+)Table B - List of One-off Events (500+)How best to create Table C - Shortlist (50+) people going to 1 event?I've seen the Event Tracking Base and understand the connected table structure but there are so many People/Events and wondered if, instead of manually typing the person or event into a field, I could go to Table A, scroll through and tick let's say 50 people to go to 1 event in Table B, and have that create a new separate line item record in Table C that I can then use as a lead to chase (without creating duplications if they are already on the list)  

Hi, I can’t connect google drive with the airtable account in the automation “update google docs”. It send me this when i go in sign in : Can someone help me ?

I want to do upsert using field of type decimal as matching field, but it does not work if number is whole integer, like 12 or 12.0. Item was not updated and instead was inserted new oneI know it is possible to use some hack, sending number as a string with exact precision and using option typecast: true, but it would not fit my automation task 

I have a script that runs in google apps script and deletes all the records in a airtable table one by one, since I am new to coding and don't know how to code can anyone help me to modify the script to delete the records in batches of 10. I used chat-gpt to generate the script.The script that deletes airtable records is:function deleteRecordsInBatches() { var airtableApiKey = "API_KEY/ACCESS_TOKEN"; //Paste your apiKey or accessToken here var baseId = "BASE_ID"; //Paste your baseId here var tableName = "tab3"; //Paste your tableName // Number of records to delete in each batch var batchSize = 10; var tableUrl = "https://api.airtable.com/v0/" + baseId + "/" + tableName; var headers = { "Authorization": "Bearer " + airtableApiKey, "Content-Type": "application/json" }; // Fetch the initial set of records var recordsToDelete = fetchRecords(tableUrl, headers); while (recordsToDelete.length > 0) { var batchRecords = recordsToDelete.splice(0, batchS

I have table with many fields, all set to Simple String, and the automation simply logs all the payload from a web hook. I periodically but inconsistently get the dreaded "Fields" could not be converted to a string error. I am trying to troubleshoot WHICH field it is given, but I am not able to find any additional details in the run history other than "Fields" could not be converted to a string. Is there a log somewhere where I can see exactly where the error occurred so I can troubleshoot and fix the error? Or are we simply left to guess where the error occurred?

I have a table that has a parent child relationship setup through ID and parent_ID fields. I have number fields on each record and when an automation is triggered I want to add the child record's field 2 and field 3 values to the parent record's field 1 value. I've setup the automation to trigger from the child record. It looks up the parent record, but when I try to update the parent record and set it's field1 value to current field1 value+child field 2+child field 3, I get an error.How can use a simple formula like "+" in the automation action?

I am wondering if the following can be done and if Airtable can execute what I need. Below is the overview:Import from Excel/Google Sheets business financial data (turnover, profit, costs) Hold in relevant columns within Airtable, referenced to the specific businessAutomatically classify data into different fields if terminology is not perfectExport this data into a preformed Excel spreadsheet, with the data being entered into the correct fieldsThis might sound simple to some, complex to others...we are just looking to take financial data, upload and get the system to classify and spit this out into a different form in a specific format, for use by a different team.TIA

I am trying to create an automation and I am trying to setup a POST webhook using the documentation at: https://airtable.com/developers/web/api/create-a-webhookBut every time, I get a syntax error in the first line. I have ensured all the correct data was entered, like my BaseId, Token, and Webhook URL.I am stuck! Any guidance would be incredible 🙌 

Hi guys, I am wondering if someone has figured out to add a signature to the Gmail, send email action in Automations. I have tried a direct pase and using html? The automation works perfectly, but the signature is an important factor that I am hoping to add.

I am hoping to use the new "repeating groups" feature to send me an email reminder a week before the due date for all the records in my base, which has several tables. When I go to "find records," it makes me choose just one table. Would it be possible to pull the records from all the tables at once so I don't have to remake the same automation for each table? I figured the idea of "repeating groups" was to avoid remaking the same automation over and over. Thank you!

We've built a ticket management system and every ticket has a "Status" and "Assigned To" field. I'd like to send a Monday digest email that lists all tickets "Under Review" - but send as separate emails to each person who has been assigned a ticket and show just their ticket details. I was able to start with this article, but this automation only sends 1 email, which I can send to everyone listed as "Assigned To". https://support.airtable.com/docs/how-to-create-email-digests-with-automationsIn the To field, I've put the List of Emails from Assigned To found. This produces a result like "Name 1, Name 1, Name 2, Name 3, Name 3".Instead, I want to send individual separate emails to each person, showing just their tickets. Is this possible? 

I have a script that retrieves data from a google photos library using google apps script and writes the data to a airtable base, I have no coding experience and have generated the script through Chat-gpt. The script retrieves all the album names and the number of photos in each albums.          What I want to achieve is that a script should delete all the existing records in the specified base before writing new records to it, using google apps script. Can someone please help me by modifying the script for me?Here is the script that i use to retrieve data from google photos library and write the data to an airtable base: function syncAlbumData() { var apiKey = "apiKey-accessToken"; //paste your api or access token here var baseId = "Base-ID"; //paste your base id here var tableName = "tab3"; //paste your table name here // Get albums from Google Photos var albums = []; var nextPageToken = null; do { var pageData = getGooglePhotosAlbums(

Different usage limits for Automations depend on your Airtable plan. See the screenshot below for a quick highlight, or visit airtable.com/pricing for more details.

Hi,I'm pretty new to Airtable, and I've set up a table with a list of students that my organization works with at a certain school district, where each record is an individual child (we only work with some of the children in the school district). I've linked that table to another one that has a list of all of the reading assessments completed by all children in the school district, where each record is an individual assessment("Mastery Test" = MT) .Here's part of that first table (record = student):Here's part of the second table (record = assessment):I've got the formulas set up that I need, but it's been extremely time-consuming to manually link the records between the two tables (there are over 1,500 students & 36,000 assessments). I've read through the general guidance about using automations, and also related questions in the discussion board, but I can't find an answer to what I'm trying to do, which is to tell the first table (the list of students): only link the record

I am creating rows of tasks that apply to various places or singular places. I want to ensure that each place gets their work done. Column A - task name Column B - Task template created? - yes or no dropdown Column C - Locations applied to - dropdown lists "ALL" and the individual locations Column D - Completed task or not? I want it so that if Column C says "ALL", it duplicates it automatically and creates one row for each location to be completed. How do we set up that automation? Can Airtable do arrays like that based on a dropdown? I'd also like it so that if I add another location to the dropdown, it creates one.

I am trying to run the following script: const tableDeals = base.getTable("Deals") const queryDeals = await tableDeals.selectRecordsAsync() And I am getting an error “Your script exceeded the 512MB memory limit.”. Though the Deals table has only about 3500 records and weighs about 4 MB. What am I doing wrong and how can I fix this? Thanks!