Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
I am attempting to setup a workflow for a Callback system for my Sales calls. My plan was that when a record in my Callback List View inside my Touchpoints table was updated to have the Call Result column be set to Voicemail select - that it would au...
Admittedly, I'm super new APIs in general, and I'm using ChatGPT to generate the code. So, if you're looking at it and you're like 'you and chatbot are wrong about everything and this can't be done', please let me know.Here is my use case:Imagine I a...
Hi there! So, I have a funny case. I wanted to connect to a webhook and grab some properties. I needed to create a script since I had nested data. I did that and noticed that I can't use updateRecordAsync() procedure inside scripts in automation. I t...
We utilize the QR Code Extension in our data base & am looking for simple automation to trigger said extension when a form is submitted. I have all the steps down but the trigger from the automation to hit the manual button on extension. I expect it...
Hello! I am in desperate need of help. I can't figure out how to "filterByFormula" in the following script. I am trying to send a JSON payload via webhook to MAKE.com. I only want to send records where a given field is blank. I have tried multiple v...
I am new to scripting & know that I dont know exactly what I am doing however I like to learn & am kind of learning on the job taking it 1 step at a time.When creating a script the following code will allow the user to choose which table & field they...
I'm not familiar with Javascript.Looking to make a button that will start a script to generate an alphanumeric string that's 8 characters long. The code I found on Google to generate a string is:function makeid(length) { var result = '...
I want to make an automation that runs a script, and in that script I'd like to call an ajax function (either with jQuery somehow or with XMLHttpRequest() etc.) to grab some external data from a Google calendar. Is this possible? I've searched around...
Hi all!I'm very new to scripting and I have this code that was working before until recently. When I run the code I see TypeError: Cannot read properties of undefined (reading 'getCellValue') at main on line 271Line 271 is let client_apps = glo...
I've run across a script in our base that uses this code:let view = await input.viewAsync("Pick a view", "Projects");Our "Project" Table has 100+ views organized by sections, is there any way to modify the code to limit the input choices to a specifi...
Hi, I'm trying to write a script that will extract a video link from a field, extract video details from that link, and then automatically input those details into specific fields in a table. However, the script is not functioning as intended. I woul...
Hi guys,I'm relatively new to scripting, so I've mostly used scripts I find in this amazing community and adapted them to my tables. Once such script I've tweaked to create junction tables. It automatically creates entries in a junction table when a ...
I want to help make my company better with scripts and extensions. However, I am not fluent with Github or Javascript.I am a quick learner. I think that there are some ideas that I have that could be accomplished through extensions and scripts. I ...
Can you help.I need to replace a linked field with a string - both in the same table. Here's my code: The problem is on line 23. If I run it as the following it works fine. However "YSW CC2" is a text field.23 await mainTable.updateRecordAsync...
Hello, anyone availeble to help with basic authentication for vidaxl api. I am trying to get products data but really struggling with the authentication // define the request urllet base_url = "https://b2b.vidaxl.com/someendpoint";let authUser = "som...
Hello everybody,I have a table that's thousands of lines long, with a column called "Formula" which contains small string expressions like:amount = salary * 0.11;What I'm trying to do is run this string in my code, so that it updates the `amount` var...
I have no experience creating scripts and am looking for some assistance to create one for my base. I thought that I could just utilize automations to update records but I have had no luck getting those to work properly and after searching through th...
Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their r...
I'm trying to generate some content using OpenAi's new ChatGPT API and I'm having an issue with updating the record field in my table with the response from their API. I have no idea why but for some reason I can't update the Long Text Field with the...
I'm looking to see if the solution below is viable to develop as a script inside Airtable.We use a loans table and a transactions table to manage a ledger in Airtable. In the transactions table, users enter either capital advances (loans out to clie...
