Automations

Many thanks for considering my request.I have a Table A. I chose the "When a record is updated" option in the Automation trigger with multiple field selections, and the Next step is Scriptwriting, In the script, I need to track which field has been updated recently (i.e. which updated field triggers this automation).Eg: Table AField 1 | Field 2 | Field 3 | Field 4These four fields are selected in the "When a record is updated" option of the Automation trigger.If Field 1 has been updated recently, we need to track that Field 1 has been updated recently.If Field 2 is updated recently, we need to track that Field 2 is updated recently.Based on the Field update I have to write logic.

Hi,I have a field with created dates. I would like to be able to create a chart that shows this data, grouping by the month of the created date. However I want the year to be irrelevant. For example, March 2024 and March 2022 to be shown in the same group within the chart.I have created a new field with a formula to show the month only which works perfectly. But then when I create a chart on the interface, they are in alphabetical order and not date order which is not want we want.Can't think of a way to make the chart display the months in date order, or another way for this all to work. Any help is appreciated!

Has anyone noticed changes in how automations are functioning? I used to be able to update linked record fields with record IDs from previous steps, but now they all come out as comma-separated strings. See attached pics:  

Hello community,I'm trying to make use of an automated email that inserts a file name and a google drive url every time a document with a particular naming convention is added to my google drive.  I generate the airtable record using a make.com integration, and then the email fires in the native airtable "Gmail:send email" function.  (I suppose I could try to take this automation to make.com instead, but I'm hoping my use case is simple enough that I can just keep it in airtable for now).The problem I am coming across is that my file names have underscores in them, and my google drive URLs sometimes have characters that seem to cut off the complete URL.What happens when the file name has _filename_ in it, is that airtable removes the underscores and turns filename into italics.  I've tried using the "escape markdown" tag (see here: https://su

Hi, Table A, B, and C. Table B fields are linked with Table A and Table C. I'm trying to run automation. Whenever a new record is added, I will filter the records from Table A and Table C based on the condition. Then I need to create a record in Table B by linking the data from Table A and Table C. Now I can filter the records from Table A and Table C using the Find Records action. but not able to run a nested repeating loop. I can do only one repeating loop.

Hello everyone,I need help with automation in Airtable. I have two tables: "Needle Tasks - General" and "Needle Tasks - Antonov". The goal is to update records in the "Needle Tasks - General" table based on changes made in the "Needle Tasks - Antonov" table.Here's how the automation is set up:Trigger:- When record updated- Table: Needle Tasks - Antonov- Fields: All fieldsActions:1. Find Records:- Table: Needle Tasks - General- Conditions: Where "General - ID + Project" contains "Antonov Tasks ID + Project"- It finds a record in the "Needle Tasks - General" table and returns Airtable record ID recvhvhDDXVsYTmCc

Hi there,I have 2 tables in the same base, one for adding data and one for report.I want to create a new record in the "report" table every time I add a new row to my "data" table with an automation.BUT I don't want to have a duplicate records. I want to check if the text in the "Name" column in my "data" table matches "Name" column in the "report" table.(if they match - do nothing)I try to do it with "Find records" but I don't quite familiar with it.What is the best way to do it?Thank you.

Help me solve this projectits a law firm they have a table with list of questions and a table with list of defendant in airtable they are linked togetherthey want to be selecting a defendant eg caroline then select the questions this defendant is supposed to answer to send out this information we need to create a document with questions and they should be numbered in order

I have two tables in airtable from the same project in JIRA.1 - Named: "Aurora EPICS [NL]".I made an export (.CSV) from JIRA and uploaded it in Airtable.All registers (139) and its columns (288) was uploaded: I want to update these registers from now on, adding new registers when they created in JIRA and update existent registers when they modified in JIRA. Is it possible?  How?2 - Named "Aurora EPICs - [JQL]".I used the extension "Jira Cloud" (by Airtable) and obtained the same 139 registers but with less columns, only 11.Four doubts:A - Can automatize the connection between AirTable and JIRA in the table #1.B - Can I bring more columns to the "Aurora EPICs - [JQL]" table?C - I trying to use Automations in both case. Is it possible?  If yes, how?D - I'm also trying to use Zapier. Is it a good idea?(for doubts or more details, just answer me back)Thank you all in advance.

We have a suggestion box that is sourced from a Slack workflow form. The form answers move directly from Slack into an Airtable Base to be managed. Our Slack users without Airtable accounts are unable to launch the workflow and cannot contribute. Is there any way to get the submission form to launch for Slack-only users? Or a workaround to get their responses into Airtable by first routing elsewhere?Considering Airtable allows for form submissions on its own platform for non-users, I had assumed this one way traffic into our base wouldn't be an issue and now we're in a pickle. Thanks!

Hello!I have created a table view based off my main table to keep track of my drivers working hours. Legislation requires me to input something for each date, so on days they are off I have to write "Off". I have it set up that they fill out a form, which fills the main table. How can I set an automation to create fields in between the dates, each time a driver fills out a new form?Any help is appreciated because I've tried so many ways and it keeps giving me errors

Hello,I want to hand executive leadership a simple tool to use as they are not familiar with Airtable like our Project Managers are. The workflow I am hoping for is a Gantt chart, that would auto filter when they select a record to look at. If I have a list of project records, each project has different teams assigned to it, often multiple teams. If someone clicks "Project A", I would want the Gantt to auto filter to only include projects that have the same teams as "Project A". Then a simple way to reset the filter to move on to "Project B", then it filters to only show projects with the same teams as "project b". The idea is to see when projects are running from start to finish, and to be able to compare a new project that uses the same teams so we can time slot the start/end of the new project better, based on team availability. Thanks!

@Bill.French @ScottWorld I have installed the maps extension and successfully set up a field with the static map API to generate a static map based on an address and populate an image of that map as an attachment in a field for each record. How do I get this to run automatically when a new record is created or a new record enters a specific view? I have tried using the script from the extension in a script automation triggered by an event (new record, record enters a view etc.) and it doesn’t like the script from the extension

How can i auto-fill a linked field?i have 2 linked tables in Airtable: CONTENT and CONTENT TYPESIn the table CONTENT i have two linked fields CONTENT TYPE and WORKFLOW In CONTENT TYPES i have the two "originals" of CONTENT TYPE and WORKFLOW If i select in the CONTENT table the linked value CONTENT TYPE and this CONTENT TYPE has a DEFAULT WORKFLOW (i.e. cell is not empty) then the WORKFLOW field in CONTENT table should auto-populate with the DEFAULT WORKFLOW value.Basically only if there is a default workflow (cell not empty) of the Workflow column in the content type table, then this value should be auto-filled on a linked field in the CONTENT table. Hope this makes sense? I know this can be done with an automation inside airtable. but how?

I am creating an automation that sends a reminder email if a task is not complete within a certain date. That being said, some users have multiple tasks to complete and receive an individual email for each record they’re attached to. Is there a way I can have a reminder email sent with multiple records condensed into one message so the owner does not receive multiple emails?

Hi guys,i have an automation and want to copy that to another base.It's a base that will be created from a snapshot that was taken (if this is important).Thanks 4 help!Julian

I'm having a problem getting my airtable to properly work with a dynamic page created on our website. There is an embedded form within the dynamic page, and the HTML for this is linked to a record within the aritable "Form HTML".I have been able to get this to work with the simple form html. What I am now trying to do is add on extra criteria within the HTML so that a section of the form is pre populated when loading certain pages. As soon as I add the extra code in it results in problems. I either get that the page cannot be found, or it will say this for about 10 minutes and then magically load, but it will only load on a desktop and not a mobile. The mobile always shows page cannot be found.The standard html is <div class="beacon-form" data-account="isleofwightdonkeysanctuary" data-form="83485bc4"></div> but I need it to be <div class="beacon-form" data-account="isleofwightdonkeysanctuary" data-form="83485bc4" data-bcn-c-donkey="xxx"&g

Hi - I am trying to do a daily balance and bills owed table and am wanting to match expected income so that the dates match. Ideally it would also have a daily exchange rate. I am just not sure how to match and roll-up based on varrying criteria without needing a new column for each date. How do I do this? Do I need a third table?

My goal is to create a single automation, that checks multiple separate fields and if they contain values, process separate actions.For example, if a new record is created and there are values in the field weight, then update the weight field of the linked record. If a new record is created and there are values in the location field, then update the location field of the linked record.Now the statements follow an IF -> ELIF (Otherwise if) logic, therefore if a new record is created and both fields (Weight and location) are not empty, only the first condition is fulfilled and the automation stops. In this case the weight would be updated (matching the first IF condition), but the location would not (because the first condition was fulfilled).My workaround for this has been creating first a field that checksIF weight AND location have values, update both,ELIF weight has values, update weightELIF location has values, update location

I have a JSON array in a field called 'Output' in a table called 'Assessmnt converter'. I am trying to create new records into a table called 'Submissions test' and populate the data into four respective fields; Question number raw, Question raw, Number of marks raw and Student answer raw. I have created an automation whereby if the 'Output is not empty', it runs the following script. However, every time I run the script, I'm getting the following error:CONSOLE.ERROR"Error parsing JSON data:"▶Error {name: "SyntaxError"}Here is my script:// Load the Airtable scripting environmentlet assessmentTable = base.getTable(

I have built an automation and it works very well. When I open a new row in the "Projects" table, it automatically adds the necessary tasks in the "Tasks" table. It also fills in the default values. Great. Unfortunately, I cannot insert a default value from the "Projects" table as a lookup. I can select it, but nothing happens. Does anyone have a tip?When I do the preview, the value appears, but only the one already created. In my case "test".Or is this only possible via the "Create child linked records" script?    

Hi there,I have this automation I have built and it looks right to me and passes the test. The test data populates in the destination table. But when I manually enter data into the source table nothing happens.Here is the automation: This is the destination table. The Article Number "F25NSECVR" was populated when I ran the test.This is the source table. I manually entered "F25TEST" and nothing happened.   

I have this actionable message automation that doesn't seem to work.  I can see it failed and the recipient was not filled out. A typical non-actionable Slack automation seems to work fine and I can see a recipient.Is there something I am missing?  

Hi guys!On one table I'm looking at Set Up Account details, and on the other I'm looking at Account Performance. The first pulls data from Typeform, the second from our internal system. To be able to tell how well the account is doing, I need the context of what stage of 'set up' the account is in, so I need the Status to dynamically update Performance, when it's changed in Set Up. I've tried to do a Linked Field, but it doesn't seem to be accurate, and now it's not working at all. I'm not sure whether that's the best solution? So I tried to automate it. The trigger stage is successful (attached), but then the Update Records stage fails with 'Received Invalid Inputs'. I'm matching the records based on our internal ID number that we update the fields with (ave_id). Any help or ideas gratefully received! Thank you. 

I am simply trying to connect to the information from one table to another table automatically using automation. Every time I try it it comes up with errors. I have tried using the record id formula to connect them (they dont match between tables). I have used the primary id (email) and it wont work. I have tried the Link to Another Record field. Even in the error I am seeing both emails, so it seems like it should work. What am I doing wrong?