Automations

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

When I try to use the form submitted automation trigger, none of my forms appear in the dropdown selector. It's very frustrating , because they are published and can enter data normally.What might be causing this?

We have a couple of columns populated with emails and names, the rest of the AirTable base will be empty (I've attached a screenshot). What we'd need is to trigger the workflow in Make based on specific time trigger automation and I just don't know how to tell the workflow to start as the specific trigger time automation in AirTable doesn't allow me to use the recordID field. Would you be able to direct me to a solution if there's any or tell me how you'd accomplish that feat?

Dear Airtable Community,im working on an automization to assign volunteers to specific working shifts according to their preferences. The volunteers can name socalled Besties to work with, so the code has to first assign matching volunteers into Bestie Groups and afterwards assign the whole group to a preferred shift. The code worked until I started "optimizing" the runtime of the code and creating a volunteerMap at the beginning of the code to have it set and not need to map it during the analyzation of the volunteers besties. (Hope that is understandable until here)After implementing my async function refreshVolunteerMap the following error occured:Error: Failed to refresh volunteer map: Request processing is disabled due to earlier failed request at refreshVolunteerMap on line 83 at async main on line 837(I already saw the post regarding a similar issue, but it didnt help me (= add an await before calling function)https://community.airtable.com/t5/development-apis/new-error-in

Hi everyone,I’m working on building a workflow in Airtable to manage workshop details, attendance, and evaluations. I’d love to confirm if the following features are possible within Airtable and get tips on how to set them up:Workshop Details Integration:Each workshop has its own linked records with two tabs: an Attendance Sheet and an Evaluation Sheet.In the Attendance and Evaluation tabs, I want a dropdown column labeled "Workshop" where I can select the specific workshop. Selecting a workshop here should link it directly to its associated records.Participant Records:When I click on a participant's record, I want to see:The workshops they’ve attended.Their survey responses for each workshop, automatically populated into the corresponding questions in the Evaluation Sheet tab.Access Control for Team Members:I need two team members to only access their individual inputs.My account should have full access to merge all their inputs into a consolidated view while tagging each input with t

Is it possible to update a value in automations to update an entire table uniformly?For now I'm doing it in a script but it can run on 50 rows each time, so I made a loop but it takes over a minute each time

So I'm trying to import images in an attachment field.  I tried connected my Dropbox account but unfortunately it's not showing all the folders in my Dropbox account.  It's only showing the first folder.  Is there something I'm missing with permissions maybe? 

Emails sent via automations replace underscores with nothing, thereby corrupting the URLs, and other values, that contain underscores. I've read the many posts about this and still can't figure out the syntax to use to make this happen.Here's an example screenshot:What syntax would I use to ensure the Asset Location (URL) field values will retain any underscores?I've tried single-quotes with parentheses, and/or brackets but am not having success.Thoughts?   

I have read previous posts on this topic (syncing with Google Sheets) but a lot of these posts are from 2019, 2020 or even earlier. I would like to sync up my Google Sheets data with Airtable so my tables in Airtable update as Google Sheets updates. I am unable to use zzzBot because of privacy restrictions (?) and a lot of changes have been made to different integrations. Does anyone know whether it is possible to sync Google Sheets data with Airtable?

Hey guys, I am trying to automate my content posting through AirTable and Make and everything works fine until Instagram has to access the video file/URL from AirTable, then it fails and gives me errors. It's because my table is not publicly accessible so how can I change that so Instagram can access the Video URL without being blocked?

Hello,i would like to create an Automatisation that send an Outlook Shedule link to an Customer to his Email.1. Customer types his Email in a Form (done)2. Customer chose a Date Slot over Form (done)3. Automatisation creates a Outlok Shedule (Date he chosed) link and send it to Customers Email (open)Im familiar with many Automatiosations, but this one is a Riddle for me. Anyone who created somethin similar and can please helm me? Thanks!!

Hello all, anybody seen the following in Automations:I can't find any documentation on this.Any ideas what the use case for this data being available might be?

Hello,I am celebrating my automation is now working, however, whenever it seems that Airtable is sending me an automatic email titled, "Something went wrong with an automation...". I've pasted the email and error screen below.Can you help me understand if there's actually a problem, and how I can get the emails to stop?TIA,ML   

Good morning.We are experiencing issues with email sending from automations. We have detected a change in behavior with email dispatches when several emails are entered in the "TO", "CC", "BCC" fields.When the action is triggered, it appears that Airtable sends multiple independent emails instead of a single email. For example: If "Email_1" is entered in "TO" and "Email_2" in "BCC", then "Email_1" receives the message, but "Email_2" does not receive a copy. Instead, "Email_2" receives a direct email, as if "Email_2" had been set up as "TO".The expected behavior would be: "Email_2" receives the same message that was sent to "Email_1".We have observed this change in behavior today, 2024-03-07.##### Message edited to detail the case ####.To detail our case I have conducted a simple test, easy to replicate; creating a basic automation where I have only added a time-based trigger and the action Send an email, which I tested to trigger the action. I have set up the email sendi

Hi All Through automations you can: Create an outlook meeting Update an outlook meeting But I can’t find a way to cancel a meeting? Is it impossible? Thanks in advance Matt

In my account, on both the free and paid workspaces, I have the option to update a record's date field with "A specific time" -> "Actual Run Time" in an Automation.  However, in a clients account, they only see When a Record is created (or Form is submitted, or conditions are met, etc., for the trigger) and Base Structure. They do not have the option for "A specific time."Is this something that's only just now being rolled out and not every account has it yet? Like I said, I can see it in both paid and free workspaces that I have, so I don't understand why they wouldn't see the same option for their Automation to update a date field with the date/time that the automation is run. 

Hello,I'm looking for help on Airtable Automations. I'm trying to Find a record to update based on Table:Sessions field matching Table:SignUps field. Both fields are "formula" fields that make a text number because the original Sessions field is a linked record, and the original SignUps field is a Primary Key.I don't know why, but I keep getting the error message below saying, "No valid nested options". It won't let me pick *either* the text field or the original Primary Key for Finding the match, and I have no idea why.I already went through this post explaining how both of the "Find" fields have to be congruent... but as far as I can tell, mine *are* congruent, but I'm still getting the error. How can I get this automation to work?Additional context below. TIA,ML