Development & APIs

Some scripts require sensitive input such as HTTP API access tokens. Depending on how the base is shared, it may not be appropriate to store this input in the scripts themselves. In these cases, it may be preferable to prompt the user with each execution. Currently, the input.text function renders a generic HTML text input. For situations like these, it would be nice to present a password input. This would help protect users from shoulder surfing.

As far as I know, we can link to another record to connect with another table, but that would be less enough when we want more detailed data or automated them. For example, I recorded the names for each house, then in another table, I want to list the house names for each person. I cannot just display the names but select them one by one, which is of low efficiency. Is there an API to update it though Python?

I have a simple grid view data like that: and I want to filter my data by company’s uniqueness and get an array which includes list of companies by unique like ['Google', 'Facebook', 'Apple'] read Formula Field Reference but couldn’t find. I can fetch entire data and make filtering on client side but instead of getting entire data, I want to pull only array of companies. By code below so far. Thank you const RES = await db('users').select({ view: 'Grid view', filterByFormula: 'some filter should be happen at there', }).all() console.log(RES) // should return ['Google', 'Facebook', 'Apple']

Hello! I have a question about ETag usage. I make a curl request like this: curl -H 'Authorization: Bearer <My token>' https://api.airtable.com/v0/<my_app>/<some_table> HTTP1.1 200 OK ... etag: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI" ... Then I make another curl request like this: curl -H 'Authorization: Bearer <My token>' -H 'If-None-Match: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI"' https://api.airtable.com/v0/<my_app>/<some_table> HTTP1.1 200 OK ... etag: W/"10f-SnXCiqHll2qv5oY0Q+Gx4C8/htI" ... Execution time of these two requests is almost the same. I expect getting 304 Not Modified and smaller execution time. Are my expectations correct and if they are, what am I doing wrong? Any help would be appreciated!

The Scripting block is a powerful game changer for Airtable, though you don’t need to be a developer to use it. Before using the scripting block, the most experience I had was writing a couple of Macros in Excel (but even that isn’t necessary knowledge.) Now, I mostly use scripts as complex formulas that can also create or update your records on a base. I encourage you to get into scripting if you. Like building formulas Kinda sorta know what variables, arrays, objects are Understand how loops work If you want to brush up on any of these concepts, try Mosh Hamedani’s 1-hour intro to JavaScript. Mosh also has an entire course on JavaScript that, at the time of writing this, is $15 and it’s SO worth it! Why Use a Script? The Airtable team has covered this really well here, but adding my thoughts as well. Scripts pick up where formulas leave off Formulas can get long and clunky, and are sometimes too rigid for your needs - think not being able to move dates created from formulas in c

After block release, I deleted my block from Airtable. How do I get the same block back in development mode?

I’m trying to create a script that would copy a set tasks that I have identified as my “template” set for use in multi-project tracking. My script would create all the new tasks for a new projects based on the template. The template tasks have a linked field for predecessor’s to use in the Gantt block (my goal is project schedule tracking). I figured out how to copy all the template tasks and prepend those task names with a mnemonic so they are unique. In doing that, I realized I can’t create the links in the predecessor field at the same time because the records are created serially and as such many of the links for a record don’t yet exist. I want to keep the same relative linking between records to allow for a new Gantt block to show the new project schedule with appropriate links. From there I can edit the projects dates and add/remove tasks specific to that project. Here is the code to create the records. for(let record of templateViewRecords.records) { await tasks.createRecordAsy

I’ve tried using Cognito forms & Zapier to pull data into multiple tables within Airtable but it keeps joining the data into the first column of the second table. I have two tables one for requests and one for environments. A request can have multiple environments, users can choose to add as many as needed. Each environment has multiple values (columns in the table) that need to be populated. The requests are tracked for submitter while the environments handle each of the sets of details.

Hey I want to import data from Parabola to airtable, but I got an error and I don’t know why. This is the table in Parabola… And this is the table in Airtable I want to add the items that I have called “titles” in Parabola and import to the column called “name” in Airtable Thanks!

Is it possible to have a hyperlink in an input description within the scripting block? I’ve tried putting in HTML and markdown and neither render in a formatted way:

how to increase the data load time via api? i am ready to pay money

Hey! I have a question that I hope you can help me with. I am looking for a way to do the following: If input A1 is X, then input in B1 is Y. Plus I want it to happen with every new input that adds to the table (through Zapier). In my case, I have a column named ID, and another called Description. Description will be in the format of “This is an event with John” or "This is an event with Sarah… I need a way for the table to automatically change ID associated with “This is an event with John” to “John”, and that of “This is an event with Sarah” to “Sarah”. That should be done with Script Block, right? And I hit Run everytime I need the system updated? or can I do it through Formula fx? Appreciating your insights in advance.

Hi! I’m writing a custom block that is deployed to several bases, and we’re considering automating deploys. I’d like to write tests for our code to try to catch regressions and increase confidence – has anyone done this? I looked through a few of the examples on github and didn’t find any test folders, but I didn’t check them all and maybe I’m looking in the wrong place. Any recommendations for a test stack? I’d rather not reinvent the wheel if somebody’s got this working!

A few weeks ago we added the ability to upload files in the scripting block using input.fileAsync, and wanted to open up another challenge to the community around this feature. For this challenge, submit a script that uses the input.fileAsync API for a specific workflow. We’d love to see creative and useful ways for this new input type to be used! Maybe it’s a smarter importer, for example with fuzzy matching to update existing records, or a way to import Excel files with multiple sheets, or importers for other common apps that export CSV, JSON, or XML files. Or maybe it’s something totally different! The winner of this contest will win $1,000 :tada: . All submissions are due by May 8, 2020 at 6:00pm (PST). What exactly should be submitted To qualify for participating in this content, you should submit: A script using input.fileAsync in the scripting block A short video demo of the script in action A description of what the script does Guidelines on submission format Submit your

Just started using the Scripting block! My team is using Airtable to calculate profit pool for an affiliate program, part of that includes getting the sum of a field (which you can see on the page) update it on another field for all record as total number of that field (in this case sum of ‘# of hoodies’ ) and then updated on another field (‘total hoodies’ ). And then update total number of records from another table in a view (Toal # of Affiliate which is the total records from the Approved affiliate table). Thanks so much for your feedback on this! Lubem

I new at airtable, but not to BI, I actually use PowerBI. I have on airtable a bd (grid) with more than 450 rows. When I use PowerBi Or CURL to get my data, I only receive the first 100 rows, nothing more, nothing less And I don’t figure out own to get more data from the table. Thank you in advance

Currently in Airtable there’s no function provided for a standard deviation like Excel’s STDEV. One user on this community has helpfully written out the function that calculates it, but it’s rather complex. I’m wondering if the script block couldn’t be used with math.std on rolled-up values in a single property to very quickly generate the standard deviation on a set of values? I’m still verrry green at Javascript but this seems like it would work; if you agree I’d love some guidance on where to start on pulling the values from a roll-up column and using them in the math.std calculation. Thank you!

Hi! I’m outlining a bit here since as of this writing, only see a few topics related to the selectRecordsAsync method. Hoping this is helpful to someone else! GOAL My goal here is to update a value in a record selected by the user (e.g. {"Status": "Not Started"} -> {"Status": "In Progress"}). User first selects a record with await input.recordAsync and then the record is updated with updateRecordAsync(fieldId, {"key": "value"})). BACKGROUND & ATTEMPT 1 First - a sanity check and quick background on my approach here. As part of this, I don’t need to/want to present a list of all records. For example, I have about 50 records in total, but only about 10 are relevant, and thus only the 10 should be presented to the user for selection. Since you can render the input.recordAsync from a view, I started by creating a view which is configured how I want it w/ filters, sorting, etc, so that only the 10 records I want are listed. And voila - the input.recordAsync presented just the 10 opti

Hi there, I’m a newbie on airtable… and in the first script I write I encountered a problem and maybe somebody here can help me let table = base.getTable(“MAIN_TABLE”); let query = await table.selectRecordsAsync( { sort: [{ field: “STRING_FIELD”, direction: ‘desc’ }, { field: “DATE_FIELD”, direction: ‘desc’ } ] } ); for (let registro of query.records) { // Do some processing… }; The problem that I have is that the order of the records is always the same, no matter what i write on the sort options invoking the table.selectRecordsAsync function… There is something that I’m missing here? Anyone has encountered the same problem?? Thanks in advance

Hey folks, I’ve got a mystery/puzzle/bug. I’ve recently rewritten one of our scripting blocks, and added the new version to our airtable base. It works great for me, exactly as intended, but when my teammate clicks “run” on her computer she immediately gets this: SyntaxError: Unexpected token '.' Function@[native code] blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:44565 s@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:3861 blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:3611 e@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:66 l@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:270 blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676

I have a table with a column which can 0 or more string values. I’m trying to search for all records that contain a certain string value in its that column I’m using the following in my request URL but never getting any records (this value does exist within the array of values in some of the rows) filterByFormula=SEARCH("rec6CS1RqOjcYLwXf", ARRAYJOIN(Industries)) Am I doing something wrong?

When fetching, I’m getting this error in console: Access to fetch at ‘https://usgeocoder.com/api/get_info.php?address=18035%20SE%20Newport%20way&zipcode=98027&authkey=’ from origin ‘https://block--hd-i-z-fh-ux-g-vq-m0-t--tiq297d.airtableblocks.com’ has been blocked by CORS policy: Response to preflight request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’ header is present on the requested resource. If an opaque response serves your needs, set the request’s mode to ‘no-cors’ to fetch the resource with CORS disabled. Here’s the current fetch part of my code: let reqHeader = new Headers(); reqHeader.append('Content-Type', 'text/json','Access-Control-Allow-Origin'); //,'no-cors' let initObject = { method: 'GET', headers: reqHeader, }; var targetUrl = "https://usgeocoder.com/api/get_info.php?address="+add+"&zipcode="+zip+'&authkey='+apiKey; console.log(targetUrl); await fetch(targetUrl, initObject) .then(function (response) { return

I have a plan to help our local community who lost their job during this lay off situation. The plan is to create a basic directory model where visitors can hire a local person base on their needs. To complete this task I need a solid solution for our users or job seekers. Selected user and admin received an email when visitors hire them from our database. Which means a separate lead form for each job seekers so they directly receive message. Somehow I think it is possible with airtable web clipper and form feature but not sure how to do it. I am open for suggestions if anyone have any alternative solution.

Is there a way to run my business through air table? I need to be able to put appointments in and they go into calendar and will also be able to go in to invoice and then print invoice. How do I change some of the wording in the invoice screen that prints

Hi. This is my first forum post forgive me if I’ve posted in wrong location or anything. I am a small business owner thinking of switching our company database from Filemaker to Airtable. Initial impressions have been good so far. One thing we do a lot of from filemaker, is email. It’s connected to Amazon SES. We use it for quick individual emails to our staff , statements to our songwriters, as well as mass mailouts to our clients. A bulk mail usually consists of selecting people from our big contacts list, composing email and pressing send. A custom made script in filemaker then sends each email through amazon ses. The script also takes care of any mail merge details, as well as tracking the cost of the mailout. My question is simply, is this going to be possible from Airtable? If so, would it require a script block? or a different method? I’m a total newbie here so please be gentle :slightly_smiling_face: Cheers