Automations

Hello everybody, i have a problem with an automation, it worked for more than a year without problems, but now it stopped to working giving me this error: attachment url is disallowed. I specify that nothing has been changed in the trigger, nor in the file to be attached (it is the same pdf format), the trigger starts when it finds the conditions inserted (and this passes) but when the email is sent it fails. Can you help me solve? Thank you

Hi all, I'm trying to remove a deactivated User from my base with an automation. Has anyone managed to achieve this? 

Hello.Am trying to automate creation of document from airtable. The questions are in a lookup fieldBelow is the information i want to push to be created in a document and attached is my workflow.My problem is the out put is not correct.I will wish is the question to be created in the document and numbered correctly.How can i achieve this?Thank youThe outputthe flowget record from airtable 

Hello ,I am trying to link a row to another row via an automation script , how can I get the url link to a cell because when I do a for(let  record of tableQuery.records) i can only get the record.id or record.name isn't their a way to get the record.urlLink ? Thanks for the help 

Hi,I am trying to create an automation that will create a quarterly report for me every 3 months.How can I make a report be created every 3 months for each client?I'm using docsautomator so I tried this: https://imghostr.com/938e92_l5x but it didnt work  

How do I automate that a record gets created/populated when certain conditions are met. For example, When the value of Food is 'apple', and the Color is 'green', Attitude is 'happy'. Thanks for your help. 

I want to use AirTable so that users can login and access their test results and marks. You could call it a dashboard or customer portal site. So, one user’s results can’t be seen by another, this is why I need login or user accounts. I will be using AirTable forms (maybe Typeform) and AirTable sheets to enter the user’s test results. I have looked at various third party sites that build websites using AirTable data. However, I am not sure if they will be able to do what I need to do. I found one that looks like it could softr.io - but it is very expensive in my opinion. I know I could use a dedicated Dashboard or portal software like SuiteDash, but I am trying to automate as much as possible. I already have a SuiteDash account. I am happy to spend some money on a paid SaaS product. Does anyone have any suggestions or possible solutions? Thank you.

Apologies for the confusing title. To not confuse things further, I'll minimise the story/context. I'm developing a crop planning and record keeping system for our farm.For this issue, I have 3 tables in question. 1) Crops (basic info about all our crops)2) Crop Plan (for planning)3) Field (what actually happens in the field, as plans are never followed 100%).More than one Crop is added to the crop plan via a linked record. An automation creates a record for each crop with a "planned" status in Field. The planning info and dates are dynamically updated between tables. So there are two linked records in the Crop Plan table - Crop and Field. The Field table also have a linked record to Crops. This is automatically filled when the Crop field in the Crop Planner is filled.So if you add the crop "Beetroot" and "Radish" to the crop plan table to plant on 01/01/24, 1 record is created in t

Hi everyone,I have an automation that runs a script which sends a recordID to a Make webhook.Every now and then the automation fails because Airtable sets the script execution limit to 30 seconds. That makes me think that the problem is because of Make, in that the processing in Make takes longer so in return Airtable exceeds the execution time.Has anyone else experienced this issue? Is there a way for us to resolve this or perhaps a workaround?Here's my simple script: let inputConfig = input.config(); let webhook = 'https://hook.us1.make.com/jflrewqrewmnmnnqsdfsqsgtewvs' let queryParams = `/?record=${inputConfig.record}` fetch(`${webhook}${queryParams}`); 

I have a "Send an email" automation set up with the trigger "when {{Date field}} is one week from now."It's working great, except the emails are going out just after midnight. I'd prefer them to go around 9am. I have added a time to my date field, but that does not seem to work. Any advice?    

Many times we wish to have a single select or multi select field automatically choose an output based on other fields. Automations are useful for this, but are limited and become convoluted as a separate module, especially when you have many of these use cases in one table.It would be very useful to have a single select or multi select field with an inbuilt formula box, where the select output could be determined by the formula. You could then introduce another option to lock formula mapping (ie no ability to edit), or freeze mapping, where an Auto value output would generate unless the field was manually overwritten.The workaround at present is to create three Fields, 1 select field for manual input, 1 formula field for automated input and one last official formula field to take the most relevant of the two previous outputs. This generates clunky database design, similar to when there was no today() function.

I appreciate your help!I have one main table of English learners who register for classes - name, contact info, etc. Let's call is the Main Student table.There are two other tables that get data related to each student. (One table gets data from Stripe if the student is able to pay anything. Another table shows teacher comments about the student from the prior year.)In the past, we set up links between the tables. Then, for each student, we manually linked the individual records and had "lookup" fields for the fee & comments in the main Student table. But we had 750 learners register with us last year!How can we automate this? I'm thinking that an automation would need to:1. Find matches between the Main Student table and the other tables (based on one or more of name / email / phone)2. Update the record on the Main Student table with the data for that student in the other tables.I have searched for examples (found one relevant one but from 2019) and tried some combinations of "fin

Hello everyone,I currently have two tables, one for Plants (industrial power/chemical plants) and one for Events (scheduled maintenance outages). Each Plant has a unique Plant ID that is also listed on each Event with multiple Events for each Plant. Is there a way to automatically link each Event to its respective Plant based on matching the Plant ID in each record? In other words, is there an automation that exists or can be created that looks at the Plant ID on the record in the Plant table and the Event table, recognizes that field as identical on both, then links the two records? Thank you!KCVellichor

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://support.airtable.com/docs/using-markdown-in-airtable), but it's not working for the "List of 'File Name'" result that gets

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 recvhvhDDXVsYTmCc2. Update Record:- Table: Needle Tasks - General- Record ID: Use data from the previous action (Find Records)- Fields: Data is taken from the trigger in Dynamic ModeThe problem arises when executing the second action (Update Record). I receive the error "Received invalid inputs."Details of the error for the second action:- Table: Needle Tasks - General- Record ID: recvhvhDDXVsYTmC

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!