Automations

Hi, I’m looking for a solution for creating an automation that changes the status of a new record to “Denied” if a record already exists with the same requestor name but with status “Approved” in the last 30 days. Can someone help me if this is possible?

Hi, I’m trying to create an automation to send a notification to a collaborator at some point in a project. However, whichever automation I create (email, Slack message, comment on a column of my record), the collaborator is not recognised : I select the input from the collaborator field, and it returns an empty field. Does anyone know how to fix this ? Thanks a lot !

I have a single select field for “Schedule” with 3 options: Today Tomorrow Future I’d like to create an automation that runs at a speficied time (midnight) every day that will change any record that has “Tomrrow” in the Schedule single select field to “Today”. I’ve been trying to do a trigger of “At scheduled time” and can set it for midnight — that seems to work fine. But I can’t seem to come up with the action that will change any “Tomorrow” to “Today”. Am I missing something?

Record ID is not being detected by the automation tool. I need to change a status of a record when another record is created. But when I link them together it does not detect the ID and the error says the field is invalid. I have other automations done the same way. I am using “copy” tables so I don’t mess with my current data Flow wanted: The table that is going to be updated is “Control Modulos” When record is created in Cosecha → Change status of linked record to “Disponible” and then When record is created in Paso Modulo → Change status of linked record to “En operacion”

I have two tables: “Widgets”, “Sales”. A Sale record can reference one or more Widgets. When I create a new Sale record, I want the the “sold” field in the corresponding widget record(s) to be toggled. Sounds like this might be an Automation, but I’m new and not sure. Can someone please point me in the right direction? Thanks.

Hi, I have a trigger when a record is updated. Then, I want to find record depending of a dynamic field from the trigger step. When I want to add the field, I can’t “insert” it. I can only insert the first one “airtable record ID”. All other field, there is a ‘continue’ button and nothing afterwards. Do you know why ?

I have to upload a file to Airtable. I don’t quite understand the documentation for file upload. I have this code that is in python that should upload a file to airtable via a link but it gives me a 422 error. How can I fix this? ATBASEID = "****************************" ATTABLENAME = "DEV" AIRTABLE_API_KEY = "*************************" ENDPOINT = "https://api.airtable.com/v0/" + \ ATBASEID + "/" + ATTABLENAME HEADERS2 = {"Authorization": f"Bearer {AIRTABLE_API_KEY}", "Content-Type": "application/json"} data2 = [ { "id": "attqyuWADmKW9DgDG", "size": 26317, "url": "https://www.filepicker.io/api/file/5YTJXioCQG0tYWPw6OPw", "type": "image/jpeg", "filename": "33823_3_xl.jpg", "thumbnails": { "small": { "url": "https://www.filepicker.io/api/file/Dy5gioxaShSUvHX0LgIC", "width": 54, "height": 36 }, "large": {

Hi community! I know this question has been asked before but I’m having trouble sorting linked records. I’ve got a project management app that I need to sort updates, showing the most recent update at the top of field. I’m currently able to do this via a manual Batch Update but I would like to create a script that does this automatically. I found the below script on another thread but it is not working form my base. This was originally posted by @Omer_Frydman and looked very promising. I have a tabled called “Action Plans” that contains projects. I have another table called “Action Plan Updates”, that contains project updates. I have a linked field in the “Action Plans” table that links records to the “Action Plan Updates”. These are currently displayed oldest to newest. The way I would like the script to work is when a new project update is entered to trigger the sort to happen upon submission. I’m very n

Hi guys, I am new here and I need some help regarding Grid-View and Calendar: I have two tables. Table 1 shows Projects which have been booked - every record contains ‘project name’ as a single line text field and ‘project date’ as a date field. Table 2 should show them so I am trying to sync both tables (they stay in one base). I tried to make an automization: sync date field of table one with date field in table two. This works fine. sync project name won’t work because I cannot automize a string with a date field. My question is: how can I sync project name + project date out of table 1 with table 2? If there is a thread for this task I would appreciate if somebody can share it with me. Thanks for your help. Best Philipp

I’m just needing a hand with the Automation Scripting Syntax - I can push it to Console.Log, but just struggling to pull/assign the input values to variables. I’m trying to get local time date stamping into fields, really struggling to get my head around the timezones, when I think I’ve got the problem solved, it’s not. So I figure that if I pull the time of when the script actually executes, surely that will reflect the correct date.

I created a formula column (B) so that it contains a different kind of checklist for each record, depending on the value in another column (A). For example, in column B, each record has either of these two checklists x y z or red blue green Because I want the checklists to appear in rich text format, so that I can easily select a checkbox, I duplicated the formula column (B) to create a new column (dupB) that is long text with rich text enabled. Is there a way to automatically make the checklists in dupB show up as richtext so that I can make selections using a checkmark? I could do this manually but I’d have too many rec

As the subject says, what’s the best way to test client facing automations in my live database? In order to add an automation (that I’ve tested in a dummy database), I’m required to test my automation in my live environment, but I’m VERY concerned I’ll send the test to a client. The automation sends an email to my clients matching the conditions. How can I test this safely while also adding the automation to my live environment?

Hi Everyone, I have 3 tables: Table A - Empty Master table intended to capture all records in Table B and C. Full name, email, and linked fields for Table B and C. Table B - first event. Full names and emails Table C - second event. Full names and emails Objective: When new records and emails are added to Table B and Table C, link and update the emails to Table A (and eventually more tables that require the exact same automation). Because Table C has some people that were in Table B, and some now people, the email updating is required, to either overwrite an email in Table A that came from Table B, or add a new one altogether if the record doesn’t yet exist in Table A. Method: Trigger: When records are added to Table B Action 1: Create and link that record in Table A. I achieve this by simply adding the name of record B into the Table A linked field in

Hi there, I want to update date field by adding some days to it with formula DATEADD when status changed on another field. New value for the field where I want to update like this: DATEADD({ValidDate}, {DaysToAdd}, ‘days’) But when I click to Run Test then always appears test failed message: Test failed: Received invalid inputs. Anybody know how to fix it? Thanks in advance.

Hi Everyone, Apologies for posting what I feel must be a really simple question to these forums, but I’m completely perplexed and thought I’d reach out to see if I was missing something obvious. I’m trying to create an automation that creates an event in Google Calendar and then invites someone to it. Should be fairly straightforward but the ‘Google Calendar: Create Event’ action fails every time. Below is the screenshot of the table I’m using: Broken down, this includes: Summary - CONCATENATE({QA Type}," - ",DATETIME_FORMAT(Date,‘DD/MM/YY’)) Assessor(s)/Mentor - Linked record linking to a table of assessors and their email addresses QA Type - Single select field for a range of quality assurance activities. For now, this automation is only going to apply to those li

Hey! Has anyone successfully created a script that can use a dynamic array to link multiple records together? I can hard code the values but using an array is alluding me. Thanks for the help!

I want to hit an API much like the currency conversion example. However, the example updates all the records in one go. Instead, I would like to fetch the API result for just the one record that was either created or updated. The record ID is available in the input, so that should work fine. But what about the table name? I happen to be partitioning this data into multiple tables (each with the exact same schema). The table ID or name doesn’t appear to be available from the trigger/input. And every example I’ve seen hard-codes the table name in the script. Since the automation is triggered on a record which exists within a table, I believe a reference to the table should be available, but I can’t seem to find it. Is there any way to get the name or ID of the table within which the record was created or updated?

Hi team, I am trying to get webhooks for receive notification on create, update or delete records in airtable table. But not able to get more information. I have below questions regarding webhooks. Are webhooks available in airtable on table operations(create data, update data, delete data etc) If webhooks are available then its free or not? Can we create custom webhooks using javascript library? If webhooks not available then can we create custom webhooks? Thanks

Hello everybody :slightly_smiling_face: I would like to create an gmail automation with a reminder mail in response to a previously send email. My example : Trigger = a checkbox “send invoice” is valid Action 1 = send email with invoice Action 2 = send reminder email in response to the first mail (if i check some checkbox like “reminder mail”) Could this be possible in airtable? Thanks !

Hi, I’m creating an automation which: triggers when a record is updated runs a script, can be as basic as: output.set("hello","world"); sends the output of the script to a Slack channel as message. However, whenever I try to add the output of the script to the Slack message body, I get a popup saying “An error occurred”.

Hello, I have an embedded database of products and each product has a button and form to ask for more details. It’s using and sends an email to a specific account manager and cc to the client. it works well but customers can ask about one product each time. How to select multiple products and ask for them? Each product might have a different account manager - email. How can i achieve that?

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