Automations

Hello,I'm new here and I need help. Firstly, English is my second language, sorry for the grammatical mistakes.I want to set an automatization when someone submittest a form to Table "Dary" (donations), I want it to search two other tables "Kontakty" (Contacts of individuals) a "Firmy" (Contacts of companies) if there is a record of the donator. If yes add the donation to the donator's record. If not create a new record in its respective Table.Is it even possible? Thanks a lot.

Hi,I have built two automations which work great independently, but when I use both of them in my table one errors out with a "Could not convert string to date" error.Here's what's I've got going on:Automation 1 looks for a Name field with no Start Date and End Date, and when it finds one, it auto-completes the next available Start date which it looks up from a rollup field (using Max values). This works fine on its own.Automation 2 looks for a non-empty Start Date with an empty End Date and auto-fills the End date from a separate formula field. This also works fine on its own.However, when I turn both automations on, Automation 1 runs fine, and auto-completes the next available Start Date, but the second automation fails with the error above.I can go check the Run History of Automation 2, which gives me the failure, so I fire it off manually to test it and it finds the relevant records and fixes it perfectly.I am guessing I may need to make Automation 2 wait a while longer before it t

Things being used: Webhook Reciever, Conditional BlocksWhat i want: I have a constant data send webhook setup, syncing some data to the table,I want to setup something like if Record_Id(From Webhook) is not listed in a field of Airtable then only it will create records,I have tried this But it's not working for me, 

Hi everyone! I wanna know how to add a timeout before this script:  const REQUEST_METHOD = "POST"; var scriptConfig = input.config(); var webhookUrl = scriptConfig.WEBHOOK_URL; var requestConfig = { "method" : REQUEST_METHOD, } if (REQUEST_METHOD == "POST") { // Adds scriptConfig content as JSON body of request requestConfig.body = JSON.stringify(scriptConfig); requestConfig.headers = { "Content-Type": "application/json" }; fetch( webhookUrl, requestConfig ).then(function(response) { output.set("status", 'ok') }) } else if (REQUEST_METHOD == "GET") { // Adds scriptConfig content as query params of request const qs = Object.keys(scriptConfig) .map(key => `${key}=${scriptConfig[key]}`) .join('&'); // Appends queryString parameters to URL webhookUrl += '?' + qs fetch( webhookUrl, requestConfig ).then(function(response) { output.set("status", 'ok') }) } e

Hey friendsI have one table that contains all the names of the people who paid money and one table of cold leads.I want to automate that when a new record is created in the payer's table, a V will be marked with that user based on their email in the cold leads table 1.I created an automation that looks for the email of the person who pays in table 1, but I can't find an option to "update records" for that email in table 1 because I can't find his record ID.I would love to understand what I am doing wrong.Thank you! 

Hi, My Airtable use case is to maintain Farmer’s finances. We have developed a WhatsApp bot, and by using webhook triggers the information gets stored in Airtable.I am using webhooks to populate the Expense Amount field. For eg: The bot asks the question about the Expense Amount, as soon as the user answers this question, the webhook triggers, and the value of the Expense Amount gets updated.What I am trying to achieve is, if the User enters the Expense Amount for the same expense type, the field should add/sum the new value to the previously populated value. For eg: If the user John, enters the Expense Amount for E1 as 200 again then the Expense Amount field should be 300(100 + 200).I want to append the new incoming values in the field and not overwrite it. Any advice or help is appreciated

I've setup an automation email but it seems the formula field is not showing the value. Thank you in advance for the help.     

Hi All, I’m trying to run this automation script that works on a base with 500 records but now throws this error after I migrated some records and now have a total of  ~3500 records.Can someone help me to fix this error.Thank you in advance! //on which you want to run the vlookuplet mainTable = base.getTable("Technology Returns");let mainTableRecords = await mainTable.selectRecordsAsync();//lookuplet lookupTable = base.getTable("Warehouse Returns");let lookupRangeRecords = await lookupTable.selectRecordsAsync();//Replace "Item.barcode" with column name which has the values you want to look up for (let record of mainTableRecords.records) {let lookupValue = record.getCellValue("WebSPOC");//Replace "Barcode" with column name which is the range to search in//Replace "Name" with columnn name which value should be returnedfor (let rangeRecord of lookupRangeRecords.records) {if (rangeRecord.getCellValue("WebSPOC") === lookupValue) {let returnValue = rangeRecord.getCellValue("Re

Hey Guys, Im sure there is a very simple answer here but i am very knew to javascript in general, i appreciate any insight anyone can give me. I am using the airtable script function to post new users to an external application via it's rest api. I am successfully able to create the new user but i wish to record the ID number that is returned in the call back, i would like to use this in later steps in the air table automation but cannot get output.set to work. My script looks like so let inputconfig = input.config();console.log(inputconfig);let name = inputconfig.namelet password = inputconfig.passwordlet username = inputconfig.usernameconst options = {method: 'POST',headers: {accept: 'application/json','content-type': 'application/json',authorization: 'Bearer samsara_api_lxxxxxxxxxxxxxx'},body: JSON.stringify({name: name, username: username, password: password})};let response = await fetch('https://api.samsara.com/fleet/drivers', options).then(response => response.json()).the

We run a 10-week workshop and want to send emails out after each workshop to the attendees. Right now we have a multiple select field with Wk 1, Wk 2, etc and we use that to track who attended. Now we want to send emails out and I can figure out the best way to trigger emails using that single field. Wk 1 is easy, if they have Wk 1 they get the email. if not, they dont. But once we get to Wk 2 it gets more challenging.I don't want to end up with 10 fields one for each week because the team that uses the base will never update it so I'm looking for creative ideas on how to trigger each email. I'm also not opposed to creating some fields at the end of the table that update based on weeks selected but I'm not sure how to do that either.Thanks,Brad  

I want to create an email digest that automatically sends an email with 3 randomly chosen records from one of my tables. The idea is that it randomly sends me 3 per week until it has cycled through all of them and then restarts (all records become eligible again). I messed around with email digest automation but was struggling with the part where you randomly select records and record when it has already been sent (thus making that record ineligible until all have been sent). Any ideas for how to accomplish this? 

hello, i want to automticaly update or create data from MS SQL server to Airtable (see attached file)The process is:I have a view in a table in a DB on MS SQLEveryday automatic execution of the view to create a CSV file on Google DriveI want Airtable update existing records that have been modified in csv file and create new records that have been added to csv file.I already check with Pabbly Connect, I can upgrade if I manually change records in the csv file, but what I want is if the a new release of the csv file have been updated on google drive, Airtable is updated.ThanksSylvain 

Hi,  I would like to run an automation to create the next 7 day scheduling, adding the next 7 working days in calander it would be best if i can copy the last most recent row values as well, but some fields will not be copiedat minimum i would like to run a scrip to add the next 7 days Example: The last date is 25th Dec, i would like the script to add 7 rows 26 Dec 27 Dec 28 Dec and so on  

Hi Everyone! I have a base with 30 tweets that I'd like to automatically publish everyday. Once I get to the end of those 30 tweets, I'd like to start from the beginning and repost them. I am familiar with the "post a tweet" automation provided by airtable, but I'm unable to find out how to make it restart from the top once it reaches the end of my base.Has anyone figured out how to do this?

Hello, I want to link 2 records if they are scheduled in the same week, and then create a new record in a table that stores those linked records. I also want the original 2 records to have the newly created records ID. My goal is to do the following: If two records are in the same week, create a record (let's say record A) in table X, then update those two records with record A's record ID# If anyone could show a visual example on how they would do this that would be highly appreciated as I work better with visual learning.  

Hello,In one base I've created tables of instructors, students, classes, locations and training dates and linked them.  I've automated signup genius to populate my students table when someone registers for a course.  I've set the total number or students for each class and a calculation of % of full.  When it reaches 100%, i have an automation update a record on the class page indicating it's full (although I'm not sure that's really necessary).  When that happens I want Airtable to email (through my Outlook) a roster of the students assigned to that "full class" to the two instructors associated with that particular "session" or individual class.  I cannot figure out how to do that. 

I get served a list of 500 company numbers every weekday at 5 am, i need to have available information for my sales agents by 7.30 am in the morning.This i solve by using an API that collects the information from a government website where i come from. It's the only source available.The API is limited to just one company per request.I have solved this code wise using a for of loop which loops over my table, sends an api fetch request based on the number, then inserts the information, then starts the next loop.The issue I'm facing is the limit of 50 fetch requests pr automation.The only solution i can come up with myself at my current code/situation is to make the automation limited to 50 runs pr automation, then make 10+ scheduled weekday runs.I have access to 50.000 monthly automation runs so that's no issue, but there has to be a better/ More elegant solution than this?Here's an example API link:https://data.brreg.no/enhetsregisteret/api/enheter/929135180/roller?The number marked in

I have an automation which makes a Facebook Pages post.Trigger: when a record gets a PNG added to an attachment field.Action: Make an FB Pages post with the attached PNG file.Odd thing is that the trigger and actions all work in manual testing mode, but when left on autopilot they don't....though occasionally one might (see the bottom of the run history in the pic)Anyone have any success making FB Pages posts w/images included?Any idea how to make an image file type that live automations are happy with?Thanks!

Hi all,I need to create from a single record, multiple record, in the same table. If in one field there is a specified keyword, I would not a single row but 2 or more records. Is it possbile?The "source" record could be added from a form or if is it possibile from an email.Thank you very much.Luigi

I am writing an automation script that takes an input X. I lookup X in a table, and then go on and do stuff with what I've found.But if the lookup comes up empty, (no qualifying records), I want to exit the script. I could do this:if (X was not found in table) {    output.set("error", `${X} was not found`)} else {    // do stuff}But this gets messy. If I need to lookup X, and then Y, and then Z, then each additional lookup results in more indentation of my code. What I'd like to do is this:if (X was not found in table) {    return from script}"return" isn't allowed. Googling has not provided an answer.Is there any way to do what I want?

Good day! I want to link certain text lines from a web-site (say, Cambridge dictionary (https://dictionary.cambridge.org/dictionary/english/do))and automatically create word definitions in my spreadsheet. Is there such an option in AirTable or Bubble.io? Thank you

I'm an admin on 300+ Facebook Pages. When I try to select a page to tie an automation to, I receive this error message: "Facebook returned an error. Error hashes: rm0604cd3138feed20, ufm7db6c9a23a36fa83"Anyone else encounter this or know of a workaround?

Hey friendsI want to perform such automation in Integromat (MAKE) ->1. A lead enters via a webhook from an Elementor form.2. A check is being made as to whether the same lead exists in my system based on 2 parameters:Once by email -> not found?Going to check the phone.3. If the lead exists -> it is updated according to what I choose.4. If the lead does not exist -> it is created.how can i do that Something seems wrong to me in how I work with it.I would appreciate your help, friends.Thank you!  Search Records: 

Hi all! Hoping you can help me with something. Context- I need to be able to load a template via an interface (therefore, can't set up a button to do it). There is a handy little extension in Airtable called "Create records for multiple templates" that basically sets up a script for you to achieve this. However, because I need to move this into an automation, and the automation action "run a script" can't communicate with the extensions dashboard, I need to convert the dashboard script to work for automations. I've updated the //define fields from script settings portion, but I haven't worked out how to hard code in the part where it wants user input on which record to choose. I've pasted the script below, and the lines (I think) that are the issue are 24-34 (under the // Select parent record to create child records & select type section). I basically want it to run the script on the record in which the automation is triggered by. So in this case, there is

Hi there. I use (or used) an automation via a check box to create a duplicate quote record when e.g. the client wants to make amendments to the line items of a quote and I want to keep the existing quote. The duplicate record automation replicates a few fields from the previous quote and copies them to the new quote record as per the image below: The problem I’m having is that the Line Items table’s primary field is a formula field so it looks like the automation doesn’t like it and spits out the following error: “Field “Name” cannot accept the provided value: Cannot modify a computed field.” This automation has actually worked before so I’ve no idea why it’s not working now or something has changed somehow. Is their any way to resolve this or shall I just forget the idea of being able to duplicate this record within the structure of my base? Thanks! Dan