Development & APIs

Hey folks, I’m working on a scripting action step for an Automation. It feels like querying the whole table just to search through the records is inefficient. I’m a frequent user of the Airtable API and am very used to simply asking for the record object by its ID. Can I make this simpler? I’m literally only trying to retrieve the field values of records that are linked to the record which triggered the automation. The Automation builder UI doesn’t allow for “looking up” fields from linked records. // Get collaborator email from Client record. let clients_table = base.getTable("Clients"); let queryResult = await clients_table.selectRecordsAsync(); // get all records in Clients table let client_record = queryResult.getRecord(`${inputConfig.client_id}`) // find the one with the client_id from input output.set("am", client_record.getCellValue("Account Manager").email) // Get Site record linked to the Project record let projects_table = base.getTable

I am using curl via command line to try to isolate a single record ID from a list of records retrieved via GET. I only have data from one of the fields in the record (ie: “File Name”:“MyFile.txt”), I do not know what the record ID is for this record. The intent is to isolate and use this record ID to perform another GET which just contains the data from the corresponding record. What is the best way to go about isolating a record ID via curl/ command line? Or maybe there is a way to isolate the entire single record from the list instead of using the record ID to do another GET?

I am working on an automation. Is there a way to have the script select only the record that triggered the automation. I am trying to create a ‘Project Number’. When a new record is added I want to run some script to give it a project number based on some actions (including grabbing some info from another table). Once I have that data I want to use to update the Project Number field, how do I get the script to select the record that started the automation? I see now that I can include a variable from the trigger step. what is the syntax to use this variable to update a field in that record?

Hi! I am new to scripting and thought this would be easy but I’m not getting it… I have one table, and want to find all the records that have the minimum value for FieldA (there could be multiple). I actually want to find all the records that have the minimum value for FieldA, and then out of those the ones that have the max for FieldB, and then add those records to the latest row in another table as a linked record. But for now I’d be happy just figuring out how to find the min value for FieldA :slightly_smiling_face:

Using the new automations feature, I am trying to trigger an Integromat webhook when a new record enters a view. However even though I have configured an input variable, and it is processing just fine, it won’t parse into the webhook URL. I’ve attached some screenshots which hopefully explain what I mean. The code I’m using is: let data = input.config(); let response = await fetch('WEBHOOKURL?id=${data.ID}'); console.log(await response.text()); The test output shows the variable is picked up: However the webhook receives only the code: Would love some help - I’m sure I’m missing something very simple here…

I’d like to use the autoComplete property on an Input in my custom block. Has anyone played around with styling an Airtable-y popup to go along with the feature?

I am quite new to airtable and looking to make an order form for work. The data will be coming from an API of a materials company. What is the best way to add this data to airtable?

I have encoded api from codepen and got this https://api.airtable.com/v0/appdsdsknfsf/Quiz?maxRecords=10&pageSize=1 and i used it with ?api_key=YOUR_API_KEY , it shows error please help me to solve it.

Hi, so I went to https://airtable.com/api and I can’t spot the documentation anymore. Where is it now? Thanks PS: attached an image

I have a table that gets a partly populated row via IFTTT at the end of a 3D print job. The table has a script block that parses information out of the supplied data to fill in other fields in each row (quantity, object printed, material type). I want to use this to track the output of a distributed print farm making PPE. My question is whether there is any way to periodically trigger the script to run either internally or via some external tool like Zapier. All the external tools I’ve found only seem to create/delete/edit records and it doesn’t seem like internal script triggers are supported yet. Thanks!

I’m not great with Scripting, but I can struggle my way through sometimes. I’m trying to get the day of the week from a Date field type. Any suggestions on how to accomplish this? Thanks!

Hi Airtable community, I’m just wondering if anyone succeeded to connect Airtable API with UI Bakery (nocode UI builder)? All the HTTP requests I’ve made fails and I can’t find why. Thanks for your feedback.

Hi Airtable Community, I’m running a boutique Headhunting Practice, and am a recent convert to Airtable as central tool for Recruiting (Candidate DB), Marketing (Prospective Client/Candidate DB), and Sales (Client & Deal DB). That said, I see an awesome opportunity for someone who’d like to upgrade the Email <-> Airtable workflow and overall CRM-like functionality of the platform. Sales & Recruiting is a communication business -> everything revolves around the messages coming into your inbox, and being able to process them quickly, while noting what you did so you can know where you’re at with a pipeline of 500+ candidates and 50+ potential clients. Being able to operate from Gmail without having to switch between windows to the CRM (Airtable) to edit and update contacts is a big time saver. Time is money. My favorite CRMs in the past generally have had a Gmail integration. Usually, it looks like a pane that pops up inside Gmail on the ri

Are items in an Airtable view that is embedded in a website searchable by search engines (such as Google)?

Hi I have 3 tables and I created a script that fill some columns across the first table with data from the others two tables (it is a kind of manually link). It works fine. So now I created an automation to run this script when a record is created in the first table. But it is getting too long because my script run across all record. For the script used in automations, I would like to run my code just for the new record. So is there a way to get just the new record that triggered the automation to avoid run the code for all record of table every time?

How can I do to get data from a specific view as a Restful API in Airtable?

I’ve set up a few automated scripting actions using the beta automations features but keep receiving the same error message when I try to run the automation. The same script runs without issue in the scripting block, so I’m not sure how to resolve this. Any pointers? I’m also a JavaScript novice.

Hello everyone! I’m having significant challenges with getting an automation to run on a schedule. Airtable says: " Can I set up a script to run on a schedule using Automations? At the moment, there isn’t a built-in way to set up a script that runs on a regular time-based schedule (e.g. every day at 9am). A workaround is to use a time-based filter on a view." However, the time filter doesn’t seem to work very well for more frequent than daily. I was able to get ~ every minutes, but I was hoping to get something more real-time. To test the concept, I made a table where the first column is the “age” of the record using the following formula: DATETIME_DIFF(NOW(),CREATED_TIME(),"seconds") I then set up the automation to trigger when a record enters a view which filters all records newer than 10 seconds. The automation adds a new record to the same table. In theory, the automation should be running ev

Im trying to expand the report example, to make my own custom report. However I’m completely stuck on filtering an array of records that contains a specific name. I’ve tried a few different things (commented out below), but I don’t seem to get it to work. I have a table called ‘report’ in that base there is a field called ‘names’ and I want to filter all away all the records that does not contain the value ‘Dan’ in my names field. I hope someone has time to help an aspiring JS developer. let tableReport = base.getTable('report') let filter = 'Dan' //loadReportRecords let reportRecords = await tableReport.selectRecordsAsync(); //let filteredRecords = reportRecords.getRecord(reportRecords.recordIds).getCellValue("names") //let filteredRecords = reportRecords.records.filter(record => record.getCellValue("names")===filter); /* let filteredRecords = reportRecords.records.filter(function(reportRecord){ return reportReco

Hi, I need some help please. I use integromat webhook to create new document from existing google drive document for a new client. The trigger is button field in Airtable. When I activate the trigger google drive creates new document for all the clients in the base. How do I set up to have drive create a new document only for the client/record I have selected in Airtabe. Thank you for your help. Pjero

I’ve been accustomed to using Zapier to do some pretty powerful stuff with my Airtable bases. Was super excited to see Automations come out. Would love to hear about the roadmap for that feature. I am currently building some no code apps and would really like to know when I would be able to find a record via automations and then update it. It will be a gamechanger.

Hi, while this Airtable Scripting is a good start. Is there any way to get the last logged in date or update the sharing permissions the collaborator might have on the base? Thanks, Nigel

A few months ago, we announced some unstable APIs for creating tables, creating fields, and updating field options using the Custom Blocks SDK. As of last week’s new release of the SDK (v0.0.54), these APIs have been marked as stable. These methods include: base.createTableAsync() Creates a new table in the base with specified name and fields table.createFieldAsync() Creates a new field in the table with specified name, field type, and field options

New to script blocks. I’m wondering if it is possible to present a date/time selector when the script runs? I’m using a Button to call a webhook script, and would like to prompt the user for a time. Currently I have a time selection field next to the button, but would prefer a nice popup on execution. :grinning_face_with_big_eyes:

I need to be able to calculate the number of working days between two dates determined in “Start Date” and “End Date” columns. I know the DATETIME_DIFF formula exists, but it includes weekends and public holidays – I need only working days to be calculated. Is this something that can be achieved with a Script block?