Automations

I am trying to set up an automation to change the status of a project from “currently active” to “past” if the date entered in the end date field is before today. Yet when I create a new record with an end date in the future, the automation I’ve currently set up still changes the status to past and I have to manually change it back to currently active. I have turned off the automation for now until I can figure out what’s wrong, but would appreciate help figuring out why it’s not working correctly. Here are my parameters in the attached images. Thanks for any help you can provide! Update: I’ve determined there’s a difference in how the automation responds based on whether I start manually typing in an end date, or whether I use the field’s calendar to click ahead to the date and select it directly. Starting to type anything in the date field automatically makes it assume the date will be in the past, whereas selecting a future date with a click instead doesn’t trigger the au

I have a linked field value in a base that’s populated by an automation - basically it’s copy pasting from a google sheet and important industry values, and I need to map these to our internal values. So I have a value that comes in like “Energy, Chemical, and Utilities”. My linked field is set up so as to not allow lining to multiple fields, and yet when this value comes through instead of being linked to one field my value is suddenly being linked to 3 new fields - Energy - Chemical - and Utilities. I need a simple fix here! I know I can use a substitue formula + a copy paste automation, but that seems like a A LOT for what should be the behaviour I set up for, no linking to multiple fields! If you can suggest a script that I can check out, or an automation, I would rather not have several too many fields to solve this. Thanks!

Hey all, I’ve run into an interesting problem with AirTable. I have an automation script thats finds all records from today and emails those records with the “Render as HTML Grid” option. Some field values are truncated, and I couldn’t find a way to affect the row size or CSS rules that are causing this to happen. For example: For example, there’s a parent <div> that wraps the table enforcing a max-width of 1000px (and overflow-x: auto!) and inside of each <td> element, there’s rules for a max-width of 250px and overflow: hidden. Parent <div> of table: <td> rules:

Hi, I have an automation set up to post in slack when a new record is created. When I test the automation, it posts correctly, but when I set the automation live and manually create a new record it does not post. I updated the automation this morning to use the new Form Submitted feature (which is really what we wanted originally) but the same issue occurs: the testing posts, but it does not work when live and a User submits a form. Any thoughts?

Hello! I’m trying to use Airtable Automation to publish a tweet every time there are new records that match some conditions. It was working well when I was testing it last week until today, when I received a Twitter error. Screenshot of the error: The problem is that I don’t receive any other information. Could you help me discover what is happening? (BTW, first I had a problem when publishing a tweet with an image (it was a correct image but it said incorrect size). But after removing the image from the record I received this other error. Thanks!

Can automations be programed to send to outside emails that are not current users of airtable?

Hi! I’m trying to find a way to automate the creation of timeslots between a start date/time and end date/time. I have an employer using my platform that needs to create x number of slots with y duration on a given day, without having to manually create each timeslots record. This employer doesn’t have direct access to the Airtable base, and I’m trying to find a solution where I don’t have to do it manually for them. I’ve looked through some of the apps and scripts already on the system, but I haven’t found anything useful yet. Any resources or ideas that you think I should look at? Thanks! Sean

I would like to send a link in an email that, when clicked, changes the status of a specific record. Is this possible?

Hi Community! I could use some help Trigger Conditions: When Date Field (“Send Date”) is exact date 6/25/21 PDT. Action Conditions: Send email via Gmail Trigger seems to work fine. I can specify the date but can’t choose the time. Not sure what I’m doing wrong but any help would be greatly appreciated. Thanks in advance!

Hi all! I’m developing a script that triggers when a new row is added to a table (it makes HTTP call to retrieve more data, and add to the missing columns). I’m currently using “When record is created” as a trigger, and it works well in cases where the entire row is added to the table at the same time through other automations, or copy-paste. My problem is with written inputs. So if a user writes the data manually, the script triggers too soon, before all the columns are filled in, thus with only partial inputs to my HTTP call. What’s the best way to overcome this? Intuitive I thought the trigger would work so that when a user is adding the row, it fires only when the focus goes away from the added row. But obviously not. :slightly_smiling_face: Thanks for the help! Cheers, tommi.

I am trying to creat a condition when the context of the table approved only than it can be posted on Softr website? Please help can not find any info on web :pray:t3:

Hi. I’ve been racking my brain for hours with something that was supposed to be simple. I have a tab called “customers” with my customers’ name and phone number. on this tab there are two columns that are the registration and name of the last barber who attended them. The calls are registered in the “Schedules” tab I would like that with each new appointment, the registration and name of the last barber who made the service to be changed. The common key between the two tables is the customer’s phone number. Can someone help me ?

Help please! I created a ‘Create Record’ automation with the following trigger: When a record matches conditions in table 1, it creates a record in table 4. (Works Fine) The problem is with the record it CREATES in table 4. It’s doing exactly what I want when it runs the test, but when I create a NEW record in table 1 that matches the conditions (triggering the action of creating the record in table 4), it’s filling in the field in table 4 with ONLY the first letter of the word(s) it’s supposed to be inserting. I cannot figure out what I’m doing wrong :weary: Any help is so appreciated!!!

Hi! I’m trying to set up an automation where when a new record is created in an “Events” table, a script runs that checks whether the event participants are already scheduled for other events at the same time. I know that both @Kamille_Parks and @Jeremy_Oglesby have created scripts that fulfill this requirement (great job by the way!), both of which can be used in the Scripts App, but since both of them require inputs and output tables/headings, they don’t play well with scripts in Automations. Has anyone adapted these scripts to work within an Automation? This would be an amazing feature to have, as it could run in the background whenever someone submits a form for a new event. Thanks for the help! Sean

I’m managing a conference registration process, and have a table of registrants gathered by a form which includes a formula field with names something like 02_SAT_COUNT that shows a 1 or 0 depending on whether the registrant selected a particular session in their registration form. This was created using a formula to see if a particular option was selected in a multiselect field, so it is not using linked records. What I need now is a way to send me an alert when the total number of registrations for a particular session reaches the maximum, so that I can remove that option from the registration form, thereby closing that workshop to further registrations. I have a separate table that lists all the sessions being offered, each using a unique code 02_SAT or 03_FRI that is similar to the one used in the name of my registration formula fields such as 02_SAT_COUNT. What I’d love to do is find a way to increment a field in the Sessions table each time a new registration shows a 1

Hi Guys Now I’m setting workflow for my teammate, I would like to know how to set automation on Airtable to send a direct message to Slack for each person when their work is assigned. Thank you so much (❁´◡`❁)

I want to make a tv database for ongoing tv shows. as an example “Loki” tv series it’s first season air will finish 14th july 2021. i added in my base. i want to change the select status to “Finish” if 14th july 2021 day come. is it possible?

form to insert record in view information in tab1 view A, will be carrier over to tab 1 view B (1B) ,(using filter to only have wanted info use airtable automation to create new record in tab 2 view A (2A) up to here no problem, all info will be carrier over but when need to update or change information but cant carrier over. -so i use automation trigger " update the from view 1B", tested no problem action update to 2A, but keep having the problem at here. test → record does not exists. -record id = airtable record id how to solve this problem intend is that using the form it will create a new row information. but when need to edit/update the row info on 1A, or 1B, it will sync over to 2A.

Hi Community, I have a table A, which has 3 fields. Field 1 is Name, Field 2 is Role, Field 3 is Skill-Level. Simulated data for Table A: John, Singer, High Michiel, Pianist, Medium Zule, Guitarist, High Table B has 3 fields. Field 1 is Name, Field 2 is Phone Number, Field 3 is Email Address. Simulated data: John, 12345, john@music.com Zule, 67891, zule@music.com Question: is there a way to ensure that when I add any new record in table A, only new records in table A with Skill-Level = High are automatically added to table B? Having combed through Airtable’s functions, I am sensing that this is not possible without using Zapier or Integromat or some JS code but I hope to avoid these options. Please advise, thank you!

Hi Friends Need some help with automations. I`ve created an automation (Nº1) where it creates a new event in GCAL. The problem is that I am also trying to create another automation (Nº2) where if I change in airtable the date and time of the event it will update the date/time in the GCal event created previously in automation Nº1. The issue is that it keeps me sending me failed Thanks

Is there an approved condition before launching contexts from Airtable to Softr or is there a way to have two tables linked so when the context at the first table is approved it can be automatically added to the second table? I couldn’t find any information online, will be grateful if you can help. Thank you!

Hi all, I think there’s a bug with the Automation tests. I’ve recently started using automation to send emails based on statuses. My understanding is that if the automation is set to OFF and I hit Test, it just verifies whether the email would send or not AND gives me a view of what the email content would look like. However, that didn’t happen today. I created a new automation called “Offer: Coach Match” and it was off. I had one row in my table “COACH MATCHES” that I was testing with and I made a few changes and tested both the trigger and the actions a few times. I wasn’t expecting the emails to fire so was surprised when I went into my Gmail inbox and saw: that I had received 2 emails showing the email had fired (I put myself on Bcc); and the user I was testing with had sent me an email saying “FYI - received 3 emails with the same info.”. Luckily I had given them a heads-up that I was testing otherwise it would have been a little embar

I feel this is super simple and I’m just not seeing something. If someone could put me out of my misery, it would be much appreciated. I want to send slack notifications when someone fills out a form. One of the fields is long text and asks for detailed description. I wanted to only show a preview of that field in the message. I see the “trim” option there but I don’t know how to actually use it! It’s not doing what I assume it should do. I am selecting + > the field (Description) > Continue > trim (insert) and it doesn’t do anything. When I do the exact same with any of the other properties (length, upper case, lower case, etc) it does react the way I would expect. Does anyone know how to do this? :thinking: See it not working here:

Hello, We have a problem regarding Airtable automations. The problem concerns the trigger Google Forms, trigger type “When response arrives”. It doesn’t seem to work for us when the spreadsheet is located in a shared drive. However, it works perfectly fine when the spreadsheet is located in a “personal” drive. What should we do to be able to have the spreadsheet in a shared drive? Or is this not possible?

Hello, I can’t send automatic emails anymore, I get these notifications (as attachments). I don’t know what to do because when I look at my “sent messages” from the Google console, my emails are sent. However, nobody receives them. What should I do? Thank you very much for your help