Automations

Hello, I’m having an issue with all of the automations I have running with Jira Cloud integration. The automations have all been functioning properly for the last couple of months, then today at a certain time they all of a sudden started throwing failures for unknown errors. Below is a recording of a couple of the automation’s setups and the errors and run history. One important note is that it IS creating the tickets (even though it says fail) but then it stops the proceeding steps and fails the automation. Recording of automations Important notes: no one made any changes to any automation that could have caused this (I am the only person who can do this and I wasn’t on the Airtable). I did a snapshot of the last time the one automation worked, and it still threw a fail. I have tried to reconnect the Jira Cloud with the automation, hasn’t changed anything… You’ll also see that the new marketing intake automation worked on the same day but then stopped working later that day. The prob

Hello, I’m trying to limit my teams input on record creation. on my records I have two fields one is called “LinerType” and is single select and the other is called “Liner” and is also single select. I want to make an automation or something so that when “LinerType’s” selection is “N/A” it automatically makes the field “Liner” to be selected as “N/A” as well. Basically I believe this amounts to being a conditional statement maybe? when LinerType = "N/A" then Liner = "N/A"

I have a multi-select status field that I would like automated but not sure where to start. I have a ‘Due Date’ field and a ‘Status’ field. I want the ‘Status’ field to automatically show either On-Time or Late depending on the ‘Due Date’ field. I tried writing a formula for it and it worked but I wanted to make the ‘Status’ field a multiple select field. Is there a way I can automate this so depending on the ‘Due Date’ and the current date, the ‘Status’ field will automatically populate with the options of On-Time or Late?

Hey everyone, For a software project we are importing data from an existing erp to airtable. We wrote a script linked to a button that gets the data from various endpoints and uses it to calculate some fields and fill in or update records. Now we would like to automaticly synchronize projects that change in the erp. So every hour we look at the ones that changed in the last hours and update “sync” field with a date. When that date changes it triggers an automation with the earlier mentioned script (small change in how it gets the id from record). However it is impossible to make requests to external api’s using automations at this time => always get the error “TypeError: Requests that follow redirects are not supported currently”. I was wondering if there is a way to let a script/automation press a button-field from a record? Or a way around the type-error but it is mentioned Using Scripting Block to push a webhook on button click already so I doubt it

I have some AT automatons that are not reliably happening when they should be. Here’s my setup, can anyone help me improve it? I want to update a single-select drop-down column according to a formula. The formula will output a value in the single-select choices. So I have a filtered view that only shows records where the string equivalents of the drop-down and formula columns are not the same. On this, I have an automation that watches for records to enter this view, and then sets the single-select to the value of the formula. Since the view is filtered by unmatching values, it should always be emptied by the automation which matches them. It works most of the time but I continuously check the view, and find updates missed. If your curious about the background, we’ve found that given the lack of mobile support for interfaces, the kanban view actually works best on phones, to populate shuttle driver’s job list. But we want the cards to be locked to a formula, not changable in the normal

Hey everyone, Hoping that this is a simple fix, but can’t find any documentation on this problem so far. Problem: The output of a script is not being accepted as inputs to downstream steps in an automation I am trying to create. Use Case: I am trying to create an automation that does the following: //trigger There’s an update to a Google Calendar Event //actions Look up corresponding Airtable Record //run script Compare the Start/End Times between the Airtable record and the updated Google Event, output whether the times match or not. //Conditional Actions IF: Start/End Times DO match → Do Nothing, end the automtation IF: Start Times DO NOT match → Update Airtable record with new Start Time value from Google Calendar IF: End Times DO NOT match → Update Airtable record with new End Time value from Google Calendar Below are some screenshots of the automation, the script code that I’ve written, and the “error” I am getting when I try to use the Script Outputs in downstream conditional a

Hey everyone Having problem with an automation when a record is checked, a copy of the record is made in another table. The problem is that it works ok when doing it slow and one record at the time, but I want to take all the checked records at the same time or to speed up the automation, its very easy that a copy is not made because of the slow automation. Any ideas? Regards Jesper

Hi using this formula works… IF({Type of Task}=“CANCEL”,DATEADD({Check In Date},-1,“days”), IF({Type of Task}=“REBOOK”,DATEADD({Check In Date},-60,"days”))) But then I want to add another condition so have copied it the exact same way and it doesn’t work? I’m suspecting its to do with the number of ))) at the end as I have no clue why in the first condition it ended with ) and the second ended with ))) so have tried all number of them but they don’t work. Thanks in advance. IF({Type of Task}=“CANCEL”,DATEADD({Check In Date},-1,“days”), IF({Type of Task}=“REBOOK”,DATEADD({Check In Date},-60,"days”))), IF({Type of Task}=“CHECK PAYMENT”,DATEADD({Check In Date},1,"days”)))

Is there a way to do that with Airtable’s automations? I find that our users don’t usually check their Airtable notifications.

Hi Everyone, I am currently trying to figure out a way to do the following: I have two tables. 1 is for projects and 1 is for project options. Each project option is linked to the proper project and both have single selects for their status. Essentially it is set up like this: (Project Table) Project Name | Status | Project Options | Final Approved Option (Project Options Table) Project Option Name | Linked Project | Status | ~ Various other information The Status fields are single selects with various statuses…i.e. Research Cutting Sent for Approval Final Approved Paid My goal is to do two things. #1 Have the Project Table automatically update status based on the Project Options linked. #2 Have the Final Approved Option link to the record that matches the proper criteria. Given that several options will be made for each Project, there will also need to be a hierarchy where a project option that is further along the process negates ones that haven’t progressed as far. Any ideas on how

Hello! I have an automation setup that when run “successfully” only populates some of the fields specified in the the action. Screenshot included below and highlighted where the errors are occurring. I also after a successful run initially eventually got an error message (seen in a screenshot below that “Could not find matching rows for string”. Was hoping could get some seeds of support on these two issues. Results of Automation From Initial “Successful” Run (The column Tags__ForLinking is the target field that updates as a result of the automation): Automation Setup: Trigger: Action: (1) Properties (2) Configuration (3) Testing

I am trying to update multiple records at once using an automation with a script. I received a lot of help by using the script referenced here: Update Multiple Records with Automation. Basically, I am trying to mark records in one table (called “Summer Registrations”) as “paid” AND link those records to the the trigger payment record. The trigger payments can be linked to more than one record, which is why I know I need to use a script. Marking all the found records as “paid” is working fine, but the problem I’m having is pulling in the Record IDs from the trigger step. In the screenshot, I want to put the Airtable record ID from the step1 trigger into the field marked “Receipt”.

Hello! I am trying to automate posting a random record to twitter. I have an automation set up already that whenever i check a box on the record it will send out the tweet - this is working fine. I want to automate that step though so i made a column with “random” values. Now I want to set an automation that each day, it finds a record with the highest value from that “random” value column and updated the record to check the box that will then trigger the twitter automation. How can I set up an automation to find the highest value and then update that record by checking the box? Thanks!

I’m working on a Risk Register. I’d like the Priority single select field to display options ranging from very low to very high, depending on the risk rating number that is returned through a formula field. For example, the formula field may determine the risk rating to be 25. I’d like the Priority single select field to display the words ‘very high’ in red. If the number value is returned as 5, I’d like the Priority field to display ‘very low’ in green.

With Airtable automations I see them in the test output results, but I’m not able to select them as variables to auto fill a field. I know 3th party tools like make/zapier/miniextension are able to do this for me, but I don’t like to use them as it adds complexity to the setup. Thoughts / (native) solutions anyone?

I would like to build an automation script that deletes the record after 14 days of being done. Status = done Table Name = Onboarding Status

I have a base my team uses for resource planning and time tracking. I assign tasks and hours in the Gantt view, tasks sometimes span days and weeks (there is a start date, end date, and duration field). My employees then add their actual hours to the existing records as a time sheet. The problem I’m running into is that when assigning multi day tasks only one assignment record is created for the first day of the task, and all assigned hours are put on that task. I need an automation that will create a new record for every unique date between the start and end date of a task, duplicating all other attribute information and assigning the appropriate daily hours according to a formula. Is this possible within Airtable or do I need to use a different service? Thanks in advance for any thoughts or advice!

Dear community, I have a question regarding the updating of the fields in Airtable. For instance, there are 100 customers and 50 of them have the Increase tag. I want to know how to make this flow: A new record added–>If the customer has Increase tag–>Update field. And this update will be in every 1 minute or less. Thanks,

I’m recording sales orders by scanning barcodes of the products that are being sold. For eg: if I’m selling product A, I’d scan the barcode from my phone using the Airtable app and the barcode field would be populated. Now, my aim is to automatically populate linked records using automation. Check the image below, I have 2 tables - Inventory (test) and Sales Orders (test). I have scanned the barcodes of the actual products to record inventory in Inventory (test). You can see 10 units of each product with unique barcodes. Now, let’s check the Sales Order table in the image below, You can see that the Inventory (test) is linked to the Sales Order (test). So, when I scan the barcode from my phone of an item sold, the automation will be triggered and update the barcode in the linked record. The images below are of automation, The trigger would be “when a record is created” in sales order (test) Action would be “Update the record” based on the record Id from step 1 and update the “Inven

Hello, Our orders are composed of several sub orders. Each sub order has their own status, because they are managed independently. The main order status is equal to the less advanced of the sub orders status. I’m trying to update automatically update the main order status (we do it manually at the moment). Any idea how ? Here is a simplified version of our system to illustrate. Status : in progress shipped delivered Main order : sub order 1 : in progress sub order 2 : delivered sub order 3 : shipped —> Main order status = in progress (because it is the less advanced of the sub orders status) When the “sub order 1” updates to “shipped”, the “main order” status should update to “shipped” as well. Thank you,

Is there any way to edit the templates used for the HTML list or grid rendering options?

Hi, I am new to airtable, I’m creating a zapier automation from airtable to google sheets transferring data from a view (which is locked so no changes can be unwittingly made), when I test within Zapier the record fills into google sheets correctly but when its running later by itself it only transfers over 3 or 4 out of the 8 fields to be mapped, so in principle it works but there is some issue on collecting the data. The fields missing are dates, text and currency fields that i formatted in. google sheets, which is what I am wondering is causing the problem. Can anyone direct me as to what things to check? Thanks!

I use Airtable for content marketing. One article = One card in the kanban view. Cards have a field called “QA” which is linked to the “people” record. A QA person is set manually when the article is started. But the QA person changes when the article is put into our CRM system, to do technical checks on it. Therefore I’m trying to automate this in the kanban view: “When any card is moved to a certain stack (Called CRM QA), change the name in the QA field to the technical QA person.” The technical QA person is currently always the same, so it just needs to change to one specific name. Is that possible?

I have a google calendar linked to a table. I want to take particular information from that table and congregate that on a separate table1. My issue is only new information added to the calendar table is updated in the table1. How do I get All current and future information from the calendar table to update table1, instead of just new events? I do not see an automation that lets me sync all current and updated information from the calendar table to another table. Please help

I have a workflow that I need to get done. User fills a row in a table. The row that gets filled is made into a pdf using page designer. The designed page is sent as a pdf to some static email addresses. The pdf also needs to be stored in another table as an attachment. I did the first two parts. I’m having trouble doing the other two as I cannot figure out anything to do about it. I would be grateful if anyone helps. Thanks!