Automations

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 th

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.

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 supp

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

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:

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

Hi all, I’m using Airtable as a PM collecting feature requests from my stakeholders - I want to assign a status to those requests (i.e parked, exploring, on roadmap, completed, out of scope) and want to trigger an email when the status of their request has changed. The trigger is fine but I only want the trigger the email when the status is changed the second time since i have a separate trigger for the first change sending a ‘feedback’ field in the email while the status trigger is just to inform them of a change to their request. My idea was to create a column with a formula that counts the number of modifications to a specific field (in this case status field) and set the trigger to fire when {count of modifications} > 1 so that it will fire if updated in the future everytime the status field is modified. Curious to see if this is possible. Thanks!

I have two tables, one is Parts and the other is Updates. For every Part, there are 1 or more updates linked to that part. The updates have a “Type” field, and can be one of several types of updates. For this, I am concerned with “Test” and “Test Request” . Basically, someone can add a record that is a Test Request. This causes the update record to show up in a queue so that our operators know to test the part. When the part is tested, I use the API to add a Test update to the same table. But when this happens, I want to check off a field in the original Test Request Record, “Fulfilled”. I don’t need to link the two records at the moment. But the question is, how do I find the id of the Test Request Record when the Test comes in? (When a new update is made and it’s of Type=Test, I want to check off all the Test Requests for that same part)

I have a table with services I have a table with the tasks associated with (linked to) services I have a table for my sales. I have a table for my deliverables When I add a new record in my sales table and I pick the service that was associated with that sale, I also want it to lookup the tasks associated with that service, then create a separate record for each of the tasks that need to be delivered, in my deliverables table. Any suggestions welcome please!

Hello, Is it possible to move a record from one table to another table in the same base when a future date is reached? i.e. Record A in Table A expires 25/11/2022, on expiry Record A is written in Table B. If this is possible, how would I go about implementing it? Is there a Script I can use or do I need to Build an Extension? Any assistance you might be able to give would be very much appreciated. Many thanks in advance!

Hi Airtable Fans, I am a fan of Airtable Automation but can’t find out something. This is my automation goal: When create a record IF New Record match X condition (X could be “contain text …” in cell) Then send an email I don’t find how to put condition before sending an email. And if I start automation with condition “When record matches conditions”, then it triggers all rows that meet the condition, not only the new records.

Thanks in advance to everyone that helps me with this! For some context, I’ve built a Base with 2 tables to track my Customer order for items that we manufacture on per order basis. Here is the link to a Template Base Customer Order logs Factory Orders Status Tracker for the orders that are created to manufacture items to fulfill the customer’s order. The Functionality I’m trying to Implement is in the Factory Order Status Table. The factory creates a record in the table for each Item Style# for every Order and after a few days, they add a “Factory Ship Date” in a Date field. Now, I want to capture the Original Date/value that was entered in this “Factory Ship Date” field and copy it over to “Original Factory Ship Date” in case the Fact

Hi! Airtable newbie here. I’m using a Linked Record Field in a Form. If someone submits the form with having more than 3 linked records/items selected, I would only like to have 3 records/items (max) only recorded in my table. Any help is appreciated. Thanks

Hi, I’m trying to build out an automate with Airtabe and I’d like to use the webhook automation, however, I want to send a response to the webhook, is there anyway to do this in Airtable?

Create custom notifications, automate redundant tasks, and orchestrate work via integrations. To learn more about using this feature, read our support articles. To ask question about using Sync, post in the Sync community category.

Hey, I have a table where I have a formula column that automatically generates an Airtable form link that prefills a few data such as name and email before sending it. What I noticed is after someone fills out the form and submits it, a new row is created rather than Updating/appending the row I used to create the formula, does anyone know how to resolve this?

I feel like this has got to be a simple fix but I cannot for the life of me figure out how to make this work after looking through countless other topics on similar issues people have had. I have a Daily Fieldwork form that gets filled out when an employee does a task (there are several tasks to choose from). When that task is a “new install”, an automation creates a new record into another table (Table 2) that keeps track of all of our equipment ID numbers. That automation works great, it copies all of the fields into the new table without issue. I’m now trying to create a new automation to update specific records in Table 2 when another task (not new install) is selected in the Daily Fieldwork form or when a record is updated in the Daily Fieldwork Table where the form data gets inputted. It doesn’t matter to me which way to create the automation, I haven’t gotten it to work either way. Here’s a look at how I’ve been attempting to create this:

I’m having an issue when I try and tag an individual with their Slack ID in an automation I’m making. When I test the Slack message, it’s sending back the Slack ID number rather than their Slack name. I’ve attached a few screenshots of what is happening in both the testing area and in Slack itself. It’s obviously getting the information, but I’m not sure what I’m doing wrong that I can’t get it to list the person’s slack handle. Thanks for any help!

Hello, I’m trying to create an email automation, but I can’t seem to get users’ emails to generate in the “To” field. The email is able to populate emails from the users listed from the “Producer” field in the CC field as seen in the screenshots below. But, users’ email from the “TEST” field do not populate and I cannot seem to figure out why. Any recommendations would be greatly appreciated!