Automations

Hello, I have 2 tables, clients and tasks. Each task has a linked record field to the client. I want the automation structured so that when Task ABC is Complete, the linked client's stage (stage is a field in the clients table) updates. I am struggling getting the record ID for the linked client record for the subsequent steps. 

Hi, Has anyone been able to figure out how to batch download images from Airtable into a folder with a naming protocol for each image based on information from the same row? Thank you, Diana

I have a BOM for each model we produce in our factory. I want to develope a database that allows us to control de actual stock we have based on the quatity and model of our production. Is it possible to do so without using a script and by introducing only a forms with the quantity and the model procuded? Just to understand my problem, each model uses at least 30 different components, with different quantities.Thank you

I want to preserve the setting from a search on an interface page, this needs to be dynamic, so a view does not work as I don't have access to the setting from within the interface page.Below is an idea of the search, location, age, gender etc... In this case a Filter connected to a grid inside a interface page shared amongst users. Rather than copy and email the link to them it would be great to name it and save it.If I copy the page url for this search the parameters are contained in the URL. I want to be able to save that url into a 'Saved Searches' table that we can refer back to a reload said search. 

My automation has a conditional step that runs if these conditions are met:{Date Assigned GMT} is on or after 10/01/2024 AND{Date Assigned GMT} is on or before 10/31/2024I am located in the Eastern Time Zone. I am aware that automations do everything in GMT.How can I prevent this step from running until it is really 10/01/2024 in Eastern Time? 

Hello guys,I'm trying to build a script to automation fetch the youtube video's transcript to Airtable via API keys or Oauth 2.0 via Make.com. But when i'm trying to retrieve the transcript and fetch the data to Airtable, i cannot do that via API, so I have to create OAuth in Make.com. This is a script i used, but Airtable noticed me an errorconsole.error"Error fetching transcript:"▶{code: 403, message: "The permissions associated with the request are not sufficient to download the caption track. The request might not be properly authorized, or the video order might not have enabled third-party contributions for this caption.", errors: Array(1)}Anyone has experience this issue or resolve it before. Pleases, let me know hownThank you so much

Hello, I am trying to use the “Update Google Doc” automation but I do not understand how to fill the “Content” section with the “Select field” option. I have created a google doc template with fields using the google add-on “Fillable Document”, but when I click on “select field” option in the Airtable automation, I do not see any field to select. Does anyone know how I have to set up my google doc template so that Airtble identifies fields from this file? Thank you Pascal

Hi guys,I currently need a way to convert a single/multiselect into a string that I can push through Make into a dynamic template on Sendgrid.I am bodging it with a SWITCH formula"SWITCH({brand}, "Brand1", "Brand1, etc,etcFirst it feels messy and I bet there is a easier way, and it falls flat when you turn on the option for a user in an interface to add their own input.I would rather keep it in Airtable, so someone in an interface could select a single select option and then edit the output if desired.Make.comI have tried to do this through Make, but I am getting some strange results with it picking it up the single select, able to convert it to a string and even output it on an email, but this only works for the value that was selected during the construction of the make. As soon as it in changed it doesn't work (no errors, just doesn't show up in the dynamic field).This has stumped me! Any advice would be great 

Hello, I've got a Base where each record is a person. I'm trying to create an automation that will share that record as a URL with each person (using their email address in one of the Fields), but not ALL the Fields in the record. I know I could manually create and send Shared Views that had the Fields I wanted, but this is hundreds of people, so I can't do it manually and I'm looking for a way to automate it.

Hi guys, any help here would be great. I am trying to make a list of records automatically send to me every 24h, this list is based on status, all of this works, but my problem is I can't seem to get the list to be clickable?Tried both:[Link Text][List of 'Base record URL']and[Link Text](List of 'Base record URL')Any help to make these clickable would be great  

How can I have an automation (or formula) return only the first record in a manually sorted table or view? I have clients submitting tasks and manually sorting the tasks according to the order in which they would like them completed, and we only work on one task at a time. I'm trying to build an automation that changes the status of the next task ("next" is determined by the manual sort field) to "in progress" when there are no longer any tasks for that client in progress. How can I do this without creating views for every client? 

Hi guys, I current have a button that opens a url that is a Make Web Hook, I was wondering is there anyway for the same button to also update the record.My plan is to open url to send email in sengrid, aswell as update status from Open > Sent. Has anyone done this before? Any assistance would be really helpful Thank you!  

I'm building a project management platform. In my current configuration, there is a table for Projects, and another for Tasks. When a Project is created, an automation runs to add corresponding Tasks. The Project table has a "Status" field, with options for In Progress, On Hold, Canceled, and Done.When a Project status is changed from In Progress to On Hold, I added an automation that also changes the status of the underlying Tasks to On Hold (so the individuals to whom those tasks are assigned now to pause work on them).But how would I create an automation to switch that Task status back to In Progress if the parent Project status is changed back?If I set the trigger to be "when record in Project matches conditions (status = In Progress), it's going to update a lot of tasks that should be updated.Is there a scripting solution for "if a project was On Hold and now is In Progress, change all underlying Tasks statuses that were On Hold to In Progress"?

Hi all,I have a really simple script as part of an automation, that is supposed to open the URL of an interface page item that was created earlier in the same automation.I'm aware there's a button to open a URL in the interface designer, but then i can't have that button run the automation... function NewTab() {            window.open(            "https://google.com_blank");        } There are no errors, but the URL won't open.Any ideas? I've searched posts here but all seem to be related to the scripting dashboard and not scripting within automations.Thank you!

I have a table Formation 1 in Airtable that contains various information, including a field named Status with values such as "refused", "accepted", and "pack". I also have another table, Formation 2, which contains different information and is synchronized with the first table. I would like to set up an automation such that if an email in Formation 1 has a status of "refused", it should be added to Formation 2 with the status set to "pack solo". How can I achieve this?

Hi i recorded a quick loom to explain my goal and problem: https://www.loom.com/share/984f3cc405a54ebb93cac3d861843570Here is the corresponding database:https://airtable.com/invite/l?inviteId=invBQZLlFEVSONEXd&inviteToken=e4487b2eb45a328e2e997098f1a864d581e116c9a89364c5754478aa6e8aed69&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsWhat is the automation please?

Hi all,I've been running into an issue with an automation that I just can't seem to figure out; basically, I have one table which contains a date column (Reachout Tracking), along with a linked field to another table which contains contacts to whom I'm sending an email (Contact List).I'm trying to set up an automation where when I update the Date Sent column, it automatically updates another date column called Date of Last Reachout in the linked table: I know that something in the automation chain here is messed up, but here's the chain I have so far. It doesn't give me errors when testing but it also doesn't achieve the desired results:Any tips for how to successfully link and have this column update automatically would be HUGELY appreciated.Thanks!Patrick 

Hi, i want to read pdfs via the open api and fill the data into predefined tables.Im not so experienced with JS, but with chatGPt I managed to receive already the correct data. Now I get an error that doesn't help me any further. I checked all fields have correct names. The pdf data get correctly extracted.  Now im running in circles, I think the scripts tires to update Column 0 ("Bestellnummer") but shouldn't, I only want to update the fields with "AB". If anyone can help here I would be very happy. peace this is the code:// Retrieve all input variables in a single input.config() calllet { pdfFile, lieferant, recordId } = input.config(); // Destructure to get multiple valuesconsole.log("PDF File Structure at Start: ", JSON.stringify(pdfFile, null, 2));let pdfUrl; // Declare it here to ensure it's accessible outside the block// Check if a PDF exists in the input and is properly structuredif (Array.isArray(pdfFile)) {console.log(`pdfFile length: ${pdfF

Is there a way to use automation to automatically store a document in the newly created data record for every newly created data record

Hello- I’m looking for some help with an automation/formula in airtable.I have a table called Inventory that has all of my products in it. I have a view that contains priority level of what needs to be produced next and the amount of space it takes up during production by product.I have another table with kiln loads (production) that I need to link all of these records to automatically by priority level and not have the kiln space exceed 90% (I have a rollup field that sums the space taken by each product). Essentially, I need the automation to start linking the products to be produced on the first record, once that reaches a max of 90% space, start linking them on the second record, and so on until all of the products to be made on the first table are linked to a kiln load.I’m pretty good at airtable but this one has me scratching my head. Thanks for any help in advance!

Hello!!I have an automation I'm creating where I need it to do a "find record" based on email address. In table A, the email address is a lookup field so I created a formula field titled "email for automation" and simply told the formula to populate the information from the lookup field (as lookup fields cannot be used in the conditional setup of automations). However, when I go to validate my find record, I get "Invalid Input Error"Here are the details.Table A "Bonus Delivery"  Table B: "Webinar Registrants"I'd like the automation to do the following: When a new record is created in Bonus Delivery, find record in Webinar Registrants, and IF FOUND, Update Bonus Delivery Record with a check in the Webinar field (such as the first screenshot shows). Here's my automation:TRIGGER: When record is createdACTION: Find Record in Webinar Registrations Where {Email} contains {Email For Automation} (this is the formula field that populates the lookup record data)But in testing

Hi,I have an automation that looks at a view and adds every record in that view to the email and then sends it at 3pm every day.How do I stop the email from sending if there are no records in that view?

Hello ,I have two tables: "Formation 1" and "Formation 2." In "Formation 1," you have fields such as name, surname, email, status, and phone number. In "Formation 2," you have fields like name, surname, order date, email, title, funding, and coach. The two tables are not linked.You would like to automatically transfer the same information from "Formation 1" to "Formation 2" when the status is "Refused" in "Formation 1." How can you do this using Airtable alone?

I created a form in Fillout to update fields but now when I share the unique URLs with those who want to update their information, it says that they do not have access to this base.  I'm not seeing how I can update settings without giving each person access to the entire base.  Thanks in advance!

I am looping through a list of people in a table and adding them to a multiselect linked field in another. I have found andimplemented the following code to update multiselects without deleting the records existing values.I have found that this only works IF the record contains a value. I get the following error:TypeError: record.getCellValue(...) is nullOnce I push a value into the record manually and then run the script it works great.I need to be able to push the FIRST instance into that field and then also add on top of that.Thanks in advance.// This script only works if there is already a value in People Link. In my loop I might need to updateadd up to 3 people into this record. How can I push the first one in and then run this after?What would my if look like? // table.updateRecordAsync(record, {   'People_Link': [       ...record.getCellValue('People_Link'),       { id: linkID} &n