Automations

Hey teamI have an exercise, that has been squeezing my brain lately, and I haven't come up with a specific solution yet. Let me explain first, how the process works, I believe it's crucial to understand how records are being added there. The table above, represents invoices from the highway tolls recieved by the cars rental company. One invoice comes from one entity, and includes several toll gates inside.In this case, we received 2 invoices, T1 and T2, every single toll inside has a different cost.On the invoice T1, there are 5 tolls, that have been passed by 2 booking numbers B1 and B2 (two unique customers). The total cost for now for B1 = 6$ (1+2+3). B2 = 9$ (4+5). Customers haven't been charged yet, that's an important information.Before we attempted to charge invoice T1, invoice T2 from another entity has arrived. On the invoice T2, again the same customers were identified. This time, the customer from booking B1 passed 2 tolls (with the cost of 6$ and 7$) and B2 passed

Hi allI am trying to have AirTable send out a webhook at a specific time for records that meet specific conditions, but I realized the "At a scheduled time" trigger does not really allow me to go through conditions to search for specific records.I was considering to work around this by changing the trigger to "When record matches conditions" and set one of the triggers to a formula field with DATETIME_FORMAT(NOW(), 'LT'.But I realized the system does not update the NOW() field in real time (seems to be around every 10min or so?)Is there another workaround within AirTable itself? Or do I have to use make.com/zapier to make this work?Just for reference, I simply want AirTable to send out a message to my team members at a specific time if there's a record that specifically meets the conditions.Thanks in advance

Today, I set aside some time to explore batch techniques for use with await table.updateRecordsAsync(), figuring out the most records that I could update with the 30 seconds allowed within an Automation Script. I wrote a script that updates a Status from “Todo” to “Done” in batches of 50 records at a time that updated approximately 7,000 records within the allowed 30 seconds - before the Automation timeout stopped my script. The same script works as expected within a Scripting Extension App, and takes ~4 minutes for a table with 50,000 records. Although my batch Automation script was my first attempt, and perhaps a little mediocre around the edges - functionally it worked without error - and from this I’m assuming that the most records anyone could hope to update within one Automation script is 7,000 records. //Script can update approx 7,000 records before reaching the time out of 30 seconds within an Automation. //Target Table let table = base.getTable("Table 1"); let query = await

TLDR: I have a functional automation that creates and updates Google Calendar events based on records in a table being created or edited. The problem is that if someone RSVP’s (yes / no / maybe) to an event, and later the record changes, the automation updates the event, losing the RSVP status for each person in the process. Does anyone know if there’s any way around this? Otherwise, I don’t think I’ll be able to use Airtable for this part of the project. :frowning_face: Digging deeper: This isn’t normal behavior for Google Calendar. If I manually create an event that people RSVP to and I edit and save the event, attendee RSVP info isn’t changed. Even if I remove every attendee and re-add them (as I thought Airtable might be doing) it still keeps their RSVP info. I don’t think it’s deleting and creating a new event, because the GCal Event ID isn’t changing. Perhaps it’s deleting every attendee, saving the event, and re-adding each one, every time there’s a change? I don’t think it’s

Hello, I'm hoping that I could get some help writing a script to get around the 100 records limit with Find Records. Currently, I have an automation set to run each weekday at the end of the day to find all the records that meet two specific conditions and then a new record is created into another table.The automation works up to 100 but if I have more than 100 records, it will leave out the others. It looks like there might be a workaround for me to use a script but I'm not sure how to write the script.I basically need a script that will find all records that match a specific condition (not just 100 of them) that I can place in front of the other actions I have. Is this possible?@Justin_Barrettor @kuovonne any chance you might be able to help me with this?

we have several automations that involved sending an email with an attachment. they worked as designed on 11/30/22. However today, 12/2/22, they fail to send. i've attached a screenshot with the error. The error says "Microsoft reported an error while processing this action: Failed to fetch an attachment".The automation is designed so that first the person record is selected. Then an update is performed that links the record to a record in another table that holds the file to be attached. The Attached file is included as a lookup field in the person record. This portion of the automation all works. It fails in the next step, when the email is supposed to be sent. Normally, this all happens within seconds.any ideas on how to fix this?

Hi everyone,I'm trying to create an automation that updates the record based on info from a webhook. Currently I have created a webhook containing some usernames and based on that I want to find a username in my airtable and update it with info from webhook.My plan was to:1. Create an automation with webhook trigger2. Run a custom script which finds a certain record ID based on username received from webhook3. Use that record ID for an update record actionI'm stuck on step 2 since I don't know how to create a custom script that returns record ID that can be used in further actions. Any help is appreciated!

Hello all! I’ve got a conundrum. The company I work for is very large, and it’s not feasible for us (financially speaking) to give all the retail employees accounts so they can access the Airtable base. (we’re using Airtable as a product database for use on the sales floor.) (currently it’s only in a testing phase at one of our stores). Anyways, I’ve worked around that by providing them with a publicly shared link. however this obviously does not allow them to change any records, and this is where my problem begins. I have a formula that runs by selecting a single item from a linked record, and comparing that selected item against the rest of the database. However because they don’t have accounts, they can’t change the selected item for (lets call the formula, “recommendation system”). I have figured out a workaround for the access part by using a form link and setting that to open by activating a button. I had to make this on a separate table because after a form submission, it creat

Hello,How can we do, in a script, to apply a filter that returns records that match two conditions.My attempts :let filteredConcurrents = query.records.filter(concurrentEdition => { return concurrentEdition.getCellValue('Edition Record Id')?.includes(editionAnumeroter.getCellValue('Record id')) }) let filteredRecords = filteredConcurrents.records.filter(catego => { return catego.getCellValue('categorie_texte')?.includes(categorie) })Thx for your help

Newbie alert! Our new, small quote+follow up Airtable database works, we have an automation to email quotes to clients. It works just fine. We would like to refine things a bit by adding a CTA link/button allowing client to accept the quote contained in the email in one click (or by creating an automated acceptance email in return). Is there a simple function in Airtable that would allow us to do this – or is this a new development/third party connector issue? Thank you.

I have a fairly complex set-up with Airtable automation and Integromat automation that does a whole bunch of stuff very nicely. I'll attempt a simple description of one part of it that is relevant to my request...People can use a form to "watch" for changes in a record. Their email address is added as a multiple-select option to that record when they submit the form. The automation I've set up sends them an email when that record changes.This all works fine but now I want to allow them to cancel this alert and I'm a bit stumped. My thinking is that they can use a second form which references the record and their email address and when it's submitted the automation will look up the record and remove the multiple-select option that matches the email address if it exists.I just don't know how to do this. I'm assuming a script will be required and I'm not familiar with scripting myself.Help? &#x1f605

Hey all. I’m trying to use WP Webhooks pro to export records into a custom post on our Wordpress website. We have real estate listings in Airtable and want to export this data including images to Wordpress, where we use custom post types as listings. Apparently this can be done with Webhooks. But I can’t 100% figure out how to do. I’ve been some tutorials online where they create a button in each record with formulas that fires a webhook for that particular record, which would be perfect. But how are the images exported? Any feedback and guidance really appreciated. Thank you!

I have an Airtable which contains several automation scripts that are being run. Is there a good way of automatically saving those scripts to an external source, or connecting them to a github repo (or something similar) so that version controlling can be done on them? This would be useful for me to keep track of what changes have been made and give me the ability to restore older versions of the script if something breaks. Apparently Airtable’s “Snapshots” do save the automation data, but I’m not sure in what capacity? The documentation online seems to mostly focus on the table data itself. Plus, there isn’t a way I know of to “look inside” the snapshot, only restore that version completely.

Hello everyone, I have a scenario where I am extracting entries from Google Sheets (different types) and pass it to #Airtable using #Make (#Integromat)The error that I'm getting is "Invalid URL in parameter", I mapped the fields from G Sheets (URL) to the fields related I have in Airtable (Type: URL). The URL fields that have value didn't throw any errors, only the empty fields have thrown this error.Error:Below you can find the scenario in #Make (#Integromat)below is the module (Upsert a record in #Airtable) that have the errors):As you can see from the previous image, When I tried to map the field as is while it's empty it threw the error, and I tried to use (ifempty) formula but the same happened.Does anyone have any idea of how to handle empty fields (especially URLs) ?Thank you!

I know this has been asked and answered, but I’m still confused about what I’m doing wrong. 2 tables, ‘Cust.’ & ‘Vehicles’. (1) Cust can have (many) vehicles (1) Vehicle can have only (1) Cust. I have the automation setup to add the ‘Cust. Name’ to the ‘Vehicles’ table, and then add the ‘Vehicle’ to the ‘Cust.’ table. ISSUE: Any customer who has more than one Vehicle is having the previous ‘Vehicle’ overwritten by the new one!?!? ASK: Please tell me how to fix this… (screenshots to follow) Thanks, dg

Hi team I’m at the very beginning with no-code tools and just trying to build my own ‘doodle’ homemade :winking_face: I used Tally to collect datas from 2 dedicated forms : the first one, for my guests i invited from Mailchimp. I have a database in Airtable, “guest”, which is replicated and segmented in mailchimp. Key is the email adress. the second for my events which are each under a own capacity constraint. Key is an agregated field including the name & date of the event in my “event” table. The 2 tables are linked with the rules 1 event to many guests | 1 guest to only one event When the user validate the first form : I’m calling the API to update Airtable “guest” I’m calling the second form with ?email get parameter the user books its reservation I’m calling the API to update the Airtable “event” BUT !!! The thing is, I can’t update an existing guest since the API always creates a new one. And I end up with 2 records with the same email key. Same issue with event. Did I mak

Hey there,non-coder here...I added extension "Create records for multiple templates". I hooked it up to run when a button is pressed. It is working correctly.But I would prefer for it to run auto once conditions are met. I know this can be done in automations with a scripting block. My question is - can I just copy and paste code from the extension into a scripting block for automation?I tried, but I am seeing a lot of red. I assume I am misunderstanding the foundation of the code, or I am missing a step? Would adding something in the input variables to make this work?

Hello, I’m trying to make an automation to send several records to my suppliers at a scheduled time but I cannot make my automation works. In my base, I have one table where I have hundreds of suppliers, and i’m using another table to register all the payments I make each day. I would like an automation to : Search all the payments made the day before Make a list for each supplier Send only one mail per supplier with all the records matching the condition {Date of payment} is yesterday The problem I have is that if I used as a trigger a specific time, i’m not able to make a list of each record by supplier. Either i have to send all the payments to all my supplier in one email, either I can select the records matching a supplier but the automation send one email per record so some of my suppliers will receive several times the same email. I have hundreds of suppliers and payment each day so making one automation per supplier is not an option. Anyone who can help me to fix it ? :sligh

Hello, I have a table that consist of region, and city, I would like to group the city by their respective region automatically, As i don’t have a proper idea how to do it. Should i go for automations or by airtable script?

Hi we have set up a new automation to run when a box is checked. Tests are working but when the automation is set live we don’t see anything in run history - appreciate your thoughts thanks Clare

Hello Everyone, I have 2 tables that have records I want to update. One table is called Inventory, and the other is Content Info. ‘Inventory’ is our bible but the ‘Content Info’ have some records that we want to update in the Inventory, I have a field called “Housenumber” for both tables, but because in the ‘Inventory’ we tend to have multiple records entered by multiple people for “Titles” (with different spelling) but with same housenumbers, this makes the confusion (i know). Now we need to find the “Housenumbers” in the Inventory with the same from Content Info, so we can update the fields we require by automation not manually. We’re doing this automation so we can update the field ‘Season ID’ and ‘Show ID’ I have references below: Content Info Table Inventory Table As you can see, “Jad Al Shoja” has records in both sides when I searched the “Housenumber”, but in the Inventory it’s 2 entries. So I made an automation: When a record is updated: Find Records: Update Record:

I have two tables linked together, one with Contacts and one with Themes. One contact can have multiple Themes. The table Themes contains the name of the theme and his URL. Every time a new contact is created, I want to send an email with an automation. In this email, I would like to insert the name of the theme as an hyperlink with his URL. Now, this would be easy if the contact had only one theme, but it can have more than one. I can insert the themes only as a List or a Grid, and even if I put the URL is not clickable, is just text. That’s what I have for now. And that’s the complete automation: “Typeform x Seekers” is where I have my contacts. There is a way to transform the URLs in the grid (in the column Status) in a hyperlink?

Hi All My automation script stopped working about 30 minutes ago. It is a very low volume 1 record at a time processing script I keep on getting a network timeout when trying to connect to a table or view Error: network timeout at: https://airtable.com/v0.3/table/tbladOGwmaD3TMOeH/queryForScripting? Anyone with the same problem?

Hi, I have a roll up field, let’s call it “income” What I want is to create an automation with these conditions: Every two days (scheduled time) If “income”>10,000€ I can make an automation “live”, that is: to send an email as soon as “income” exceeds the 10,000€ with the name of the record and all the info I want, but what I want is to check the situation on that time interval. When I chose as a trigger: “scheduled time” then in the configuration I have 3 options for fields: “Actual Trigger Time”, “Expected…” and “Next…” And that’s it. What’ am I missing or doing wrong?

Hey, i have a base with many record that contain an email, next to this email field there is a checkbox field. I know how to add this email into a “link to another record” field in a different base if I check the box with automation. But I don’t know how to remove it if I uncheck the box. I want to remove just the mail of the box that are uncheck and keep those that are check. tanks