Development & APIs

Does typecast only work on .create? What if I want to update a mule-select field in update? base('Sites').update([ 79 { 1 "id": recId, 2 "fields": { 3 "siteStreetAddress": {!!placeDetailsObj.street_number ? placeDetailsObj.street_number + ' ' : ''}{!!placeDetailsObj.route ? placeDetailsObj.route : ‘’}, 4 "siteCounty": {!!placeDetailsObj.administrative_area_level_2 ? placeDetailsObj.administrative_area_level_2 : ''}`, 5 "siteState": `{!!placeDetailsObj.administrative_area_level_1 ? placeDetailsObj.administrative_area_level_1 : ‘’}, 6 "siteCity": {!!placeD

Hello. I’m learning the scripting block and not a programmer but hope to get my feet wet. I have taken the basic script to “select a record” and added that to a button called COPY. // Change this name to use a different table let table = base.getTable("Table 3"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); if (record) { // Customize this section to handle the selected record // You can use record.getCellValue("Field name") to access // cell values from the record output.text(`You selected this record: ${record.name}`); } else { output.text('No record was selected'); } But now I want to use the record selected to copy Field 1 (which is a lookup field) into Field 2 which is just a basic number field. Can anyone point me how to “copy” data from one field to the other?

Pretty new to Airtable and Javascript I’m trying out Airtable to see if I can organize my organizations data better. When importing new data to our database I would like to read from many text files, collect the data from the files (which unfortunately isn’t organized too great), and insert the data into tables. Is there a way to queue multiple text files to read with fileAsync? There are hundreds of files, so doing one at a time is not useful.

Wonder if anyone has ran into this issue before? I’m trying to hit my API from a scripting block. I can fetch a request with the relevant data but struggling to find how to secure the request: is there a way to store/generate secrets in Airtable? I thought about hashing the Session and sending as a header but I cannot import a crypto package or similar in the scripting block if not, what is good way to secure requests coming out of a scripting block?

I just recently released the first custom block for our base, and I would like to start by saying THANK YOU! It is very exciting to be able to create custom integrations so easily. After releasing a test block to demo the process I realized I can’t find a way to either rename or remove blocks that are either unused, or replaced by another Block’s functionality. Is there a way to remove custom blocks at this time, or is this an artifact of the Beta status of the platform?

Hi everyone, just started using Zapier with Airtable and would like to download ALL videos from a youtube channel I’m interested into my Base. Is this possible? I was able to set-up a zap to download NEW videos, but what about all the others? Are there no zapier solutions I could implement? thanks in advance for reading this post Cheers

Hello, I would like to check the state of my app inside my block using React DevTools (Redux). When I open the block in fullscreen the chrome extension icon is enable, meaning it detects a react app, but I don’t see the Tabs “Components” and “Profiling” like I would expect. Did someone manage to make it work ? Thanks

Hi, I am using the API to create records in aritable, but cannot figure out how to create a new line in a long text field. I am currently passing a string with “/n” in it at the point I would like a new line, but all it does is show “/n” instead of creating a new line. Any tips appreciated.

I’d love to be able to create mention tokens with the api because it would allow me to define a simple workflow system. :slightly_smiling_face:

Hi all! I’m still pretty new to scripting, but came across a problem that feels like it should have an obvious answer. I would like a user to be able to update a number field in my base via some inputs in the script, however the input.textAsync function throws an error because the string can’t be assigned to that field type. Aside from changing my field to a string, is there away to change the input type to a number in the scripting block? Thanks!

Hi, I have a list of clients that can be in multiple markets (6k markets). The markets column is pulling form another table. With the FilterByFormula, I need to create a filtered list of all clients in a specific market. The problem is that the API does not include in the results records where multiple markets are listed in the Markets column. For example, client A is in Paris, client B is in Paris and Madrid. The final list will only show client A. How can I get client B on the list too? If anybody knows how to fix it that would be help a lot.

The “To-do list” tutorial opens with In this 3-part tutorial learn how to build a to-do list block that shows a list of tasks from a table and allows you to check them off when done. The supporting screen recording demonstrates this functionality. However, the tutorial only covers displaying the contents of a table or view. There is no information on modifying the table (via a checkbox or otherwise). A subsequent guide does discuss writing to a table though it’s not in terms of the “to-do list” block.

Hey there, Question to the airtable team - since the hackathon deadline has passed, if I fixed a bug or improved something in a block that participates in the hackathon, can I update the block installation in the demo base I shared with you guys as part of the submission? Ronen

I would like to prompt the user to upload a file which I would like to add to an attachment field on a record. From what I have read, the file must be uploaded first and I cannot do something like this: let preview = await input.fileAsync(‘Please upload the new Audio Preview’); await table.updateRecordAsync(record.id, {“Audio Preview”: preview}); I just wanted to make sure my understanding on this input.fileAsync is correct and how other people have handled this. Is there a way to upload the file and grab the url from where I uploaded it or is it better to just display the record and let the user upload it from the record. Thank you, I really appreciate all the help!

Hey, The cli used to be able to detect that ports are busy and have block run listen on 9002, 9004 etc, so I could run multiple blocks in parallel in my dev env. It stopped doing that. Right now it just prints that it listens on 9000 again, even though first block run listens on it. I don’t know if it’s a cli version thing or an OS thing (I recently upgraded to WSL 2). My current env: WSL 2 Ubuntu 18.04 blocks-cli - 0.0.52 Thanks, Ronen

Hello all, Forgive me for what seems like a silly question, I’m new to this and can’t figure this out. I would like to launch a website when I click a button in the scripting block. Is this possible? let purpose = await input.buttonsAsync( 'Are you Creating a Record?', [ {label: 'Create', value: 'creating'} ], ); if (purpose === 'creating') { //LAUNCH URL HERE }

Part of the workflow I’m trying to build is to book hotel accommodation. Ideally, once the script reaches a certain point, I would like to launch a new browser window or popup - passing url parameters to a hotel booking site. The user will then select the accommodation within the booking site, which will show them a booking reference number. The user will copy this to the clipboard, close the window and return to the script, pasting the booking reference into the field waiting for input. Hoping this can be done easily?

Hi Airtable! I have over 2,000 database records that I would like to use the JSON parse module in Integromat. Do I have to manually set up the JSON format for each record? Or is there an automatic way of doing this? Or is this not the right module for over 2,000 records? Thank you, Mary Kay

Hello We have an existing integration with large Airtable sheets. Our use case needs to react to the operation of deleting records in Airtable. The way we do this at the moment is by listing all the records and comparing them to previously saved list. We’re wondering if there’s any way of doing it that would not require making a full set of paginated request to get deleted records?

We’re advancing into the last week of the custom blocks contest (Submission deadline: July 6). This will be our last AMA in this series - with a twist! We’re turning it around to you: Ask You Anything (AYA). We’d be interested to hear from you about one rose, one bud, and one thorn of your custom blocks beta experience so far. To be more specific: Rose: Something that delighted you about the platform Bud: Something new that the custom blocks platform unlocked for you, whether it’s a new workflow or new value in Airtable Thorn: What is your top feature request or challenge that you ran into? The thread is open for the next week and the 3 most insightful posts will win a $40 Amazon giftcard. Feel free to keep it under a sentence each. A member of the Airtable platform engineering team will select the winner at the end of day on Thursday (7pm PT).

I have a table with an audio preview attachment as a field and I am trying to use the scripting block to get this field for a record. I can display the URL for a giving record with the code below but I am wondering if there is a way to be able to preview it from the scripting block, maybe with an audio player even? Any help would be greatly appreciated! let table = base.getTable('Music Collaborations'); let view = await input.viewAsync('Sort By', table); if (view.name == 'All Songs') { let query = await table.selectRecordsAsync(); output.text('All Songs Selected'); }else if (view.name == '5 Star Songs') { let query = await view.selectRecordsAsync(); output.inspect(query.records.length); output.table(query.records[3].getCellValue('Audio Preview')); }

I have been successfully sending data from Parabola to Airtable via the API export, but now I have been receiving 422 errors saying: { “error”: { “message”: “Unknown field name: “Moda ID””, “type”: “UNKNOWN_FIELD_NAME” } } However, “Moda ID” is a field in my table. Does anyone know why this might be happening? Has Airtable changed something in their API?

Hello, I have a base designed to track some packages shipped in a “Packages” table. Some of these packages may be linked to the same shipment, as signified by a “Shipment ID” field. I’m working on creating a script that passes only unique shipment IDs to a “Shipments” table, so that I can link packages to their respective Shipment ID and roll up values from the “Packages” table for some further analysis. Currently, with my script, I was either hoping to only put Unique IDs into an array, or, from an array I pass ALL the IDs into, create a second array that only captures the unique IDs, and with that, I can create records in the shipment table that I’ll link with either the same script or a different one. The issue I’m having is that, when I use the output.inspect() or console.log() to view the array, the array displays as [Object, Object, Object, …] and when trying to pull only unique values, even though they might share unique values, it treats them all

I have a base with several collaborators. Some are listed in columns with collaborators and some aren’t. I want to use the api to retrieve a list of all collaborators belonging to the base in question. Is that currently possible?

Hi All, I’m having some trouble implementing AirTable API into a C# application. I am trying to create a web application for my operations team and I would like to use the data they are posting in Airtable.com to our asp.netcore MVC web application. Unfortunately I’m having some issues implementing the API into the project folder. In what folder would I place the API>? Also if I’ve already downloaded the Nuget package do I also have to create a class library for the github source files or will the nuget package be enough as long as I remember to call it with “using”? Any help is appreciate thanks again.