Automations

Hello,i am authenticating to one of our integration using Oauth mechanism as prescribed in airtable docs,after granting access in the airtable, the accessToken is generated in only few cases but not all the time. There is no change in the flow and code. But the successful authentication is intermittent. The "/authorize" is working fine all the time. but the "/oauth2/v1/token" fails sometimes.The request have the following params: code, redirct_uri, grant_type, code_verifier. The integration has client_secret, so client_id is not part of the request.When the request fails, i get the Response as:  '{"error":"invalid_grant","error_description":"Unrecognized grant code"}' . 

We use automation to combine records from more than one field and find that they remain in the automation field when a record is deleted from one of the original fields. Is there a way to remove these linked records from the automation field when they are removed from the trigger field? We don’t want to clear all the linked records, just the removed ones.  

I need to run the  same automation  in  multiple bases.  Is there way to share the code across basis?  Are  there any 3rd  party extensions that do that?  Thank you

Used Case Scenario:Table Set Up:I have a Requests Table, a Designers Table and the North America Availability Table.Requests come into the Requests Table but based on the requested roles, there are automations set to create a linked record in the NA Availability table for each of the requested roles. (i.e. if a request comes in with a request for a coordinator, program manager and a director, 3 new records will be created in the NA Availability table)The Designers Table is also linked to the North America Availablity Table so that any requested roles and any designers who are considered for these roles are linked via the Designers Table.  A new request for a coordinator has been submitted (this record will have an "Open Need" tag) - see image 1I originally add "Lisa Bauer" as a potential option (under the Being Considered field) - see image 1An automation will create a new record in the same ta

Hello everyone,I am trying to create a button automation in the interface designer that will change the status of a customer from "Lead" to "Customer". I've set up the automation, created the button and added it to the interface. Manually the process would look like this: Everytime an employee successfully turns a lead into a paying customer, they log a record called "Outreach Log" in the Outreach Table. Employee information is linked to Outreach log since there could be multiple outreach attempts to one Lead. The employee information includes name, email, etc. etc.Currently, our colleagues would have to manually add new records via interface forms: link to Lead ID, type of outreach, date of outreach, and outcome. I also have the "Log Submitted By" data field that pulls who submitted the form via their Airtable Login.Now that I want to automate this process, everything works except the "Log Submitted By". Is there any way around this? It se

i'm trying to automate the following workflow:A colleague fills in a form and it is submitted to create a single row in A sheet. This includes multiple dates associated with a new project. Example:Sheet 1 single row: project title: uncover | project start date: 12/23/2023 | project end date: 12/23/2024 | Milestone 1: 1/1/2024 | Milestone 2: 3/1/202mOn submission of the form, the dates from the new entry/project are used to create activities/new rows in another sheet. This allows me to populate a Gaant automatically:Sheet 24 rows created:Project duration | Project title: Uncover | Start: 12/23/2023 | End: 12/23/2024 Milestone 1 | Project title: Uncover | Start: 11/1/2024 | End: Milestone 2 | Project title: Uncover | Start: 3/1/202m | End:  I've tried a few times to do this and get various errors. I think I am probably approaching the proble

Hi,I'm trying to automate one task in Airtable.To give you a bit of context, I have a database in Notion containing Website articles. I'm sending the records to Airtable using a 3rd-party software. The data is sync in real time.I would like each new record that comes in Airtable database to be sent to a new database where the data is not sync. The other records that was sync up in the past shouldn't be updated.Any idea how to achieve this in Airtable?

Hi there,I have a database with form entries, and I want to create a view which shows just one entry per email address. I want to show whichever one has the most recent submission time and hide the other from this particular view, but not delete it entirely. Everything seem to suggest the dedupe extension, however, this just deletes the record rather than hide it.Thanks!

I am trying to have the checkbox (Status) marked check when OPT2 has all of OPT1 values.OPT1 is fixed value, while OPT2 is user's input.What is wrong with my automation here? am I using the "has all of" operator incorrectly?

Hello !I'm sure it's very simple but I need some help because I'm trying several ways to do this without success at all...I'm trying to do that :I'm in the same base but I've 2 tables, one for customer list and one for machines list. Both are sync from another base.- In table 1, when I pass the customer's statute to "completed", I would like, in table 2, all the statuses of the client's machines to change to "completed" too.For example, when I pass the X customer to "completed" in table 1, all the X customer's machines in table 2 pass to "completed". Most of errors that I had was "record doesn't exist" or "invalid input"...Thanks a lot !

I am adding Mastodon as an end point for my social needs.I would like to replicate my Twitter automations and post to Mastodon. Does anyone have any idea how to create a webhook to do that?

I am suddenly having many separate automations fail. they all involve sending an email. in some cases, the automation involves sending more than one email, and it will send 2 emails and then fail on the 3rd (all within the same automation). In other cases, it fails on the first email. i am getting two different errors. Microsoft reported an error while processing this action:Microsoft may be experiencing issues with their API | Message draft was unable to be deleted.Microsoft reported an error while processing this action:An unknown error occurred.In each case, the automation is using the Outlook Email- Send Email action. And they are connected with my outlook. the automations have worked without issue for a year and i used them last week without issue. i tried restarting my computer. this did not solve the issue. any other suggestions as to what is go

I’m trying to set up the new hootsuite automation that is in beta. All fields are filled and permission for automation to be used are on, but when I run the test I get the error message “Hootsuite reported an error while processing this action: This social profile type is not supported by our API at this time” Is there a way to fix this? Is it a known bug?

I currently have an automation set up that when a new row is created in Google Sheets, it creates a new record in Airtable. Is it possible to set up an automation that if that row is updated in Google Sheets, it updates in Airtable? I don't want to use a 3rd party service to do this. Thank you! 

Hi there I am hoping you can help me.I need to automate Clinician Fees in Airtable according to the Insurance company and whether the patient is a clinic (default fee) or practitioner's own patient (unique).    Will it be easier to do an Automation or Formula and how would you do that?Thanking you in advance for the help. 

I need help creating an automation that runs when a form is submitted. This automation script needs to take field inputs from the form and pass them along to Zoho to create a calendar event. The important values are the title, creation date, user, and description. Any help is appreciated!

I am working on a massive update to my table 250+ records. Each record has a "terpene profile" field that can contain anywhere from 1-9 terpenes, each with their own associated "effect" , "flavor and aroma profile" and "helps with" fields that all need their associated selectable added to their already existing fields. I know that my best bet is to run a script, but I am not very good at writing scripts yet. Any ideas on a framework for how I might format a script like this?

Hello ! I would like to create an automation - sending an email to a member of my team - the day after he finishes his stay. I've created an automation when "ending date" is "tomorrow", then send an email.However, they receive the mail at midnight. I would like that the mail arrives around 7pm the day after. Do you know how to automate that ? thank you very munch ! 

Hi, I need to iterate and create multiple linked records in table2 from table1 (without selecting them). But when I run my code I get the following error: “Can’t create records: invalid cell value for field ‘Property’. Cell value has invalid format: .0.0 must be an object. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id.” I assume I have to put the linked record id in the createRecordAsync function, but I don’t know how the syntax for that should be. Here is the full code. Thank you! let importTable = base.getTable('Master List'); let importView = importTable.getView('Active View'); let importQuery = await importView.selectRecordsAsync(); let secondTable = base.getTable('Table2'); for (let record of importQuery.records) { let fullName = record.getCellValue('Name'); await peopleTable.createRecordAsync({ "Person": fullName }) output.text(`N

Hi, I have been trying to figure out how to increment a number upon adding a new line. For example, Line 1 = A0001 Line 2 = A0002 Line 3 = A0003 I understand that the function of auto-number helps but i would like the characters in the front and wanted to see if there was a more efficient way than manually inputting this every line. Thank you.

Hello !I am encountering a problem when creating an automation script for one of my tables. I set up a trigger to occur when the user creates a record. I then wrote a script to be run as an action of the trigger. This script contains a 'fetch' call to a local Flask server where we will do all the process ensuing this trigger activation.Unfortunately, whenever I test my script, it always indicates :  TypeError: Requests to '10.110.90.204' are not permitted at main on line 1 Here is the script I am using : let response = await fetch('https://10.110.90.204:8050/process'); Can you help me with this, please ?

Hi 🙂I have user information in 2 different tables but in both I have a field with the user email that could be used as a linking field. I would like to set an automation to update a specific field from table B into table A using the email as a matching reference. The same email is in both tables. Any help will be highly appreciated.Will earn the right for "caipirinhas" on me whenever you visit Brazil 🙂 Thanks a lot!

Hi there,I have a form that captures emailHere is an example of what the data could look likeI'm trying to create an automation such that any time a unique email is entered, data is populated here. In the table above you see that ethan@abc.com is entered a few times, yet only appears once below.     

I am collecting survey results into an airtable base.This includes two tables:The index for all surveys (and including key information such as deadline).The responses for the various surveys (each response is linked to a survey)Each survey has a deadline (time field deadline), when it should stop accepting responses. A this point, the survey and its results should be transfered into a new view of each table that then syncs to another base.I have created an IF formula, that (all dates are set into the same timezone: CEST) switches to "transfer", once NOW() is larger than the deadline date (which is CEST is 2am). For the responses, I add 5 minutes to the deadline to ensure that the survey has already been synched.If I look at the CREATED_TIME() for the entries in the synched table in the other base, all entries have been created at the same time (i.e. the delay added to responses does not seem to have been

I have an interface to track overtime opportunities for my team. There is a button to click if you'd like to express interest in working an event with an automation set up to:1) send an e-mail with your name and the event you're interested in to management2) automatically clear your checked box and clear your name from "last edited by" so other people aren't discouraged from expressing interest if they think someone has already claimed that day or time. This works for those with base access, because we can see who updated the field in the activity history. The problem is I am trying to kick everyone out of the base except me, and other team members that need that information won't have access to the activity history. My questions are:1) is there a way to show activity history in an interface? I see the area to add comments, but not activity to an interface view2) is there a way to track the names of everyone who has c