Development & APIs

As many would of done, I got the email today regarding scripting. I cant do the webinar due to it being 6am on a Saturday here in Australia but before I spend to much time researching this can scripts work off a submitted form to automatically create links to other tabs? We currently have this as manual process on our Real Estate base where a form is submitted with property details etc. We then have to manually copy the property address and put in in upto 2 new columns depending on a status column. This allows the linking and lookups created to work on other tabs. If not, thats fine, just thought I would ask because this would help us immensely in automating stuff!

Hi Airtable! I thought I would repost this again, since filters did not do the job. Maybe a script might work? I am not sure if this will cost something. I am trying to filter, only records that has one or more fields that are empty. I have created a share link to a copy of the database, if anyone wants to take a look. (https://airtable.com/shrIVQ1d9ckYOpEuV) COPY 1 CSV FACE VALUE 1. GENERAL STAMPS CE1 TO 1708aii GOOD 1 copy copy -… Explore the “COPY 1 CSV FACE VALUE 1. GENERAL STAMPS CE1 TO 1708aii GOOD 1 copy copy” base on Airtable Thank you, Mary Kay

JAVASCRIPT / NODEJS How could I find out how many records there are in a table? recordsMax = base('Table 1').size() Something like that, but it actually works. Thanks.

I’m looking for someone who works with both Airtable and Joomla. I need to set up feeds/processes between the two. If you have those abilities or know someone who does, I’d appreciate the referral.

Attempting to test the sample Project design tasks block - get the following. Any ideas why? The field is a string Error: Can’t create records: invalid cell value for field ‘Design project’. Cell value has invalid format: must be a string at Mutations._assertMutationIsValid

Hi All, Apologies for the lack of scripting ability. I’m hoping to get started if someone can point me in the right direction. I have 2 tables TableA has records in with following ID, Rate TableB has the same ID, Rate I want to build a script that, when run, prompts the user for the ID from TableA and then updates all records (multiple records for ID in TableB) in TableB with the value set on TableID for that ID Hope this makes sense. Regards

Hey there, Putting in a feature request - would be nice to have both an Input and a text area component with functionality similar to the one found in formula fields, after entering {. Cheers, Ronen Babayoff Superblocks.at

How can I get a custom block that I have $ block release'd back into a development state? Would I need to start a new custom block, point it at the same repo as a remote, and develop there?

I’m trying to implement a settings menu in my custom block. I have the settings component properly showing, and the settings inside working as I want. The only missing piece that I can’t figure out is how to trigger closing the menu from a Button component’s onClick() function, rather than having to click the settings icon again to close the menu. I have this in my main block component: const [isShowingSettings, setIsShowingSettings] = useState(false); useSettingsButton(function() { setIsShowingSettings(!isShowingSettings); }); I tried calling the useSettingsButton() function inside the onClick() lambda, but got this error: Error: Invalid hook call. Hooks can only be called inside of the body of a function component. This could happen for one of the following reasons: 1. You might have mismatching versions of React and the renderer (such as React DOM) 2. You might be breaking the Rules of Hooks 3. You might have more than one copy of React in the same app See https://fb.me/react-i

Anyone have a link to the webinar recording from Feb 28? I signed up for it but wasn’t able to watch. I’ve tried contacting Airtable but haven’t heard anything back after a few messages.

We’re looking for a Developer Advocate to help grow our developer community worldwide. As our first Developer Advocate, you’ll be integral in crafting the developer engagement strategy and executing on the Airtable vision. You’ll support our developer community through scalable tutorials, speaking engagements, and platform experiences to unlock value for new and existing users. If you’re passionate about democratizing software and being involved with a developer community from day one, we’d love to hear from you. What you’ll do Inspire and educate developers of Airtable’s potential through building JavaScript applications and proactively reaching the intended audience Devise and execute on a strategic plan to grow our developer community Represent Airtable in the community forum and produce relevant one-to-many educational resources Identify product gaps and opportunities to better serve our developers. Synthesize the insights into clear and concise recommendations for our platform en

Is there a batch version of the updateRecordAsync function?

I have 2 tables, let’s say one is a variety of companies (alpha, bravo, etc) and their different talent areas (managment, engineering, hr, IT, etc) The next table is personnel which lists the company they work for, their talent area, and then contact info. I want to populate a column in the companies table which will have a linked record to those personnel who match based on company and talent for each row. If the syntax were Excel I’d be okay to figure this out using Match… but my Javascript experience is basically zero. Any help would be greatly appreciated!

Is there a sample code snippet to pass table records into a function? Do I also need to pass the table or field itself (because I need the field to get cell value, or the table to get the field, right?)

Hi, pls i need script for all task in the tasks table. if done the tasks (with Checkbox), then move from Project 1 to Archiv the Tasks. Pls Help. Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Is there a read-only API key available, or this is this part of the “Granular Access” that is coming soon?

Hi everyone! This question touches on a lot of things outside of Airtable itself. Hoping someone here may have some insight. I’m using the new Scripting Block to call an HTTP endpoint I’ve built using AWS API Gateway. A script runs in AWS Lambda and returns some data as JSON back to the Scripting Block to continue the workflow. For extra context, it’s a Lambda Proxy Integration. I’m having trouble with CORS errors. I’m returning the CORS headers detailed here but still getting the error in Airtable. Here’s the section of JS in the blocks where the call is being made: // assemble the full URL from the record selection let url = aws_url + record.getCellValueAsString("Project Record ID"); let headers = { "Origin": "airtableblocks.com" } // make the API call let response = await fetch(url, { method: "GET", headers: headers }) Anyone have any similar experience?

I’d like to create a customer facing form that allows them to attach a csv file (based on a template). Once the form is submitted, Airtable would add the csv records to an existing table within the base. open to other options if there are easier ways to do this. the key is to automate it as we are looking to ingest hundreds of csv files this way any help would be greatly appreciated

Finally! Full, Dynamic Links Show and tell I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today. Check out how this simple script can create links that are dynamic and formatted with the text you want instead of the ugly full URL. Explainer Video: Loom | Free Screen & Video Recording Software Base: Better (Dynamic) Links - Airtable Universe Script: Create fully formatted links in Airtable · GitHub

Hi Airtable team - I’m seeing some strange behaviour - not sure if it is me or a bug. Here’s the scenario: I have some people and some events - a person can have one or more events (linked field). I’m updating the linked field in the people table (via a script) to all events where they have select “all events” (a different field). This all works fine. I have a 2nd script that run on the matching linked field in the events table. However, I’m finding that although the tables are linked in the people table, they aren’t yet linked in the events table. When the 2nd script runs it is not running against the full set of linked records and so is giving incorrect results. If I refresh my browser the linked records show in the events table and the script runs as expected. It is as though the links in the 2nd table haven’t been returned to the browser and the script is running totally in the client. The browser refresh populates the links in the events table client-side from the server. I’m gu

I’m attempting to migrate to Airtable from several custom SQL databases… The existing tables have several foreign keys that I am attempting to recreate in Airtable, but I cannot figure out how to update a record properly. In the example below, I’m trying to re-link the Cities to the references from States. There is an existing DBID column holding the original database foreign key. Finding the reference State is easy enough (though inefficient at this point), but I cannot figure out how to update the record properly at the end of the loop. Any ideas? let active_table = base.getTable("Cities"); let ref_table = base.getTable("States"); let query = await active_table.selectRecordsAsync(); for (let record of query.records) { let ref_id = record.getCellValue("StateRef"); output.markdown(record.getCellValue("Name")); let ref_query = await ref_table.selectRecordsAsync(); let ref_record = undefined; for (let find_ref of ref_query.records) { if (find_ref.getCel

Any ETA on when Rich Text fields will be supported via scripts?

Continuing the discussion from Script Block - Linked Record Issue: Hi Just wondering if this is the same issue. I have a linked record to another table. I’m trying to update this via a script. If I update a non-linked record it outputs as expected but seems unable to update the linked record. The code is as below: // set the table let dashboardTbl = base.getTable("Coaching - meetings"); // get the table records let dashboarddate = await dashboardTbl.selectRecordsAsync(); // loop through the records for (let record of dashboarddate.records) { // get date from field value "Date" let dashboarddate = record.getCellValue("Date"); // turn it into a date object dashboarddate = new Date(dashboarddate); //get year from date let dashboardyear = dashboarddate.toLocaleString('en-GB', {year: 'numeric'}); //get month from date let dashboardmonth = dashboarddate.toLocaleString('en-GB', {month: 'long'}); // only run on records which no linked dashboard data if

Are we not supposed to be doing this yet, or did I do something wrong? schedule_conflicts| |master=> block release building copying package.json files installing node modules [npm] [npm] > core-js@3.6.4 postinstall /private/var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/transpiled/user/node_modules/core-js [npm] > node -e "try{require('./postinstall')}catch(e){}" [npm] [npm] added 77 packages from 133 contributors and audited 672 packages in 17.866s [npm] [npm] 2 packages are looking for funding [npm] run `npm fund` for details [npm] [npm] found 0 vulnerabilities [npm] [npm] npm WARN user No description [npm] npm WARN user No repository field. [npm] npm WARN user No license field. [npm] transpiling and building frontend bundle uploading build artifacts failed to upload build artifacts Error: Failed to upload /var/folders/lx/d2z19t052vx3m9jb9xpd71nm0000gn/T/airtableBlocks/build/1583468310281/build_artifacts/bundle.js at /Users/JM

I haven’t been able to access the example custom blocks for some time now. When I try to build one from the template, I get this: blocks|=> block init appFalshZ06hLqEPb/blkmXtdrOPFKUVPIW --template=https://github.com/Airtable/blocks-flowchart flowchart_example Using your existing API key from /Users/JMO/.config/.airtableblocksrc.json Initializing block using https://github.com/Airtable/blocks-flowchart template [git] Cloning into 'tmp'... [git] remote: Repository not found. [git] fatal: repository 'https://github.com/Airtable/blocks-flowchart/' not found ❌ Something failed! Cleaning up... Error: Could not get template https://github.com/Airtable/blocks-flowchart - please check you entered the name correctly And when I try to view the source code directly on github, I get this: My github profile, in case it’s a permissions issue: GitHub jmoglesby - Overview Software developer and test automation developer at BCBSAZ. - jmoglesby