Automations

I haven't been able to figure out how to pick a specific value from a synced field when I have a form submitted.  (Aka I want to set several fields specific values)I have a form that I have created for adding a new event for the Virtual event team.  Since I know several of the standard fields, I am auto populating them on submission; The Program Team (HHH) TIJP Type - Program.But I can't get any values for State to show.  It is a Linked Field from the Sync table (States)in the Events Base.  What am I missing here to get the value like I have in the two other fields to populate on submission?     

Hello! I have been using Airtable for a long time, with a Zapier integration, and ran into some issues recently that I hope someone can help me solve. I am using Airtable to collect appointments. The client's appointment time triggers Zapier to send an email reminder the day before at 9am.  This happens when the appointment moves into the "Reminded" view, using the filter to only show appointments that are scheduled for tomorrow. Since this would trigger to send the email at midnight the day before, I had to add a delay of 9 hours, to make this properly send in Zapier at 9am. Essentially, the day before an appointment at 9am, I want to send an email to the appointment subject to remind them.This worked properly for a couple of years, but suddenly the emails would go out all different times. I investigated this, and found that Airtable moving appointments into the view at inconsistent times were likely the culprit. That said, I want to build something better, that doesn't

Hi.  It's my first day. I'm trying to create a maintenance log for my laundromat. I created a base with the following tables: Washers, Dryers, Maintenance Requests.  The Maintenance Request table is populated by a form I created for my staff to request maintenance. On it I created a field called 'Machine Type' where you select washer or dryer. The next field is 'Machine ID' and if you select washer under 'Machine Type' I'd like it to give a drop down menu showing the Machine ID's from the 'Washers' table and if you select 'Dryer' I'd like it to pull the machine ID's from the 'Dryers' table.  Can I do this?

I would like to set up an automation so that every Monday at 7am, any checks under my "completed this week" checkbox field will reset and be unchecked again. How can I do this? I have tried a few things and continue to get input errors. Step-by-step instructions (As I am a beginner!) would be very helpful. Thank you SO much!   

I am trying to learn to use automations to update 2 summary tables so I do not have to keep copying and pasting every time I update a table.Table for new record:  Donations.  Summary Table: Donation Totals Yearly Summary Report.The two table are linked by the Donation Date primary field in the Donations table. The summary table linked field is called Donation Table.Let me summarize what I think I need to do to accomplish this. I need to create a trigger that says When a Record is Created in the Donations table. This tests fine.Then when I create that record in the donations table I need to have an action happen. I have chosen the Update Record in the action. That action is to update the Donation Totals Yearly Summary Report table/Donation Table field with the contents of the Donation Date field in the Donations table. To do that I need to choose the Update record choice in the Action type field of the automations screen. Then choose the Table in the configuration section

Just yesterday my automation set up to send a text out through Twilio stopped finding the phone number and putting it in the TO field (see image).Here is what I have already tried:I verified that the user had a number in the field of the failed automation. I made a new field that added the Country code to the phone number and selected that field value (at least I think since I didn't see the "Value" image appear where the last one was.I don't know what else to try. Suggestion please!Thank you

Hi,I am trying to figure out a way to copy data from one record to another in the same table. In the example Ordrenummer primær should be the key and I want Navn and Mail from the record with values to be copied to other records with the same value in Ordrenummer primær.Thanks for your help./Michael   

Hi all,Firstly, apologies if this has been asked / answered before, I had a search through and couldn't find it.I'd like to import a number from an external website and automatically update it when it changes.  Also would I need their permission for this?The website is transfermarkt.com it gives an estimated market value for individual football / soccer players.  I have a database of players, and I'd like the estimated value for each one in a column.Is this possible?Many thanks in advance Barry

Hey all,I recently needed to switch an email automation from "Send email" to "Outlook email," to fix a spam filter problem. Previously, when it was being sent as "Send email," a link at the bottom of the email led all recipients to the record detail view of the submitted record on a particular interface - even though interface links are not currently insertable, and I had to assemble the link myself, it still worked fine.They look like this in the Automation message body, where the parenthetical is the inserted dynamic record ID:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/(AirtableRecordID) But now, with the Outlook email automation, the links are broken. Something in the chain is adding two BOM bytes into the link, so it goes to this link instead:https://airtable.com/appxxxxxxxxx/pagxxxxxxxxx/%uFEFF%uFEFFAirtableRecordID Is there a fix for this, or something I'm missing? The only other thing to note is my org uses urldefense, which wrapped the links when the automations were s

I have created a fillout for a registration form. I have a table of people I am inviting, and would like add the fillout button to an email so that most information is pre-filled, and then the registration info updates in the existing line in the table.Please see below - the token is not working - either inserting a formula field or using the button field in the database. Can you help me correct this please to add into my automated email?<a href="(token)" style="background-color: #4CAF50; color: white; padding: 10px 20px; text-align: center; text-decoration: none; display: inline-block; border-radius: 5px;"> Register Here </a> 

I tried to create an automation within Airtable's automations in a trigger that matches a condition,and the action to update a field in a record, which is linked to the trigger's record, but I get an answer that the record of the linked recordis not foundWhat did I do wrong?Attaching a photo.https://airtable.com/invite/l?inviteId=inv93POmHoU5Kla4z&inviteToken=6e1aac633bc71d476a2130dac08e0ce26f3343359e4eae2d6536f033b082b60d&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi All!I have about 10k records in my airtable base, and each have a specific link to a webpage that I regularly check for certain data.  I would love to be able to scrape those pages for the info needed and automatically put it into AT.  Is this possible?  I assume I will have to run a script of some sort, but don't know exactly how to go about that. We are currently updating the 10k records manually, and using some sort of AI would save SO much time!TIA!

I'm sure there is a way to do this, I just can't think of the way the write the "logic" for it in automations... Hopefully someone can help me understand 🙂 My rows have a date as the primary field. I have a long text field columns called "Notes for next training" and "Notes from last training". When I create a new row (new date), I'd like the text from "next training" of the most recent date (in the past) to be copy/pasted/imported into the "last training" column in the new entry.I did it manually for this screenshot, just to illustrate what I would like to happen automatically. 

I cannot use the " Run Script " function under the Automation Tab, even when the team's plan is activated. It's asking me to upgrade to a Business Plan. Please help

I am trying to create an automation that updates a record when certain conditions are met:Let's say I am evaluating my retail inventory and want to identify inventory boxes requiring certain follow up tasks: I created a Box Flags field to aggregate a few different record fields into 2 flags: boxes that need to be replaced, and boxes that need their contents separated. I have created an automation to update records for the first flag, but am struggling with the conditions for the second. I only want the "separate contents" flag on boxes with more than one field value. "Has any of" retrieves all boxes, "has all of" requires a tedious number of conditions to capture every combo of values, "is exactly" and "is/is not empty" don't apply. In other apps I've worked in, I could write a condition like Box Contents contains A,B,C,D,E AND (Box Contents is not equal to A OR Box Contents is not equal to B OR...) to filter out the single value records, but I can't seem to wrangle thes

Hello,So I basically have a table for candidates and a table for job adverts. I have a make.com automation set up that when a candidate applies to one of my job adverts it automatically feeds them into my candidates airtable and will also create a new record in my job advert table if one doesn't already exist (first person who applies for the job). I am running this for 3 different offices each with its own make.com scenario to distinguish which office they are applying for. It will automatically feed the candidate into the candidate table and adds the correct office field that it is linked to.Where I am having the issue is I also want it to update the job advert office field automatically. It seems that it cannot be done within a make.com module. I was wondering how I can set up an automation so that when a job record is created it will find the candidates record that triggered the creation of that job advert and grab the office that candidate is linked to and automatically feed

Im new to airtable and make.com so forgive me if this is a elementary question...I setup an automation that has a Stripe webhook to monitor for payments and then update a record when there is a payment but I cant get it to update the record. It can find the record no problem but when it gets to the update module it gives me an error.Bellow is the log and setup of the update module. What am I doing wrong?Thanks in advance!   

I need to automatically trigger a script that makes use of `Field.updateOptionsAsync`to add options to my single-select field. I first wrote this as an automation script so I could easily set up a trigger, but saw this API is only allowed in scripting extensions. So then, I wrote it as a script extension and couldn't figure out how to automatically trigger it to run. So then I found out about block-cli and released the extension to my base because I misunderstood that `block run --remote` does not run the extension remotely, leaving me with 2 extensions that do the exact same thing. So:Is it possible to run extensions remotely / trigger them to run automatically? How so if it is?Can we get the ability to use `updateOptionsAsync` in an automation script?Is there yet another way to achieve what I am trying to do? 

Hi Airtable Community...I'm new here!I two tables:- Table One:  with user name, email, phone, and an attachment (file pdf).- Table Two:  with new client information once a form is submitted which will create a new record (name, email, organization, and phone)I want to send an automated when a new record is created in Table two and to attach a file from Table One (column is called attachment)When I click on the + to Add an attachment: Base Structure --> I can only insert date and time value, which seems to not be correct.Can anyone assist. If this was posted before - I apologize, and point me in the correct direction.Desert1211

Hello. I’m working on importing record or data from Airtable to Salesforce. I created a custom automation in Airtable that runs when the button is pressed. However, the data is not being updated in Salesforce as expected for each table.

Hello!I would like to create a field that shows when (date and time) a record (task) has been marked as "Done". Here is what I have so far: How do I create a formula and/or automation to do this? TIA!

I'm trying to create an automation with these conditions:First and last name matchOriginal entry with matching name was created within 90 days agoWhen I try to use when a record matches conditions trigger, it does not let me select a dynamic variable so I'm kind of lost on how to move forward with this so any help would be appreciated.

Hi , allI have a problem that I can't solve, I have a script that updates the prices and countries of my products based on a code for exampleThe problem is the following if two products have the same code then it modifies both. To solve this I thought in the following way each product is linked to a unique supplier so I just need to retrieve all the suppliers displayed to my user so that he chooses the right one and I would only update the products from this supplier while always comparing if the code is the same.I manage to retrieve the suppliers but I cannot update the products afterwardsWould anyone have an idea?

Hello! I work for a manufacturer that deals with many SKUs of products. We have a form to let designers know when new products are being ordered so they can check and make sure if any packaging needs to be updated. When we place an order, we typically order multiple SKUs at a time. Currently the form has a field where the submitter has to place the SKU numbers separated by a comma (10001, 10002, 10003, etc). Ideally I would love for the data to separate the single record into multiple records by those SKU numbers. So 10001 would have its own record, 10002 the same, so on and so forth. All of the other information on the form would be the same in the record, it would just be easier for us to track and update everything if they records were separated. I saw some other posts on here doing similar things, but not exactly what I'm looking for. Also open to doing this a completely different way if that would be easier. I'm guessing this would take some coding to make happen an

I can do so much...but this one just has me stumped. (I have "Business" tier, Zapier, Make, etc. fwiw. I prefer to use Zapier over Make, but will do whatever I need to.)I get an email sent to me each day that has an attachment. It's an XLSX file that has the day's clock-ins on the first tab, and then each employee has a tab after that with each day's hours. I used Zapier to get it to automatically upload into a folder in my Google Drive called "clockins".I want to automatically upload that new file. -When i sync with Google Drive, it just wants to pull in the name of that file, basically. I'd still have to do the actual importing. I want the file (and all the data) to be imported.-I can't alter how the Google Sheet is formatted. Some employees have the same first or last name, so I don't have unique values in any field (and i can't add one, at least before it lands in my Google Drive.)-Ideally, I'd like all of the tabs to be imported. The Google Sheet has them automatically n