Automations

  console.log(`Starting...`); let table = base.getTable("Imported table"); let inputConfig = input.config(); let last_name_array = inputConfig.last_name.split(' '); let formatted_first_name = last_name_array.shift(); let formatted_last_name = last_name_array.join(' '); console.log(`Customer ID: ${inputConfig.customer_id}`) let response = fetch(`https://api.shop-ware.com/api/v1/tenants/xxxx/customers/${inputConfig.customer_id}`, { method: "GET", headers: { 'X-Api-Partner-Id':'xxxxxx', 'X-Api-Secret':'xxxxxx', 'Accept':'application/json', 'User-Agent':'PostmanRuntime/7.34.0', }, credentials: 'include', }); let body_response = await response; let json_response = body_response.json(); console.log(json_response); await table.updateRecordAsync(inputConfig.record_id,{ "First Name Formatted": formatted_first_name, "Last Name Formatted": formatted_last_name, "Business Name": inputConfig.first_name, })  The last console.log returns an empt

Hello!I am just starting out with AirTable and I am trying to create an automation that when an item is moved to the status "Backorder" (this should happen when the field "B/O Qty" is greater than 0) in my "Open Orders" project, it is then duplicated into another project called "Backorder Clip". Once the order status is not "Backorder" anymore (or the B/O Qty goes to 0), it should be deleted from the "Backorder Clip" project and moved to the "Not Started" status in my "Open Orders" project. I can't seem to figure out exactly how to achieve this. Any help is greatly appreciated. Thanks so much!

Automation set up was.Step 1: When a record matches a condition.Step 2: It will update a field which is the "Client Portfolio Record" (this is a linked to another record field to a view called Client Portfolio)This automation was just working fine before, but there was a change happened on the default column in "Client Portfolio view" which caused the issue. If you suggest putting it back to the normal setup, I can't because the default column in "Client Portfolio View" which is the "Portfolio Title" should be in formula type now. It should also remain as default column.  Is there any way to update this automation even if the Portfolio Title is still a computed field?

We have connected our event registration from Wordpress to an Airtable table through Zapier and it was working for a while until it started glitching.. After a while we only started seeing part of the registrants, while the other part is not showing in the table, although we see it in Wordpress. We tested it out and got this screenshot.. The test go through as not an issue while this keeps appearing and we keep getting notification emails that something went wrong. Thanks everyone

Hey everyone,Running into a bit of a puzzle here. I'm managing our subscribers table and a CRM for member benefits. Both are on separate platforms, not even in the same database. Wondering if anyone has experience with a double synchronization setup between two tables on different platforms? Is that even doable?Would love to hear your insights and tips if you've tackled something similar.On a different note, www.startupbenefits.eu – offers some pretty neat resources like $750K in perks, investor databases, pitch decks, legal templates, and more. Might be worth a look if you're in the startup game.

I have a button that I would like to trigger two tasks: 1 - trigger a webhook that passed the data to zapier (done) 2 - automatically update the value of a single select field to ‘true’ While the webhook script runs when I click the button, it seems that the other script I am using (to update the single-select) wants to take in a user input every time and it does not run automatically. Is there a simple way to set the value of a single-select field automatically to true without me having to specific the field and the value every time with a script?

I am trying to create an automation that sends an email or a slack notification when a record matches conditions when X is one month from now. However, I received the following message. I have included two screens shots (a) the trigger and (b) the table and conditions chosen. Can anyone advise me to how to fix this issue?  

Hello, I am trying to create an algorithme in AIRTABLE using the script automation. I have 3 tables : Mission_Request, Cookers and Companies. My script compares all the pattern in both Mission_Request (wich is connected to Companies table) and Cookers and when there is a match, it is supposed to fill the "MatchingCookers" cell in MissionRequest with the Cooker best match. My script doesnt' have any type of error and i don't have any kind of mail error. My script is active. My journal log don't have any kind of error. Does anyone have an anserw ?? It will be very helpfull. Thanks !!! And i would like any advice from people who have made an algorithme in airtable!!! Thank you! 

I am trying to assign 4 different users records as the come in.  I found this code const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"} ] const chosenOne = collaborators[Math.floor(Math.random() * collaborators.length)]; output.set("collaborators", chosenOne.name) My problem is that it doesn't exhaust the 4 names before repeating.  What do I need to do to this code for it to go through all 4 options and then repeat?

Hi,I am running into issues. I am not a coder at all and I ask GPT to help me. Usually, it does a great job in writing some basic scripts and it has already created nice solutions with scripts. But this time, I am running into issues. I have a huge database and I was asking GPT to write a script to merge duplicates. When I do it one by one, it works. But as soon as I let it search the whole database, it crashes and mentions that it's taking longer than 30 seconds. I was trying to break it down into smaller views, but the problem is that it should check all the data actually, and searching records is also not an option since that's limited to 100 only. Any idea would be awesome.here is what i got from GPTOption 1// Access the table let table = base.getTable("Online Stores"); let query = await table.selectRecordsAsync(); let records = query.records; // Define a map to track duplicates let recordMap = new Map(); // Identify duplicates based on 'merchant_name' for (let record of records)

Hello Airtable Community,I'm encountering an issue with an automation I've set up and would appreciate any insights or advice you can offer.Here's what I'm trying to achieve: I have an automation with two steps. The first step is a "Create Record" action, where a new record is added to a table. The second step is a script that should modify a field in the newly created record.The problem: In the script part of the automation, I'm trying to access the ID of the record created in the first step. However, when I run the script, the variable that should hold the record ID (createdRecordId) is coming up as undefined.Details of my setup:The "Create Record" action seems to work fine, as a new record is indeed created.In the script, I'm using input.config() to access the record ID, like this: let inputConfig = input.config();let createdRecordId = inputConfig.recordId;But createdRecordId is undefined during the script execution.Additional Information:When I check the run history of the aut

Hello! I am trying to automate the following process: when a file is uploaded to a specific Dropbox folder, a new record is created in Airtable with the file attached. This works fine, but there is no preview in Airtable. I have created the following automation in Make (formerly Integromat):Here are the details of each step:  Below is what is seen in Airtable. As you can see, no preview is shown.I have already done some troubleshooting myself:I have tried uploading manually. This works fine and a preview shows up.I checked the limitations in Airtable's documentation: the image is not more than 1 million pixels. The image is uploaded to Airtable as .png, and not as a .zip file. I currently use Chrome, and I have tried using Safari as well.I have added another contributor to the Workspace, and they cannot see the preview either. The error message I see is: "Previews for this filetype are not available".Does anyone know a solution to this? If I cannot get the previews

   let table = base.getTable("Cashflow Grid (Sales Pipeline)"); let inputConfig = input.config(); let record = inputConfig.record; let mmyy = inputConfig.mmyy; let i = 0; const table2 = base.getTable("Cashinflows") const fieldName = "Name" const queryResult = await table2.selectRecordsAsync({fields: ["Name", "Record_ID"]}) const ids = queryResult.records.filter(record => ( record.getCellValueAsString(fieldName) == mmyy )) console.log(ids[0].id); output.set('Cashinflows_Record_ID', ids[0].id); let id1 = ids[0].id; console.log(id1); for (let records of record) { let recordId = record[i]; console.log(recordId); await table.updateRecordAsync(recordId, {'Cashinflows x 1st AZ': [{id: id1}],}) i = i+1; } console.log(record);    

Hello community,I am trying to automate the following problem:I have a stock table "Stock" and a catalogue of products "Catalogue". Not all products from the Catalogue are listed in the Stock and the Stock changes on a regular basis. The availability of products from the catalogue is linked via "Link to another record" field to the stock the value used for this is the "articlenumber" So when the stock changes (e.g. we have a new product) I need to manually select the article number in the linked field for the new product.So I created an automation that runs daily at 8:00 am and runs a script that is supposed to copy values from field "Articlenumber" to field "Articlenumber-linked" in the catalogue if a record with this article number is found in the stock. This is my script:  // Get the current tableconst currentTable = base.getTable('Catalogue');const linkedTable = base.getTable('Stock');// Load all records in the current tableconst query = await currentTable.selectRecordsAs

I am trying to create an automation. I have succesfully created a trigger for when a "Delivery Date' gets updated however when i go to create the action, it will not allow me to select the trigger as the input.  Essemtially, when the delivery date is updated, i need the "Location" to update to "Out". Any help would be appreciated. Thank you

I have a field where an agent selects a status and it will show last modifed by his name.But when another guy redo the same thing, it is changing to his name. How can i restrict modifcation of a field which is already done by one agent.

I need to pull in the airtable table into Wix so that I can have visibility controls on wix. Is this possible?

I have a field defined as Currency however when I add that field to the Message section of an email that I am creating from an Automation, the value does not appear as Currency. It does have the decimal point for the cents, and I can easily add “$” as part of the preceding text, but I would really like to see the commas that are part of the defined format on the field. Any ideas?

Hi EveryoneI have been trying to link my airtable base with Make.com via a webhook that then uses a 'get a record' module to view what has gone into the base and can change the fields via chatGPT and place it back into airtable with the 'update a record' module. The webhook is working fine and both of the airtable modules can find my base. my problem is that when I try to run once on make.com the process stops at this 'get a record' module and gives the fault code:BundleValidationErrorValidation failed for 1 parameter(s).Missing value of required parameter 'id'.My current assumption is that it is to do with the 'recordID' variable within airtable and I have tried looking into a lot of other possibilities but I have hit a wall now and don't know what else there is that I can try to change to make it work as it is intended. Any help is greatly appreciated.This is the code that I have used in the Automations section:let url = "MyURL"; // Webhook URLlet&n

Hi, Is there a way for me to automate the following:1. a team member is @mentioned2. The @mention would automatically be placed into the "Mentions/Comments" TableThe reason I am trying to do this, is because I am trying to build an interface/dashboard for each team member where they will see their daily calendar; tasks assigned to them and any comments in which they were @mentioned. Hope this makes sense.

So I have two tables the "products" table and the "Wholesale Products Sync", the trigger of this automation is when a field is unchecked in the "products" table I would run this find records action: then I would run this script to delete the record in "wholesale products sync" but I get an error:  

There are a few options to fill in external forms by filling them with the data coming from Airtable. I mentioned earlier Selenium https://www.selenium.dev/ but it has a high learning curve and working with code.There is another more user friendly app Katalon based on Selenium https://katalon.com/ , but still requires working with code and this requires manual loading of CSV.There is Axiom https://axiom.ai/ which is quite good but pricing is quite high to get Make or Zapier integration, although the lower tear works with Google Sheets.And then there is https://browserflow.app/ which works via Google Sheets The main issue I have is how to upload attachment images from Airtable to the web form. I have pictures I want to load to a web-form and that is not easy.Anybody doing something like this? What do you use?

Is there any way to be notified when a base has no new records in a period of time.I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.Anyone know of a way to do this?

I saw elsewhere that Airtable-limited markdown is available for Automations (possibly only for emails? - not clear), but I can’t seem to get the markdown to work for Slack message automations. :loudspeaker: : The Accounting base in :airtable: has been updated by  [Record (Step 1: Trigger) | Field values | By | Name] with the following release notes: ‏‎[Record (Step 1: Trigger) | Field values | Description ] So that the message in Slack looks like this: :loudspeaker: : The Accounting base in :airtable: has been updated by frozenforum with the following release notes: Created a new Client Companies table Converted Client Company field to be a link to Client Companies Moved company groups to Client Companies table But instead, the Slack message looks like this: :loudspeaker: : The Accounting base in :airtable: has been updated by frozenforumwith the following release notes: 1. Created a new Client Companies table 2. Converted Client Company field to be a link to Client Companies

I am using an automation that uses a script to append a record to another table's linked field. My code is shown below.This is not working however, as the record.getCellValue('Worksheet: BOM") is returning an array that has the format ("string") instead of the format (id: "String"). Is there any way to fix this?This is my error message:No overload matches this call.The last overload gave the following error.Property 'id' is missing in type 'readonly { id: string; name: string; }[]' but required in type '{ id: string; }'.(2769)env.22.d.ts(5964, 43): 'id' is declared here.env.22.d.ts(5959, 5): The last overload is declared here.