Automations

Hello - For the past few weeks, my Automation emails are being received with a square placeholder in place where the grid should be (see screenshot). The new Preview feature displays the email correctly, but what I receive is different. Just checking if anyone else has this issue, and how you fixed it. I have deleted and recreated the grid, but it did not work. Thank you … Appologies if this was already posted - I didn’t see anything when I searched.

Hi! I am wondering if a slack notification can tag a specific person it is assigned to them. I.e. I want the slack automation that I’ve set up to tag <@WMLBVULSJ> when Assigned To field is “Ashley”, or tag a different account when Assigned To field is their name. Has anyone successfuly done this and/or have any tips?! Thank you!

I have a connection between Airtable and Webflow (using Nobull), the automation is working fine except for the attachment. the file does not sync with webflow CMS. Please I need urgent help

Hi all, I am new to the community and hope my English will allow you understand my question: I am using airtable to do invoices. I have a table for the header (customer choice, project choice, etc.) and a table for the details of the invoie, ie all the lines. Each line is linked to the invoice by the invoice number. Sometimes my team do long and not easy invoices (in the construction industry), and on return the client just wants some modifications. I am trying to do a script that duplicates the header and lines, so that I can keep my invoice history. I can’t use the built in “Create records” action to create the duplicate “line” records, since the number of lines linked to any particular header can vary. My problem is that when I duplicate the header (with an automation “create record” with trigger on the record I want to duplicate), the linked field is also duplicated but the lines themselves are not duplicated. This way, If I change something o

Hi, I built an automation that uses the “when sheets row is created” trigger. Until about 9:30 am today (8/4), the automation was working as intended without prompting from a human. However, now the automation does not automatically trigger when a new row is created with the same format that was working previously. I’ve tested each individual step including the trigger which, when tested, returns the values of the newest row. I’m pretty sure that the issue is that the trigger is not checking the assigned sheet automatically, though I am not 100% sure. Does anybody have ideas for something to fix the issue? Any help would be very appreciated.

I’m a little bit lost on this one and hoping for some help from the community. I’ve been using this automation without issue for months, but recently something changed and now it’s throwing me an error. (I’m guessing something updated on Airtables end). I have an automation which runs whenever a customers record is updated (which includes a rollup field of their orders). I then run a script to take the customers linked order records and sort them, so that newest orders show at the top. Up until this point, everything is working as expected, and the output of the script is a sorted list of the linked record ‘names’ (which in this case are Order ID’s, like 12345). The next step, ‘Update a record’ is where I’m now getting the error everytime this automation runs. It should (as before) take the output of the script and update the linked ‘Orders’ field in the customer record that changed, triggering the automation. That’s all it does, not changing any other fields.

Hey everyone! Today we had an issue where a few of our automations started failing due to all of our “Link to _” fields breaking. We have been using these fields as a main link between tables, and they have all started failing with the same error: Field “_ ID” cannot accept the provided value: Cannot modify a computed field. Does anybody have any idea what might have happened? This all started happening around 1:30pm EDT today, and it is not just one table, but at least 4 or 5 tables. Any insight into what might have happened would be very much appreciated. It is a very big workflow issue for our company as this drives a lot of what we work on a daily basis. Thank you!

Hi! Do you know if there is a limit for automate Slack or Email messages?

I’ve set up automations where I receive an email everytime a new record enters a base. They were working totally fine but for some reason I stopped receiving emails. I checked my spam and nothing. I tried changing the email address and it seems to be working for a different email address but not for my normal work email. Any idea on how I can resolve this?

Hi everyone, Has anyone found a way to automatically update MULTIPLE records depending on updates or conditions changing for those records in another field? Thanks! Ben

Hi there, I’m using Airtables automation to output an email report for managers. You can’t control the order of fields when outputted at a HTML list or grid and my report doesn’t make sense if I just list the fields in the order they were added to Airtable… …so I’ve used a formula field to concatenate the fields in the order I want, taking the opportunity to give better labels for the reader too: CONCATENATE("Station: " & {Station (from CycleCode) (from CycleEvent)} & "\n" & "Module: " & {Module (from CycleCode) (from CycleEvent)} & ", " & {Project (from CycleCode) (from CycleEvent)} & "\n" & "Started at: " & RIGHT(CycleEvent,5) & ", duration: " & DowntimeDuration & " mins" & "\n" & "Reason(s): " & Reasons & "\n" & "Notes:" & {Correcti

I am getting the following URL appended to my google sheet using automation after submitting a web form. https://cdn.filestackcontent.com/MhkjUkhvQsyBzNgk6S0Z However, if I perform a run test on the automatic, I am able to get the correct attachment URL append to my google sheet like this. No idea what went wrong here.

I have a webhook that is meant to create new records on a table. Some records have new values for a singleSelect type field. I tried to create a function (code bellow) to provision new options but it fails with “Error: Cannot update field config from scripting automation”. Without the field my await table.updateRecordAsync also fails if I pass text to this singleSelect field. Is there any way to provision new values on a option field, to mimic the behavior of the UX where if you paste a new value it is provisioned automatically? if not, a feature request would be the passing of an option to the value of updateRecordAsync such like “create non existing values” or something. async function updateIfNeeded(table,field,choiceName) { const selectField = table.getField(field); if (!selectField.options.choices.find((choice) => choice.name == choiceName)) { await selectField.updateOptionsAsync({ ch

Is there a way to trigger an automation when a record is removed from a view? I know there is one from when a record enter a view, but I need the opposite and my random tests have not been working!

Hello, I have a problem with automation trigger on update. I have configured update trigger on 3 fields: features, nextfeature, scripts. But when i’m doing an update by API of this table in this way, trigger is firing. await updateRecord(data.id, ‘Accounts’, { “last_check_status”: date, “status”: ‘active’, }); I’m don’t update the field that i configured to listen. Is there any mistake on my side or it’s airtable’s error?

Hello all – I’m working on an airtable base which will run an application process for organizations. I have one table called “Organizations” which includes info about organizations (ones that have applied and ones that haven’t) and another table called “Applications” which feeds from a Typeform which applicants fill out. In simple terms here’s what I’d like to happen…check for matches, update matched records, create new record if there isn’t a match. Here’s what I want in more detail: Script runs and checks for matches between the Organization table and the Applications table. A match is a record in the Organization table with the same name as in the Application table. For records that match across both tables I’d like to update the Organization table to reflect that the matched organization has an application in the Applications table. (Can be a check box or linked record, doesn’t really matter) For records that don’t match I’d li

Hi Is it possible to edit the fields selected fields in the digest (ie add/remove) when creating an HTML Grid. All I seem to be able to do is start a new one which is a pain if I want to add extra fields. Also, as a seperate question, is it possible to copy/paste parts of one automation to another? Thanks in advance

Hi there We have a pro account and I have a simple approval for set up that when someone submits me an idea on a form, they can add their email address if they would like an emailed update as to the approval status of that idea. But, when I put that e-mail address in the “To” Field I just keep getting told the e-mail field is blank - despite me having made sure there are no blank fields on the table. Is this fixable or can the automation only send to a set email address and not one from the table itself? As stated, we have a pro account so it should not be the e-mail address itself that is causing the problem. Thanks Shaun

I have been digging around the forums for an answer to this, and wondering if someone can help me with a creative solution here or point me to a similar problem. I am trying to set out a work flow that is automated, and checked off when a new “Student Note” is submitted” So here is the flow: If “Services” = “1 qEEG”, the flow should be as follows: qEEG 1 Report1 ROF1 Finished If “services” = Pre & Post” or “4 Part” qEEG 1 Report1 ROF1 qEEG 2 Report2 ROF2 Finished So for example, if someone submits a “Student Note” as “qEEG 1”, I want the status to read “Report 1”. But if there is also a note that says “qEEG 2”, I want that to read “Report 2”. I am wondering if the solution lies in a Gantt chart (which is new to me) or if I should play with nested If statements, or both. Here is the base:

I’m working on building an automation in Airtable that alerts a specific Teams chat member that something has occurred. I’ve found MS documentation about using the tag to format a mention for a bot, but I can’t seem to get the mention to actually work in the automated message. Every combination I try just ends up as a plain text representation of what I put between the tag, but I know the automation can read tags properly because it’s properly formatting a hyperlink I’ve added to the message using <a href " "> I’ve tried (with and without the @ symbols included): <at>@ First Last</at> <at>@First Last</at> <at>@FirstLast</at> <at>@ FirstLast</at> <at>@emailaddress@domain.com</at> …and probably some other combinations of email address, the person’s name, and the @ symbol. Any insights would be super valuable - thank y

Hi We have an Automation that sends a reminder email when a record enters a view which is done on a date basis. Is it possible to get these to come in at a specific time, say 10.00, rather than at 01.44 (we are based in the UK). As they get lost in other overnight emails when people come into work. So idealy the automation would check at a specifc time. Thanks in advance.

Using the API, I create a record in a table with 6 files. Once created, AIRTABLE deletes one of the files. All files in ‘dxf’ format

Hello all, I found the “Create child linked records” script and it does exactly what I need to do, but I want to trigger it from within an automation, and instead of entering the number of child records, pull that information in from the input.config() from the trigger of the automation. I have a parent table called “ListInfo” and a child table called “List”. The primary key of the of the parent table is a field called “ListName”. The child table has a linked field also called “ListName”. I would like this automation to create the “ListSize” number of child records in the child table each time a record in the parent table is created and meets the triggering conditions of the automation (the “ListName” is not empty, the “ListSize” is not empty and the record was created today) . My input variables for the automation are “parentRecord”

Is there any way to create an automation or something that would allow me to push a button in AirTable and it would change the content /value of another field? Example: Field 1 - Record title. Field 2 - Button called. e.g. “Reset Date” (button field) - this button would initiate change in Field 3 Field 3 - Date field (with a manually selected date) - This field date will be changed to “Now()” I want to refresh the date in Field 3 to “now”. But I want the Field 3 to remain a static field with manually selected date. I want to update the date manually (without having to use the calendar widget in the date field) Is there a way t create a button to trigger that? I looked at Batch Update app and Automations, none of which seem to be able to be triggered with a Button. I see scripts as an option for Buttons. Is script the only way to get what I am looking for? Last option is Integromat or course and they have the mobile app which can

Hi, Is there a way to automate a Slack or Email message based on criteria in multiple cells? I work with several clients and want to send automated messages to our team if it has been more than 5 days since the last point of contact. Ideally the body of the email would contain the name of the client and the date of the last point of contact, as follows: Client A 21-07-2021 Client B 20-07-2021 Client C 19-07-2021 Thanks!