Automations

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

HiI have an automation that transfers the details of the record to a new column in Google Sheets.I want the first column to write the number according to the report adders. That is, someone else joins Google Sheets - it writes the number 2 next to it. After someone else joins, it writes the number 3 next to it.Thank you! 

I have a project schedule. When I change the end date on Task 1, I want it to automatically adjust the start date for Task 2. Is this possible via an automation somehow? In the example I added, the highlighted field would become 5/5/2022.

Hi, I'm trying to send personalized emails to my clients with a list of projects/attachments. I uploaded all the attachments in Onedrive and used the links to create an automation in this way:But when I used the grid or list, the URLs were just text, and they aren't in the bullet list format.Is there any way I can create a bullet list of real URLs that the client can just click?The "InnerJoin2" and "InnerJoin" are just text, because they are a result of an automation script.Thank you very much!

Hi,Our County Council use Airtable to record prospects for home energy efficiency work.  The local energy advise organisation uses Airtable to track the energy efficiency work done with those prospects who live in its local area. (I configured both systems)Both organisations have pro plans, but are completely separate legal entities.I need to move records between the two.  I know I could download to a .csv and import the data to the other base, but there must be a more elegant solution and I am wondering if other people have addressed this requirement.Cheers Margaret  

Hi, I think I'm struggling understanding how the Find a Record action works.I'm attempting to create a monthly reminder email that needs to include information populated from a current record. If I use the At a Scheduled Time trigger, I have to use Find a Record to pass the correct information into the automation.Is it correct that it just passes information as a list? So if you're only returning one record (which should be the case with my conditions), then it works as I need it to (for instance, using a field for a link).However, does this mean I cannot use it to populate a file in my email as an attachment? Am I going about this the wrong way?

Hi there, I copied this script from the scripting app. I tried to search in topics already but I am going around in circles and still getting errors. I want to copy two fields additional fields from my task template to my tasks. The fields are called Status and Stage. The fields are same names in both tables. They are single select. Can someone help. I added these following lines based on info I could find in topics but I am still receiving “Error: x: Can’t create records: invalid cell value for field ‘Status’. Could not find a choice with that ID or name at main on line 126”