Automations

Hi, I need some help with an automation I’m running. I’ll start with a quick explainer to my base: One record represents one project. Projects are created in the Project-table and then “transferred”/linked to the Equipment-table. Each project has one/more sensors connected to it and each sensor can only be used at one project at each time. When some conditions are met (basically when a new record is created in Projects), a new record is created in Equipment through the automation. So far so good. Now, if this project is the first one to use Sensor1, I want the automation to end there. But, if this project is not the first one to use Sensor1 (meaning, this sensor is already marked as ‘installed’ for some other project), then that previous project in the Equipment-table should be marked as ‘taken down’ and a small update should be made to the linking record in the Projects-table too. I have, kind of, got this to work with an automation. Howev

This is the code, all variables exist in this but it says can only use await on async functions: fetch(“https://api.onfinance.in/insights”, requestOptions) .then(response => response.text()) .then((result) => { for(let j=0; j<checkedDataIDS.length; j++){ await table.deleteRecordAsync(checkedDataIDS[j]); } console.log("Processed Insights: ", checkedDataIDS); }) .catch(error => console.log(‘error’, error));

In a form, I include 2 fields that customers can attach images or screenshots. When I receive the email notifications of the filled forms, they show the file names of the files that they attached like below. Is there anyway to show the image attachments in the notification emails so I don’t need to log back in to Airtable everytime to see the screenshots they attached? Cheers!

Has anyone tried out the new google calendar automation? I have two tables: timeslots and reservations. For the start and end date of the calendar invite, I use the lookup to get the times from the timeslots table. Unfortunately the automation doesn’t support lookup fields yet so I made a formula instead (it’s just the field name of the lookup). When I test the automation, it fails! It cannot parse the start and end time. Any workarounds to this?

Hi all, I guess some have already asked this but I still don’t understand if it’s possible? ( noob here ) Is there any way ( right now ) to convert a “text” field with timecode information HH:MM:SS:FF to a “duration” field? I want so much to use the “Video Snippets” to jump correctly to a timecode for translation. Any help would be amazing! / Viktor

I have a form set up for Realtors wanting to schedule a showing for a property. I am using the Date field (with time enabled) as the “Start Date and Time” and a DATEADD field that calculates a new Date and Time based on a Duration field. Everything is working correctly in the Airtable spreadsheet. However, if I attempt to automate a trigger to set up the event in Google Calendar, the Date and Time are not correct. It seems that the data is being parsed incorrectly.

I have an Integromat / Make scenario setup to generate google docs from a google doc template using Airtable records. The column type in airtable is long text with rich text enabled so I can include bolding and links. My issue is that the google docs generated include the bold text and links in markdown format instead of displaying as rich text. Is there a way to change the export form from airtable or does anyone know how to have google docs ingest markdown and display as formatted (rich?) text?

Hi, I need to duplicate records, and their dependencies along with them. I cant seem to find a way to do this, either through the interface or via automation, or with an app?

Hi gang, I feel like this must be easier than I think (but I don’t know anything about formulas, just automations, and barely those) but basically I’m trying to create a date field that will constantly update with today’s date. Ideas?

Hey guys, How can I update the ‘link to another record field’ (that has allowed linking to multiple records) via automation? I got to the point where everything works fine until I have multiple records to connect with that “Link to another record” field. It just keeps replacing the previous file, instead of stacking them together. How ti should look But instead it’s basically infinite loop of one record replacing the another one and so on…So I always end up with only one record connected. EDIT: Forgot to say, trigger is a checkbox field.

Hey guys, So, I have two views in a table: In view “Create Load”, I have 3 separate “Link to another record” fields. In view “All loads”, I have “Link to another record” field as well. So, I wanted to make automation, whenever I fill Stops fields from “Create Load” view , those should be automatically filled, through automation, in “Shipper(s) & Receiver(s)” field from “All Loads” field (as it’s shown in previous two pictures). But it seems that doesn’t work as I planed for some reason. My automation is as it follows(tried with ID, names etc.):

Hello community, I’m having a problem with my automation. I would like, when a customer’s membership expires in the next month, the checkbox to tick. Everything was ok until now, but recently it doesn’t work. You can find the screenshots here :point_down: Thanks a lot to everyone who can help me :slightly_smiling_face:

Hey guys, So I have rollup field addresses, and I made a little formula to put “-” in front of every address. But I would like to change hyphen symbol (-) to number - first row number 1, second row no.2 and so on. Current formula in Addresses field is: " - " & ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ’ ; \n \n - ') &"." Is that possible?

Can we do some sort of DOUBLE ACTION (confirmation) system? For example, changing the option from a single entry field to another option would ask you if you really want to change. Thanks! :slightly_smiling_face:

Hi Crew. Thanks so much for all being amazing. Just wondering if anyone knows how to delete the contents of one field in a table? (in a script) Thanks so much Brad

Hi, Is there a way for “run actions” to integrate into a xlsx format of a google sheet instead of a google sheet directly? The interaction only allows google sheet which gets saved as gsheet. But my other app, where i wanted to open the file as a database doesn’t allow g-sheet but only allows xlsx or csv. How can i update the records to a csv/ xlsx file using automation? Is there a way?

We are looking to create a jira ticket for every campaign that is added to the calendar but for some reason we keep getting an error message saying “Received invalid inputs. summary is shorter than the minLength: 1”. Below is how we have set up the automation: Here is the error message we received: When we can get the automation to run, it won’t accept our primary field “campaign name”. When we go into the Jira project, it only shows the date which was noted in the Description section; not the campaig

Hello! I’m trying to make automation where an email is sent to a specific email address whenever a record matches condition. My trigger tests fine, but I can’t set up action because whenever I try to test it tells me the “to field is empty.” Tried with a rollup, lookup fields. Also tried with formulas. Tried arrayjoin formula, but nothing works for me. Main table looks like this. Driver is from other table, and driver’s mail is rollup from other table as well. This is formula I’m using with rollup Even tried with formula field.

Hello! I’m trying to make an automation where an email is sent to a linked record whenever a specific field in a record changes. My trigger tests fine, but I can’t set up an action because whenever I try to test it tells me the “to field is empty.” I have a lookup field to pull the emails for the linked records, and because I read that lookup fields don’t work with automations, I created a formula field that’s pulling in the emails and that’s what I’m trying to reference with my action, but for whatever reason it won’t recognize the email in the field.

I want to somehow find the number of records using a given condition and count. Example: I have 10 records that match the condition, but I only need 5 of them, how can I get only 5.

Hello hello! I’ve got a slight problem with Airtable > Google Calender automation For when an event is created, it creates the events and records the Google Event ID in a column. From here, the airtable record ID is saved in the description of the event. For the automation of updating, Google Calender > Airtable works perfectly, updating all relevant fields within the record. But when I try to do the opposite, Airtable > Google Calender, the automation returns no Google Event ID even though the correct column is selected. Has anyone had this problem, if so know if there’s a way to solve it? See below for images Google Calender > Airtable Airtable > Calender

So a bit of a strange one we are a small charity that links parents of disabled children together and lots of the chat side is completed on whats app one of the things that takes us forever is moderating all of the conversations is there a way for conversations to automatically be stored and saved into whats app? (or any other ideas essentially so we can chat to parents in an instant messaging style way that saves and stores everything happy to use a third-party provider if I can then link it back to airtable) Because its adults we do not need to read every message etc or moderate in that sense but we need to have a way to be able to read every message should it be needed

Hi, Is it possible to see all comments from records, as long text or something like that in a FIELD of that record? Also I would that to be automated, so whenever someone comments something on that record it automatically gets updated in field. and result I would like to get Thanks

Hey there! I am needing some help. I will try to explain this the best way that I can! I am using airtable to track our real estate transactions, and create tasks with due dates based on contract dates. I have one table titled “Transaction Tracking” where I input the property address, client info, contract dates, etc. There are also task due dates that are calculated using a formula based on the contract dates. If the contract dates change, the task due date will automatically change. I have another table titled “Checklist”. I am using Airtable automation to create a record for each task that brings in the associated due date, reference address, and more. My problem is when the contract date changes, and the task due date automatically changes in “Transaction Tracking”, it doesn’t automatically change in my checklist. I created a new automation that does work when a date is changed in “Checklist” (I have the task due date referenced that is pulling in from the “

Hey folks, I’ve got my automation set up to send Outlook Calendar Invites, however when I view the invite it doesn’t render the HTML. Is there a setting I’m missing?