Automations

Does Airtable still not have the ability to keep data when updating a record? For example, when using automation, if the form field is left blank and is submitted it wipes data from the record that is being updated. I have heard you can do this with scrip, but I can’t write the script and I am on a free plan.

Hi, I’ve been playing around with Airtable and Integromat via Webhooks, and I was wondering if there was a way for two Airtable bases to communicate via webhook and scripts. Here’s the use case: A webhook trigger is set up in Base 1 in an automation. A record is created in Base 2. This triggers an automation to run a script, which posts to the webhook URL from the trigger in Base 1. The automation in Base 1 is triggered by the incoming webhook, and updates a corresponding record. I’ve used Integromat to trigger webhooks via automation scripts using the following code, but unfortunately it gives me an error when I try the same thing with an AT webhook url: let data = input.config(); let response = await fetch(`https://hook.integromat.com/******************************** ?id=${data.ID} &email=${data.Email} `); console.log(await response.text()); I’d appreciate any help or pointers on updating the script to work. I know that @Justin_Barrett, you’ve posted about this in a few topi

Hello. I am trying to configure a simple automation to add a row to an existing Google sheet when a new record is added to my Airtable base. I set up the trigger and tested, it works fine. I set up the action and tested, it also works fine and added the next line in the Google sheet. Then when I turn on the automation, and add a record in my AT, nothing happens. I am first only trying to sync one column to get it working before I add the rest. What could it be? Thanks

Hi, I’m doing an “Add New Record” automation. The new record needs a number in it’s Qty field from the QtyUsed field in the originating table. Both fields are decimal to 1.000 precision BUT the new record ends up with 1.000 (that’s one) from 10.000 (that’s ten) and 0.000 from 0.025 Other fields are added correctly Any clues please - see image attached

Hi! I’m trying to create an automation with “when a record is updated” to send an e-mail every time a new file is uploaded (or updated). We work with other partners who have access to the same base, the idea is when I update any of the files they get an e-mail to be aware. But the trigger is sending many e-mails at the same time! If I upload a file, they send the same e-mail 3 times (sometimes even 4 times)… I don’t know what is happening… If someone can help me!

Hello everybody : ) Im facing an issue with my gmail automation. Here’s how it looks like : Trigger : Record enter a view (i check a checkbox) Action : Send email with attachment of my invoice My invoice is generated automatically with zapier, zapier detects a record, creates a document from template with google docs, then upload the document (invoice) in PDF format (on airtable record). When i try my airtable automation, the PDF file attached to the mail looks like this. I’d like to point out that my automation doesn’t start before or at the same time as the pdf file is uploaded. Could this be an issue with google doc ? Or directly with airtable ? Can someone help me get through this :thinking:

I’m new to airtable. How can I use the Rest AIP with python to upload a pdf file? To my understanding, I need some sort of link for the upload. What do I have to look out for when programming the automation?

Hi there! I have an automation Where ‘Send Date’ is ‘Today’. It does not have a time field and currently sends at middnight. If it did have a Time Field, would it send at the time that is in that field, or would it still default to Midnight? I saw this solution, but I’m curious if adding a time resolves this.

Hi, I’m a new user here and trying to create a basic order creation and tracking system. I have a field called Clients and another called client orders as attached above. Basically every time a user enters client name in the order tracking form, I need to generate a new order id in the format of. CUSTOMERNAME/1 and so the next time his name is added on the client order list it generates CUSTOMERNAME/2. I created a field called Latest order Number in the Clients table to act as a counter. I was trying to figure out how to increment the counter corresponding to that client when that client name is selected in the Client Order page. I tried the automate feature on trigger, but it wont allow me to update a record in another table or apply any math formula on it. Is this possible to through a script? Appreciate any help on how to do this. Thanks.

I have 2 bases, one collects data from a form (Form DB) and one that I’d like to use as a master client database (Client DB) for individual companies we do business with. Since the form may be filled out multiple times by one company I’m trying to use an automation to review the Client DB when a form is submitted and if the company is not already there, to add it. Unfortunately companies are being added to the Client DB even though they are already on that list. The following is my set up. Are my conditions wrong? Is my understanding of how the sequence works incorrect? Trigger Type: When a form is submitted Table: Form DB Form: Reg Form Find Records Table: Client DB Find records based on: Condition Conditions *Where > Client Name > Is Not > Client Name (Step 1: Trigger) Create Record Table: Client DB Any help on why this might be creating the duplicates is appreciated.

Hello, I’m stuck - I would like to update all records in one field (one row) at once. I’m sure that must be really easy, but somehow I can’t find a way to do it. Thank you for your support

Despite having created a formula field to format my date, it is still sending this format to slack in automation message: 2021-07-31T10:00:00.000Z (which you can see in the screenshot is still the only selectable property in the automation wizard. The date format in my formula field displays correctly like Thursday, November 19, 2020 3:00 PM. What am I missing? My formula is configured as DATETIME_FORMAT(Start, ‘LLLL’)

Hello there Airtable experts :wave:t3: So the context for this use case is the following: There is a form on another app where an order is submitted and sent to a record in airtable. This form captures basic client stuff + plus the products which are inputed as # item numbers separated by comas in one cell. (1234, 2345, 1294) → What I want to do is to create múltiple records (one for each item) on another table. 1234 provider status 2344 provider status 1294 provider status Im guessing it would be a scripting solution, has anyone done something similar?

Hi, I’m trying to use an automated Update Record step to add a new linked record into an existing list of linked records. Unfortunately I’m finding that when the automation runs, it simply overwrites the field with the new record rather than adding the new record into the existing list. Is there some way for the automated Update Record step to append a record into an existing collection of linked records? Thanks very much.

Good Morning Everyone - I am trying to set up an automation with Slack but I cannot find out if my desired scenario is possible. I run an Artist Management company and what I want to do is when an offer comes in for one of my artists to automatically send the details of that offer entered into Airtable to the artists private slack channel. I know I can specify the artist channel in the slack automation but then I am restricted to that artist and that would mean setting up 150+ different automations to account for all artists. Is there a way for me to build the automation so that Airtable finds the private channel of the specific artist from the information in Airtable and then send it to that private channel? This would result in only 1 automation compared to 150+. Hopefully that all makes sense. Thank you!

Hi, I have followed How to create email digests with automations – Airtable Support and all works fine except, how do I prevent the email going when no records are found i.e. the email should only go when the action in step 2 (Find records) has found records?

Hello, I’m trying to have an automation with a find and replace step inside it. I’m just trying to fix a bug with connected fields when they have a coma so I need to remove the commas and copy paste into another field. And I can’t find a simple automated find and replace script (or write JS)? Is there a way to use a formula in the automations? For now I have a workaround where I have a formula field and then I copy paste that formula field to a connected field - but would love to just merge that into one process! Thanks

Hi, I’m trying to update a filed in Airtable that is a linked Field and allows multi record links. I’m using Integromat to try and do this but not sure how to format the text to update the record. The field contains names linked to a Participant table. I’ve tried passing with comma separated values but I think it needs to passed as an array. How should I format the names to register as individual records? Hope that makes sense Cheers

Hello, I am new to Airtable. I run a storage facility and am trying to use the product to automatically update availability status when an intake form is submitted by a new customer. So ideally they would fill out the form, include their unit number on the form, and then an automation would change the availability status for that unit to Occupied in the table. However, I’m not sure how to use the same form for multiple units/records or if it is possible. I’m wondering if I should create a unique form for each unit but that seems like a lot of work and may become hectic. Do you have any suggestions? Thank you.

Hello there, I have been trying to send all records by email on the scheduled date. This automation works fine, but I want to send a nice grouped view (grouped by 1 field). Any idea how can this be done? What I want to send >> what is sends right now >> PS: I use the free version. Any help would be appreciated.

I have a script I read for our webinar series and I have to update titles, authors, and other information every time that a new webinar takes place. Is there a way to create a document that updates automatically?

Hi everyone, I’m sure this is a common question but I didn’t find a neat solution. We send weekly emails using AT Automation triggered by a schedule. This searches for new project created over the last 7 days and sends an email with the HTML grid view. Occasionally there are no new projects and so it sends the email without any data. Is there a neat solution for this ? Cheers

I am unable to send email when base is closed while on testing automation it sends mail thanks for your help

Hi I have specific mails to be sent to all the records depending on what day it is and it has to go at a Specific Time. Eg If today is Monday, a Mail drafted for Monday should go to all the records exactly at 10 am. On Tuesday, mail drafted for Tuesday to go to all records exactly at say 4 pm. Basically everyday checklist based on which day it is. What did I do? I created a Day Field and added Sun, Mon, Tues… as value. Created separate automation with specific day mail body. Created a Trigger condition if Day Field changes to “Mon”, send a Monday Automation mail body to that particular record. Same way for each day created a Condition and Mail body. Manually, at 10 am for all the Records, I have to change the value of Day field to “Mon” so that it is fired at that time. Next day manually change value to “Tue” at 4 pm. Now, I need a solution to make it really automated. Either everyday at the specified time all the records should get a mailer. Or Automatically change Field values of

Hi, Is it possible to use a variable as a condition on a form, or is there a work around?