Automations

Hi! I am using automations that result in sending an email via the Gmail integration. I am looking for a way to track the emails that I am sending through airtable’s gmail api (email opens). gmail has several ways to utilize email trackers (Chrome extensions, built in methods, etc), but I can’t seem to find a way to make them fire when sending the emails via the airtable automation (tried using “mailtrack” add-on). any ideas on how to make them work? or other ways to track emails when sent via airtable’s gmail api?

Hi, I'm trying to explore using Airtable as my Stocktake system. The idea is using an external form (Jotform, Typeform, etc) I assign a location, scan product barcodes and when I'm done, I click submit in a form and then all the records will be created in a table. The problem I hit is that there's no automation to create record per line of text.. Do you know any work around for this? I am open to use external automation app like Zapier or Make

Hello, for the past few days, we've been getting fails on automated tweets. This seems like an error on Airtable side, right? Is everybody experiencing this now? This shouldn't be about crossed limits, as the limit is based on the connected account right? So it has to be that AT still uses the API v1.1 as opposed the v2.0 version?Thanks!

A question that gets asked often is how to bulk download your images from an Airtable table. There are paid solutions that work (eg via MiniExtensions) but there does not seem to be a good solution that is free and easyish.I found one that works for me.To download the pictures there are 4 basic steps and an optional fifth step to bulk rename those pictures:step 1: download the table as .csvstep 2: get the URLs of each imagestep 3: create a text file where you paste all the URL'sstep 4: use e.g. Internet Download Manager to download via those URL's all the images into a folder(optional) step 5: bulk rename those imagesWhat you need: a text editor (e.g. SublimeText), a download manager (e.g. Internet Download Manager) and, optionally, a bulk renamer (e.g. Flash Renamer)step 1When you download a table as a .csv file and then open that .csv file, the column with the images will instead of an image have the name of the image file + its URL.So every cell in the csv that in Airtable would hav

Hello,I currently have two connections between pabbly connect and airtable.Both connections go to the same base but, different tables.The base is called SQUARE, the tables are TRANSACTIONS & INVOICES.Using the  airtable personal token that I created for this base I should be able to connect pabbly and send any information to airtable I need.1) the connection to the INVOICES table works perfectly with no problems.2) the connection to the TRANSACIONS table is giving me the error.Both connection, use the same airtable personal token and only 1 works.I already try to make a second airtable personal token ( 1 for each table) but, I got the same error with the TRANSACTION tableIn conclusion, it looks like their is some type of glitch not letting pabbly create records on one of the tables of the base but not the other. I need this fixed as soon as possible.  this is what I get in pabbly when sending information to the INVOICES tableThis is the pabbly workflow for invoi

Hi all, My scripting ability is pretty basic, so bear with me. I’m trying to automatically update linked records based whenever a record in a table is updated. Basically as follows. We have a table called “Jobs in Progress”, and each record in that table has separate records attached from time to time in another table called “Tasks”. It isn’t uncommon to have several records in “tasks” linked to one record in “jobs in progress”. Records in “Jobs in progress” have a checkbox called “completed” which is either manually or automatically selected depending on several conditions. Records in tasks also have a checkbox called “completed”, which are usually manually checked. What I would like to achieve is that if any record in “Jobs in progress” has the “completed” checkbox checked (true), that any linked records in the “Tasks” table with the “completed” checkbox unchecked, update so that they are checked, or true as well. The reason for this is that on some simple tasks we overtake the proce

I'm trying to automate the linking of one record (a website enquiry) to another record (an adviser - in another table) i'm struggling to make sure I only link one enquiry to one adviser.I have a formula field {Time Since Last Lead} I was hoping to either create a view with just the record with the highest value in this field or just find the record with the highest value in the automation but i'm stuck.  

Using the Auto-number type field can be great, but it is also very limiting when you need to start with a certain number in particular. And if you create a record and then delete it, the next record you create will not have that deleted record's number, but the next one in sequence. For this Project Tracker, the client started using Airtable for job # 2000 (and they have a hundred more after that), which means they created 1000 EMPTY records just so that they could get to the real data at # 2000+. It's also no good to go out of order, so if anyone accidentally creates and then deletes a job, their list of jobs is not sequential. Yes, we can limit record creation with permissions, but I want to know if there is another way I can automatically create the next job record and set its number by finding the highest number used and adding 1 to it. And if a record gets deleted, I want to be able to start where we left off! For example, I am working in a test version of the base to play ar

Hi I have an automation which is triggered by a checkbox field. The records in the table are recursive in nature with id->parent_id linkages. When I turn the checkbox on for a row it does some stuff and then turns that checkbox on for all the children records.The question I have is - if I turn the checkbox on the topmost parent row on from another automation, will that "Update Record" action in that automation wait for all the triggers to fire in the recursive table or will it the "Update Record" action complete as soon as the topmost parent's checkbox is updatedIs there any way to wait till all the recursive actions are complete?Thanks in advance for your answers 

Hello community,I am a part of a family office specializing in Commercial Real Estate investment, and we're currently working on setting up a streamlined workflow to efficiently manage our investment closing processes.We have a 'pipeline' base that tracks all of our potential investments. As an investment reaches a particular status within this pipeline, we want it to automatically generate a predefined set of tasks in a separate 'workflow' base. These tasks should be assigned to specific users and tagged with the corresponding investment.In our 'workflow' base, we've already set up a table that lists template tasks to be completed for each investment.We're looking for a way to automate the process such that when an investment hits a certain stage, the system pulls the template tasks from the 'workflow' base and adds them to another table. This should be done while ensuring each task is uniquely associated with its respective investment. This functionality is crucial as we often have m

Hi There,I have a list of individuals in a text field whose name often repeats. I want to know the best practice in automatically taking only the unique entries, i.e. only listing each person's name once, and creating an updating list of those entries in a separate table. The idea would be to create an automatic table that lists the names of people if that person's name is listed in the "name" column within a specific calendar month. 

Hello all,Within my team's workflow, there are two tables, a campaign and task table, that we use a good amount. One of the fields on the campaign table is a "Deliverables Needed" column where a campaign owner would list out the deliverables needed and separate each deliverable that is needed by commas. Currently, I have an automation where if a campaign record matches the conditions of having the "Deliverables Needed" not empty, a new task is created with the name of the deliverables needed field from the campaign table. My problem comes when I want a new task created for each deliverable separated by commas rather than the whole field. For example if for one of the campaigns, the "Deliverables Needed" field has "Article, Press Release, Stories," there will be only one task created named "Article, Press Release, Stories." I instead want a new task for "Article", another one for "Press Release," and then a third one for "Stories." I also have other fields I want fil

Hi,I am attempting to build an automation that will help assign a student to the specified time slot.I have 2 tables, 1 of which is for trial arrangement, and another for enrolled students.Both these tables have the following fields:Day, Timeslot, Coach, Location.I have another table for the available slots.There are 6 records with the exact same Day, Timeslot, Coach, Location. (each timeslot can have up to 6 students (regardless of trial or enrolled))When a child is about to enroll for example, a button will be pressed, triggering a webhook to integromat/make.com, which will get information of the record.How can I make integromat/make.com find this slot if it is available, to assign the student to?I've tried doing a search, but it seems my formula might be incorrect, as it returns with a 0 bundle 

Do I understand correctly that this solution https://community.airtable.com/t5/automations/attachment-automation-to-add-and-not-replace-attachment/td-p/104396 (or others) are no longer feasible to take attachments in a Find Records step and append them to a different attachments field given the attachment URL changes in late 2022 https://support.airtable.com/docs/airtable-attachment-url-behavior ?Are we essentially limited to doing this via API or just using lookups?

Hi all,I'm writing after thoroughly searching the forum and endless tries, so I really hope someone can help here...My scripting abilities are very basic but i can read and understand it, and can even write it with the help of GPT &#x1f605As part of a multistep automation, I'm running a script that takes apart a poorly formatted text field from my "form" table (using input.config) and creates multiple new records in my "contacts" table. The script works well and the new contacts are being created with all of the relevant text fields in the new table.My issues began when I tried populating other types of fields.. After lots of searching I fingered out that to update a single select filed it needs to be an object, and i finally managed to do that.Like this:    record['Marital Status'] = { name: 'Single' };   I'm now trying to link another table to these new created contacts. This is the "Families" table and it is already referenced previously in my aut

I am trying to build an automation or formula for this scenario:Student #1 has been enrolled in school from the dates 7/1/2018-6/30/2023. I have a field in this table (Students table) for Enrollment date (7/1/2018) and graduation date (6/30/2023). I need the field " School Years" to populate with the respective school years this student was in school for. Ex: SY 2018-2019, 2019-2020, 2020-2021, 2021-2022, 2022-2023 - this is a multiselect field. This will be unique for every student, as their enrollment and graduation dates are varying...I have build a table named School Years and have the start and end date for each school year as a record. I would love this to be automated so that every time we have a new student and their graduation date changes, it will update what school years they were here for.This seemed so easy to do in my head and I have tried every way to get this to work, but I cannot seem to figure out how to have ALL school years they were enrolled for to show up in a sin

Good morning, I have a loop going trought records: before the loop, im creating a json file, and I add elements of eache records im going trough in the loop? In the update record inside the loop, im chaning the record where the input empty json file is, so at the end, the input file has now a new value. At the next iteration, the script should add an element in a json file with  1 element inside, but instead, it is using the empty json file created before the loop. Ive checked the input value, I don't overwrite the file, it should correctly add a value, the problem is that the loop on airtable donc update the value if it is still in the loop, any solution to make sure Airtable will use the updated version of the cell where the json is instead of the first version?

Hi, I used this automation for 1 year, and it has always worked, but today it started to fail to run. It is just an easy automation; when my customers fill out a form, a record is created in a table, and the automation sends an email. What can I do to solve the problem? I also tried to create again the automation, but nothing!Thank you   

Hi! We have set up a view in which products with a value lower than 3 end up. Then we are alerted by SMS. This is our stock level, which is also entered manually. As soon as we change the stock level manually, e.g. to “12”, two automations are triggered, as this is first triggered with the value “1” and then with the value “2”. Is there a way around this problem?

I have a situation where:1) I use a template to create several records in "Table A". 2) I link those records to a singular record in "Table B" on creation.I have tried using an automation that checks when the record is created in "Table A", finds the record in "Table B" and links the record from "Table A" to the record found. Tests for individual records work (when I am testing the automation): however, it does not work when I try with the template. I have also tried using a checkbox that populates the chosen record in "Table B" with the respective records in "Table A" by looping through the designated records in "Table A" and then linking them seperately to the chosen record in "Table B".  Both of these methods have not been working for me. Any suggestions?

Hello, I would like to ask help on how I can modify this Delete Duplicate script from Airtable, so that it:1) Runs automatically everytime2) Deletes only the older record and keeps the most current one (based on Last Modified Time row)Appreciate any help!===================================================================================== let settings = input.config({    title: 'Delete duplicates',    description: `This script will delete duplicate records in a given table according to the value oftwo input fields. Duplicate records are detected when they contain the same cell value for each identifyingfield. For any two records that are considered duplicates, it will use a third comparison 

I have multiple tables of criteria, and a table of people with a tag that identifies which criteria table applies to them. How can I use automation to duplicate an individual's entire corresponding criteria table (as an interface) for each person in the people table? Currently, I can only find content on automating the creation of new records, but my table of criteria is pretty large, so it seems rather unfeasible and redundant to manually input every criteria in as a record to be added. Additionally, I thought about having users themselves duplicate the interface/criteria list that is relevant to them, but from my understanding they would need creator access to the base, but individuals should not be able to modify the original tables of criteria, only their individual table. Lastly, I considered linking people to criteria within each criteria table, and while that would make giving people a personalized view easier, it doesn't work around the problem that individuals s

Hi everyone, you might have seen the new Record Templates feature, which is sooo helpful. However it comes with a limit of creating 100 records per base in Pro Account. We are a small company, and need this feature to automate our processes, and cant go to Enterprise account. So I was wondering about ways to keep using the Record Template feature beyond the 100 record limit. The issue is that we need to save different working templates for different cases in our business processes but we dont actually use them all the time, or even at the same time. Having a record template is for us a way to have transparent processes saved, and they get rolled out when triggered. So we actually need to save way more options for Record Templates than 100. 1. IdeaCreate different other bases with each 100 record template records, and sync the bases after the templates were used. This can already work, but it seems a bit complicated2. Create Record Templates only with Automation

I just had at LEAST 20% of my automations consumed within less than an hour, that's about 10,000 automation runs depleted in an instant and I am hard pressed to believe it was not a bug.What I assume is that this automation called new inquiry started triggering on old records already that exist, even though it was only supposed to trigger on record creation.If you look at the screenshot, you can see there's a ton of these automation triggered for no reason.Is there a way for the customer service team to reinstate the automation runs that were consumed?

I have a script that writes the data that is collected from a google photos album to airtable. The script is purely genereated from cha-gpt, I have no experience of coding and indeed I don't know how to code. Could someone please help me IF POSSIBLE, to modify the script to update the existing records in batches of 10(assuming all the existing cells will be empty/blank before updating), instead of creating new records to write the data. The script that I use to write data to airtable is: function listAlbumData() { var apiKey = "API_KEY/ACCESS_TOKEN"; //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 = getAlbums(nextPageToken); if (pageData.albums && Array.isArray(pageData.albums)) { albums = albums.concat(pageData.albums); } nextPageToken = pageData