Automations

Hello friendsI have a script, that makes queries and record update,  after that I have Google Calendar Sync, Calendar Dates are dependent on Script results. I tried await keyword in front of record update statement and the timeout end of the script, but Calendar Sync executes before the script ends, how i can solve this problem, any ideas?

Hello :slightly_smiling_face: Well, the title says it all I guess … I’d like to set an automation when a defined view reaches a number of records I define. Is it possible, please ? it seems I can’t find a way for now. Thanks in advance for your help. Regards. Nicolas Caplat

Good morning,I am writing in reference to a problem with the Airtable integration via Token at MAKE We need this integration to ensure that Make automatically connects leads arriving from Facebook and the CRM in AirtableThe problem is that every time I inserted the Personal Access Token to do the integration, it gives me the error "Status Code Error: 401"What could be the problem? Are there any essential settings for the Persona Access Token to integrate it with Make?Thank you,Best Regards

Hello,I need help setting up an automation that links records in a "dependencies" field to a predecessor/successor record (determined by order number). The goal is to automate tasks to hit contributors dashboard when its their turn to work on the project. We have a Projects, Tasks, Content Type and Templated Steps boards that ive set an extension to generate a specific task list based on the type of content. I can edit the extension code to include the dependencies field and set those are part of the template, but the problem is that many project managers use this as a starting point and edit the task list manually, adding or subtracting tasks for their specific need. If a project manager edits the task list, they have to manually manipulate the dependencies field using the gantt view, which is cumbersome and manual. id like to set a way for the field to automatically update based on the task order. So the trigger I have in place is "when record is updated"- on the task board, so

All day it's been 10-15 mins to execute a workflow of a few steps, some scripting, some update record.  Is this isolated or has anyone experienced this today?

Hi there,I have a registration form. A single respondent will enter the the following data: name_1, email_1, an ID code, name_2, email_2, name_3, email_3.Instead of this being stored as a single row. I need this to be stored as multiple rows.row 1: name_1, email_1, and ID code, name_2, email_2row 2:  name_1, email_1, and ID code, name_3, email_3How can I get this done? 

Good afternoon,I am attempting to create an automation that sends an email to my team with details about some work items.We use an Interface view to organize those records, and I need to generate links to each record so that when a team member clicks it, it opens in the Interface view, not in the Data view. The default is a view that doesn't show all the data we need (instead of the view from which the automated email came from), which is annoying in the first place. I'm trying to solve that via the interface. I know how to generate a link to a record in the Data view, by just using the record ID. But I haven't found a way to do the same in Interfaces.For example:This is a link to a record in the Interface: https://airtable.com/{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lkIjoicmVjZHMweHdocHlmVE1scEQiLCJzaG93Q29tbWVudHMiOmZhbHNlfQThis is another one: https://airtable.com/{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lk

Hello - full disclosure, I've only just started to get into scripting in Airtable, so bare with me as I'm still learning!My actual goal with this script is actually quite complex, I'm probably only about half way through. But instead of trying to summarize the entire thing, I'm just going to hone in on where I'm stuck specifically... which is how to properly utilize the Filter function with arrays.So I have a button trigger in a table "TV Finishing" that I want to execute a script. The script copies a name and an alphanumeric code (ISCI code) from the record, and pastes it as a new record in the table "AutoHelper". This I have working just fine.But then I want the script to count how many existing records in "AutoHelper" already have the same ISCI Code, and to paste the number (plus 1) into a number field of the newly created record... and this is where I'm stuck.I've added my existing script below with the error code I'm getting when I try to use query.records.filter. I've tried to em

I'm trying to sync an excel online file (that's a .url file) to airtable and airtable won't recognize it. Can anyone help? If this doesn't work I'll have to figure out how to go map fields from oracle to airtable but would be far easier to just use the excel online file that is already mapped correctly and pull that into airtable and have it automatically update from there. There's no editing we'll need to do from airtable to excel online, just one way sync to airtable. Thanks for your help!

I use Airtable for timesheet purposes.  The employee completes a form in Airtable, and then that causes a row to be created in my Timesheets table.  Then the payroll staff go in and click an "Update Row" button on the row to enter the date paid. My primary field was a concatenated field of Last Name, First Name, Date Worked when I realized that a person can have 2 rows for the same date which apparently broke my automation.  I have been researching this all day and I do not know how to fix it.  Someone pretty please help! Screenshots included. Thank you!

Hi @dashler78 experts,I have an interface which has a dropdown and a button. When a user chooses a value from the dropdown and clicks on the button, an automation script runs doing the following1. It saves the value chosen in the dropdown.2. Updates 'Created By' as 'Automations'.I want the script to even update another field say 'User' with the user object (of the person who actually clicked the button).Is there a way to input the actual user object using automation script?I saw that I am able to get 'email id' , 'id' - which is usrXXXXXXXXXX and name. However what I actually want in the field is the complete user object which is similar to how 'Created By' and 'Modified By' fields look. Kindly let me know how this can be made possible?I am using an automation script because that is the only way I can save the value from a dropdown in an interface.Currently when I try adding the id in the User (field is of type: User) field, it gives me the following errorError: Field "fldyaWWxTRvpc9bS

Hello everyone, I am having some issues working on a script that I made using Copilot. Here's the reason why I am making it: I have a base which is composed of two tables: Table A and B. I am doing this because, in my company, we review conversations from customer service in order to improve it. Basically, Table A is composed of a form, and we get to see the results to the different questions and one big score (which is a formula field). I made Table B, so a second team can work on conversations which have a QA Score below 80. To do this, I need to create an automation which is composed of 3 steps: 1. When a record is updated in Table A (the QA score appears after grading the conversation)2. Create a record in Table B and add some information: customer's name and Table A QA Score (it's a number field now)3. Since any record will be added to Table B, I made a script to delete any records with a QA Score above 80. This is where I run in some issues

Hello! I am running into an issue automating an email notification when the date column is changed from one date to another. I have the automation set up so that when the date column is changed and the status is 'Sent', the email is triggered. The issue is that the email is getting sent every time the date is changed (including when the date is entered initially).The only workaround I've figured out so far is to set it up so that the record must match Status = Sent and Date is changed and we enter the date column second, but that leaves room for user error. Is there a way to ensure that that the email is sent only when the date column is updated from not empty?

Hi!I have the tables "units" "location," and "event."Events have a lookup field to location, and a location has multiple units. What I want to acheive is to create an automation so that when a record is created in event, a new event for evry unit in that location.I started, but seem to be stuck onTo give an example:Units are lightbulbs, locations are buildings and events are service missions. A user can change one or all lightbulbs in a location via a form as part of a service misson. If the user changes all lightbulbs in a location I want to create a new record for each of the lightbulbs in that location.The point is that it's important to track when the lightbulb last had maintenance.

Should there be a few second pause between multiple triggers? I have 100 records. Every record has a checkbox for approving. Once I check the checkbox an email automation runs. I have an habit of approving multiple records at the same time. Because of that I am not receiving the email. How much pause should be there between 2 triggers in different records?

Hi there, I have a database of social media campaigns with start dates and end dates. I’d like to have both dates add a year when the end date is older than yesterday (so once the campaign ends, it’s automatically set up to happen next year). Ideally, I’d like it to happen once per month, but it can be any trigger. I should add that I’m on the free tier of Airtable I’ve tried a few things, but I can’t seem to get the formula DATEADD({Start Date}, 1, 'years') to work with the automation. Any suggestions?

Hi, Wanted to check if airtable had automation enabled for email requests (sent by customers on a distribution list) received to be converted to a case/record for follow-up for client services?Need to check if the 'email to case' conversion capability is feasible in airtable?Thanks! 

Hello,I am creating a base for performance reviews. Individuals receive Case Review scores (based on a form submission) in one table and then those scores are tabulated in a second Cumulative Scores table. My tables are linked. When I initially created my rollup fields in the Cumulative Scores table, I was able to pull the info from the Case Reviews table and populate my rollup without issue. Now when new forms are submitted, those rollup fields are not updating. I have tried adding lookup fields and automations, but I can't see to get it functioning. Can anybody help me resolve this issue?         

Hello, I have a 'Client' table linking to another table that holds information about Event Labor. From the Event Labor table, I am trying to send an automated email to the client (email address linked from its own table.) When creating the action, the 'Email (from Client table)' is an option, and then I have the choice Linked Record ID or Value. I assumed to use Value but neither choice is working. Any solutions? Video to show my work https://www.loom.com/share/38183324bec943ca8c58bffa9ac91162 

Hello everyone,I've been working on a project that involves making calls to the OpenAI GPT API from Airtable scripting. However, I've encountered a limitation that's been a significant hindrance in the progress of my project.The issue lies with the execution time limit for scripts in Airtable, which is currently set at 30 seconds. In my project, I'm using OpenAI's GPT to generate text based on prompts, and the time it takes to make a request to the API and receive a response often exceeds this 30-second limit.This becomes a significant issue especially when dealing with larger text inputs or outputs, as the processing time inherently increases. Network delays can also contribute to the problem, further extending the execution time.Given the complex nature of language models and the extensive use cases they can cover, it's often necessary to allow for more processing time. The current limitation restricts the full utilization of these powerful APIs and hinders the creation of more compl

Hi everyone!I have a schema of 252 records to apply to some client in a standardized order. This is the script I made (deleted different lines because of number of characters:   let duplicaTable = base.getTable("Duplica_Form") let tyrecords = await duplicaTable.selectRecordsAsync({fields: ["Dashboard Clienti"]}) let cliente = tyrecords.records.filter(item => item.getCellValue("Dashboard Clienti")) //console.log(cliente) let arrayTypeform = [] cliente.forEach(item => { arrayTypeform.push( {fields: {"order": 1, "typeform":[{id:"recg1yUeuxfjKfn0t"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 2, "typeform":[{id:"rec0TnCthwKaCsBcF"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 3, "typeform":[{id:"recg9NPL21ZWduc5g"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 4, "typeform":[{id:"reck4nzT8lp9Us5Nx"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 5, "typeform":[{id:"recPSIR9XZUw6wvNX"}],"duplica_form

Hi there ! I used to have automations running with an outlook connected email being a shared mail box. These kind of mail box doesn't have an outlook account (no password).Since a year now, my automations are no longer working, I have to change every account connected with an exchange account with log in + password. So I tricked here and put a standard email address as connected account (mine) and use the option "send as" and there I put the shared mail box I work with.... still, I have an error message in all my automations saying I don't have the right to send on behalf of...but checking the exchange tenant, I do have these rights....can somebody help ??? How can we used shared mail boxes to send email automation from airtable ???

Hello ! So i have a base and i want to delete all records that are on the table every sunday (weekly). i heard that it’s possible to do it with a script, but i don’t know how. Can you help me please? Thanks

I'm looking for a bit of assistance. I've created an automation that sends a message to a specific MS Teams channel when a record enters a view.However - the message is sent from myself, which means that when the automation triggers, I don't actually get any notification on my PC or my phone (since technically it's "me" who's sending the message).Is there any way to bypass this so that I actually receive a notification? I could use Zapier, but I'd like to avoid that if possible.

Hi everyone,I would like to create 1 automation that starts when a record is created in airtable and that creates an event on google calendar. I used the "when recordmatches conditions" trigger specifying the conditions to make it activate (for example the date field must not be empty). I then inserted my Dynamic "Date" field as "Start date" and "End date", which is made up of both the date and the time. The problem is that when I go to create a record and choose the date, the time is automatically filled in, the automation starts and creates the event at the wrong time. Does anyone know how I could solve it?any help is precious!