Development & APIs

I’m not an experienced coder, but I’ve written enough VBA & Python to have a degree of comfort with Java Script and write some basic routines. That said, my greatest degree of confusion here is referencing specific fields, records, cells, tables, etc. While loading the bases seems straightforward & part of every example script, documentation seems to drop off from there. Did I miss something? Can someone point me to a cheat-sheet with more examples like: .record.getCellValueAsString .getCellValueAsString The examples provided, “Loading records, Currency converter, Running total, Mark duplicate, Summarize linked records” are helpful, but more of these would be better. The user forum examples are a little scattered and specific. Probably, like most people using Airtable, my scripting issues are pretty basic. For example, one of the things I’m trying to do is just search a column for the highest value and enter the next highest value in the same column triggered by the prima

Hey ! I’m wondering if it’s possible to: Duplicate an existing base Invite an editor Everything through the API. Thanks

Is it possible to get all the bases for a user with the API key ? I’ve seen it in integromat i.e. but i don’t know if they have an special agreement because i cannot find this information. Thanks

Hi all! I have a Javascript integration question I apologize if this is basic, I am quite new here. I have created a Discord bot that is storing game win rate stats using an Airtable base. Each user on Discord has a unique ID which I am storing in the first column of the table. I have a function on my bot that allows users to add themselves to the base by creating an entry with their Discord ID and with their number of games played and won. I don’t want to have two records for the same user, however, so I want to add a logical check that searches my base to see if there is already a record wherein the discordID column matches the ID of the user attempting to be added to the base. Basically, if my discordID is 222, I want to search my base for entries where the discordID is 222, and if more than 0 appear then I want to NOT add myself, but if 0 results are returned then I DO want to add myself. I have tried doing this below, but it doesn’t seem to be working as expected (i.e. my console

Is it possible to update the lookup filed on a linked table via the API? I have a projects table. An a people table. O the projects table I have a lookup field that grabs the first name from the people table. Using the API, would I be able to change the name by simply updating the lookup field on the projects table? Thank you!

I’ve noticed that when using .loadCSSFromString() the frontend renders multiple duplicates of the same <style>/<style> element in the DOM body. Is there a way around this that I’m missing? In the example below, .loadCSSFromString() is placed at top-level and not within a loop.

Maryland Center for Computing Education (MCCE) strives to increase access, equity, and computing education efficiency. Our approach builds upon the progress of CS4ALL. We have implemented an AirTable-based lesson repository as a resource for elementary school teachers to implement computer science instruction in their classrooms. We are looking for a developer to partner with us to upgrade this system. This work will entail API development work to extend the functionality of the system. If you are interested, reply to the post to share with us how to contact you, and we will send specifications for you to consider.

Hello there, We are actually using Airtable for real estate reporting. Actually we are sending raw reports from airtable to our clients. The design and ergonomics are really poor for a common user so we looked for other solutions. I didn’t found any interesting application to connect with zapier for now but I finally discovered page designer. Page designer allowed me to reorganize datas but it’s hard to make something really clean with it. I also have a big problem with page designer because it’s not dynamic. I mean, we have many datas and their size can change and some of them can be filled or not depending of the report. Our needs also includes photos (the number can vary) and clickage links. So, using airtable can leave me with blank space of different size which is not really clean for our clients… Can you suggest me a solution that could solve our problems and which is free or not too expensive ? Thanks for your answers.

Hi Guys, I’m trying to find a way to see live data in my web application/mobile hybrid application, is there a way to do this? I don’t see any information regarding live data in the docs. What I want to implement is that when a new record is added or updated in airtable, the web app somehow detects the change in the airtable data and update the view. I saw that we can use airtable.js and airtable.browser.js if you’re using it in the browser, but what are the differences? cannot find anything related to airtable.browser.js, anyway, going back to the main problem, is there a way to display the data as live as possible?

Got a newbie question for you. I’ve got 2 tables linked together: Viewers and Movies, through a field on Movies table called, “Fans”. I’m trying to look up the viewer of a movie and change their status to “Favorite” if it is currently “Watched”. let viewer = record.getCellValue("Viewers"); if {name: viewer[0].getCellValueAsString('Status')} == "Watched" { updateRecordAsync(writer[0], { 'Status': {name: 'Favorite'}; }) } The error gives me an unexpected token ‘{’, which I suspect isn’t the real problem. Any ideas here? Would love to get my first script block running!

I am looking for suggestions to change my script so that it does not time out. My script is below. Basically when a new record enters a view on a Table A (‘Verifier Bodies’), I want to update another Table B (‘Technical Comments for VB’) by linking all the records in that view in Table A to records in the view on Table B. The script below ‘works’, but is now timing out due to the number of records. I think I need to make a change so that just the new record is added to the field ‘Verifier Body List’ in Table B without overwriting the already linked records. How would I go about that? Any help is appreciated. let TBTable = base.getTable(“Technical Comments for VB”); let TBView = TBTable.getView(‘General Share for VB’) let TBQuery = await TBView.selectRecordsAsync(); let TBRecord = TBQuery.records; let VBTable = base.getTable(“Verifier Bodies”); let VBView = VBTable.getView(‘List of SLCP for Higg Co.’) let VBQuery = await VBView.selectRecordsAsync(); let VBRecords = VBQuery.records

Hello all and thanks in advance for your help! I’m trying to pull records into my base from this API (https://clarisa.cgiar.org/swagger/generalListReference.html#section1-item4), but am stuck on exactly where to start. I’ve tried modifying other scripts and using the script app, also tried data fetcher. Any tips on how to get started would be appreciated.

I am running into some trouble when using the API to return entries which contain a user’s role, and in my case each user has multiple roles (ex. pitcher, left_fielder). Each user’s role is stored using comma separated values in a separate Airtable table (i.e. a “multiple select” table). I am currently using this filterByFormula call via API: FIND(“USER_ROLES”, role) > 0 It only seems to return results if the user has one role [FIND(“pitcher”, role) > 0], but fails when searching multiple roles [FIND(“pitcher, left_fielder”, role) > 0]. There’s got to be a way to have the API return records that “contain” one or all of the multiple select fields. Does anyone know how I can return results using a string of user roles via one filterByFormula call?

// updates the Deal table let tDeals = base.getTable(‘Deals’); let qDeals = await tDeals.selectRecordsAsync(); for (let rDeals of qDeals.records){ let d= getDistanceFromLatLonInKm(rDeals.getCellValue(‘Latitide’),rDeals.getCellValue(‘Longitude’),rDeals.getCellValue(‘BLa’),rDeals.getCellValue(‘BLong’)); await tDeals.updateRecordAsync(rDeals.id, {‘Distance’ : d}) } // distance between 2 given points (in miles) function getDistanceFromLatLonInKm(lat1,lon1,lat2,lon2) { var R = 3958.75586579; // Radius of the earth in miles var dLat = deg2rad(lat2-lat1); // deg2rad below var dLon = deg2rad(lon2-lon1); var a = Math.sin(dLat/2) * Math.sin(dLat/2) + Math.cos(deg2rad(lat1)) * Math.cos(deg2rad(lat2)) * Math.sin(dLon/2) * Math.sin(dLon/2) ; var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a)); var d = R * c; // Distance in miles return d; } function deg2rad(deg) { return deg * (Math.PI/180) }

I’m looking to pull data from an external API with different parameters. These parameters are coming from Typeform survey responses integrated to Airtable. Is there a way to execute the Get request by inputting the parameters from Airtable and then retrieving the results back into Airtable?

Hello amazing community! We pull data from AT into our WP website. We have added a hyperlink to a rich text enabled Long Text field. When the info is pulled into our website, the hyperlink is converted to a “****” snapshot here: Any thoughts? Thank you! Katherine

Hi, I’m developing an App for android and I want to consult the information on my base but the app will be used for many users (about 1000) so my question is if the rate limit is by IP or how it works? can I use airTable for this porpuse ? Thanks!

Hi, I have a table and form associated with it. When ever a user fills a form a row is created in the table. I have created a field Point of Contact(single select field)(4 no.s). I am looking at automation or scripts which can work as when ever new record/row ois created in the table POC(out of 4 any one) is assigned cyclic for each row. Please help in automation or script.

I am trying to do a curl command where I filter results from a linked table that has multiple linked records… I have the record ID for the linked table record. Tried some encoded filterbyformula variations but get zero results. linked field name is “sections”. I tried this most recently: filterByFormula=FIND(%22rec0nTsg5N5p1i5Pv%22%2C+%7Bsections%7D) Thanks for help.

Hello! My goal would be to automatically add photos from Table 2 (where they are imported in bulk) to Table 1 (with the right item order). The only link between the items in the two tables is a code/name column. I tried my best experimenting with formulas in Airtable and GSheet, but I couldn’t find any solution. I copied a script from an older community topic: Programmatically copy images from one table to another , but it doesn’t seem to work. Can someone please help figure out what the problem might be, or offer another solution? Here’s a simple version of my base (Restaurant): https://airtable.com/invite/l?inviteId=invyOwrzT6i00qbss&inviteToken=1c708dfb92651fb230f375f758d4d172ad56602b0347fccf8ac86f495d5a8522 , where the pasta dishes (Menu Item Name) should get the photos in the Attachments column from the Image column in Table 2, connected by the Name and Code columns. Thank you!

I am trying to duplicate a row from one table to another (using scripts). The table I am copying from has a column with “rating” type field in it. How do I go about duplicating in the createRecordAsync script? I tried something like let table1 = base.getTable("Table1"); let table2 = base.getTable("Table2"); let table1Rec = await table1.selectRecordsAsync(); await table2.createRecordAsync({ "Memo":[{icon: "star",max:table1Rec.getCellValue("Memo"),color:"yellow"}] } I got an error. Summarizing it: “(property) “Memo”?: 0 | 1 | 2 | 3 | 4 | 5 Type ‘{ icon: string; max: number; color: string; }’ is not assignable to type ‘0 | 1 | 2 | 3 | 4 | 5’. Type ‘{ icon: string; max: number; color: string; }’ is not assignable to type ‘5’.(2322)”

I am using Airtable as the backend for my hiring assessment app (a cybersecurity hiring test). As I understand it, Airtable’s API uses bearer authentication. I’m trying to integrate my app with Greenhouse.io, an applicant tracking system. Greenhouse’s API uses basic authentication. The way it works is this: Our customer, which uses Greenhouse to manage its hiring process, gets a list of tests (assessments) from us with a GET call. Customer chooses which test they’d like a particular candidate to take, and gives us the details with a POST call. We send the test to the candidate. We let the customer know when the assessment is complete with a PATCH call. Customer gets the assessment results from us using a GET call. Is there a no code/low code way for me to integrate with the Greenhouse API even though they use a different authentication method?

I’m trying to create my first app with the functionality to copy records from 1 table to another. I have been following examples here on the Record Picker and Spreadsheet importer: Airtable Scripting I run into the error: /Users/dev/.nvm/versions/node/v14.15.0/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/frontend/index.js: 'await' is only allowed within async functions (9:15) If I remove await commands, then I run into: ReferenceError: base is not defined at HelloWorldApp (https://localhost:9000/__runFrame/bundle.js:59:21) at renderWithHooks (https://localhost:9000/__runFrame/bundle.js:59844:18) at mountIndeterminateComponent (https://localhost:9000/__runFrame/bundle.js:62524:13) at beginWork (https://localhost:9000/__runFrame/bundle.js:63648:16) at HTMLUnknownElement.callCallback (https://localhost:9000/__runFrame/bundle.js:45207:14) at HTMLUnknownElement.e._wrapped (https://cdnjs.cloudflare.com/ajax/libs/rollbar.js/1.9.0/rollbar.nojson.min.js:1:13806) at Object.invoke

Hi, I want to allow a customer of mine to export the data on AirTable. I figured that if the customer put the API key, my program can do the rest, specifically: create a table with specific fields put the data in As far as I understood point 2 is easy but point 1 is impossible with current set of API. Is that true? PS: I noticed that there is a way to create a table using the Airtable Blocks API but is that only for frontend apps? Or can I work with them on a NodeJS instance?

We are trying to access a specific cell value in the code. We are able to query the records and getCellValueAsString. However when we try to call a specific record from a field we get a completely different record from that field and there seems to be no pattern to it. let table = base.getTable("🌻 Groups"); let queryResult = await table.selectRecordsAsync(); let record = queryResult.records[1]; console.log(record.getCellValueAsString("This Record 🆔")); console.log(record);`Preformatted text` As you can see we are trying to get the first record in the list, but we actual get the 27th and if we increment the value to the second, we may end up getting the 35th record. However all of the fields within the row that is selected is present. The reason we want to do it is because we want to update a linked record to a cell while leaving the previously linked records intact.