Development & APIs

I am trying to read formatted text from a rich text field via API. However, sometimes different text may result in the same Markdown representation. For example, each of the following four text snippets: ~a~ ~a~ ~a~ ~a~ is represented in an API response as ~~~a~~~. Is it possible to get the contents of a rich text field that can be decoded unambiguously?

I am attempting to create a simple script which will count the number of entries in a linked lookup field. My plan was to invoke .selectRecordAsync() on the table of interest to pull the records and count the number of entries for a given record in that field. I’ve run into an issue early on with this script: the selectRecordAsync call appears to only be returning the name field and Id for the records, but no other data. My code is below. let vendorTable=base.getTable("Vendors"); let quoteField=base.getTable("Vendors").getField("Quoted Parts") let records= await vendorTable.selectRecordsAsync() console.log(quoteField) console.log(records) let exampleValue=records[0].getCellValue(quoteField) console.log(exampleValue) I’m getting the following responses in the console. My table is structured as follows: The only issue I can think of off hand is that all of the fields (aside from name) are linked or lookup values. What am I missing here?

I wanna delete cells-value in Amount Field. I am referring to this↓ Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. but I can’t.参考にしています I wanna just all clear Amount field Value… help me. //get table let merchandiseTable = base.getTable("C_商品"); let fieldAmount = merchandiseTable.getField("amount"); let merchandises = await merchandiseTable.selectRecordsAsync(); let merchandise = merchandises.records; //console.log(merchandise); //Amaount-fields value to null while (merchandise.length > 0) { tmp

Hey guys. I wanted the Enterprise API and i have registered with a free account for now. But the Page says that the link says “Page not found”. Is there something i can do? or do i need to switch to the paid version to access it? Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

I have a simple script I’m trying to write, but since I’m new it’s not simple to me… LOL I have a junction table I’d like to automatically populate. In this example… I want to connect every bug with every home. So anytime a bug is added to the Bug Table, the junction table is updated to connect it with every home. Likewise, whenever a Home is created, the junction table is updated with every bug. Lastly, I want the script to clear any junction records if either a bug or home is deleted. I started with the script from this thread HERE, but just couldn’t figure out how to modify it to make it work. Lollipops for anyone who can help me! Thanks. :slightly_smiling_face:

My application has several Select components which the user can use to enter information. The first two fields have only a small number of options. The third field has over 70 options and can be tedious to use. I want to use the values selected in the first two Select components to filter the available options presented to the user in the third Select. The options in the third select are pulled from records in the base. These records have linked fields. Some of these linked field values are options chosen in the previous Select components. So, lets say I want to filter returned records from a table where values in a linked field (s) match either the record ID of string value in said linked field.

I have an app that provides interface to add linked records. I want to prevent the users from doing the linking directly on the field. This is because the app adds the link to a view and creates backlinks in that view. when the user adds the links directly on the field, I lose the backlinks since Airtable does not allow backlinks when using views for linked records. I understand I cannot restrict permissions on that field since that disables permission for the App as well. I was able to get the changes in my app using useLoadable and useWatchable so everytime this field is updated in this particular view, i get the new queryResults. But I want to know what changed if a new link is added / deleted and if so what is the newly added link. How do I do this with blocks? Thanks in advance.

We have a script to add a record (client login info) to a table (ComputerLogins). The script asks the user to select which client the new record is for, from a clients table, which is linked to the ComputerLogins table. They are then asked what single-select category (“Portal”) the entry should be assigned. It then creates the record. Problem is that if a record already exists with the same category, for the same client, it creates a duplicate. We’d like to check the ComputerLogins table to see if (1) the client already has a record and (2) if they do, does it have the same category that the user wants to add? If it exists, then the record should be updated, if not it should be created. I’m new to this scripting but I can do the first part and the last part, but I’m having trouble with the comparison code. I’ve tried to figure out if it’s a records query with .includes or some && condition statement or some type of getAsString to do an if A===B then update statement. I think th

I am new to Scripting and need assistance with modifying the following Airtable Script, which is working well with the Base that I am creating. Unfortunately, I do not want the script to request user input for the number records to create; instead, I want it to use the number that is contained with in a field in the GOODS IN table. Can anyone help please? let settings = input.config({ title: 'Create child linked records', description: `For a record in a "parent" table, this script will create some number of “child” records in another table, where each “child” references the “parent” through a Linked Record field.`, items: [ input.config.table('parentTable', { label: 'GOODS IN' }), input.config.table('childTable', { label: 'LOTS IN' }), input.config.field('linkField', { parentTable: 'childTable', label: 'Linked record field', }), ], }); async function createChildrenLinkedRecords() { let { parentTable, childTable, linkField } = settings; if (

Hi All I’m building an app with Adalo using Airtable as my database. I have, as of now, 1 base with two tables, users and products. A product can have many users and a user can have many products. Obviously there is a linked field connecting Users → Products and it’s a multi-select linked field (a product can have many users). I’m trying to “add” a user or “append” a user to the user array through the airtable API (PATCH) and each time I get something to work, I can only get it to overwrite the current user in that table as opposed to adding a new user. Any thoughts on what I’m missing here? Thanks!

Is there a way to make createRecordsAsync create a new value when it is not present in a single select field? await table.createRecordsAsync([ { fields: { 'Print Name': prnt.name, 'Printer': { name: prnt.printer }, }, } In this example, I have two fields: ‘Print Name’ is a text field and ‘Printer’ is a single select. Is there a way to pass a value to Printer that isn’t already in the base? This happens on the GUI side if you’re copying and pasting values. I’m wondering if you can do it inside a script.

Hi, my code is working locally just fine but not on the server. The code’s purpose is to create a new record is created in Airtable. When I push this code to IBM Cloud Functions, which is equivalent to AWS Lambda if folks are more familiar with AWS, the code seems to finish before Airtable’s “create record in base” function executes. A little about the code: it’s an analytics function. It will take a search term, like “dog food”, figure out all of the products tied to that search (say there are 64 products) and for each of those 64 return five different scenarios based on whether our main Airtable has that data: relevant result (in this case, 50% or 32 relevant results) not found in database (in this case 28% or 18 not found) found, but missing country (in this case 8% or 5 missing country) found, but missing manufacturer (in this case 14% or 9 missing manufacturer) edge case (in this case 0% or 0 edge cases) All code samples are below. The code is two pieces, one is a “createRecor

I am wrote code (below) inside a Twilio function which utilizes the Airtable API which first looks up a record in specific table (“clients”) in an Airtable base. It then pulls field data from that record (using record.get), and then using JSON in the “Callback”, enables me to utilize that field data later on in my Studio flow. It works perfectly. What I’m trying to figure out now is how to reverse that procedure. I’d like, once again, to first find the Airtable record. But then, instead of using “record.get” to pull field data in; I would like to write/update​ fields back into that Airtable record. In other words, after the line that reads: “if (record.get(“Client_ID”) === clientnumber)” instead of the two record.get commands that pull data from the fields, what would the code be to write data (say just a literal string) back to those two fields? Thanks in advance for any help you might provide! My Function Code to Fetch Airtable Data Into My Studio Flow const airtable = require(“airt

Hi there, I hope someone can help me :slightly_smiling_face: I have been using page designer to create invoices, but want to automate the process a bit more. Page designer has a built-in line-items functionality and I’m trying to build the same, but the document gets created in Google Docs. I’ve tried a lot using Zapier, but wanted to reach out to you guys for any suggestions. I know of Documint, Formstack etc., but find these options wayyyy too expensive. Thanks & Cheers!

I’ve written an automation script that I’d like to migrate over to the scripting app. I know that there are some differences between the two, but I’m having a lot more trouble than I thought. The script connects to an external API and pulls data from the API into my base. I seem to be running into issues with the async functions I’ve written to connect to the API and pull the data in. The code works when it’s not wrapped up in a function, but fails when it looks like the example below: async function testFunction(){ let response = await fetch('https://api.github.com/orgs/Airtable'); console.log(await response.json()); } testFunction(); This code above works as an automation script, but not in the scripting app.

Is the fact that the Scripting app linter recognizes this method a bug, or a sign of things to come? The capital B seems to imply React shenanigans. I know there have been calls for table creation to be added to the app, but I didn’t think it would actually happen. I still don’t, but I guess that’s one way to place it behind a paywall in style come September (assuming Airtable actually comes through with it this time around lol). Either way, I’m afraid that trying to run this yields a full stack’s worth of a debugging mess instead of a new table: Edit: or have I just broken the app by running it on an iOS version of Safari? :grinning_face_with_sweat:

Hi, would it be possible to define a custom formula? For instance I want to make one that generates a UUID that can be used across a variety of platforms. Thanks in advance

Hey all, I am attempting to use the Javascript API to get records in a Node.js server from a base with 10,000+ records. I have used the offset parameter in the past with CURL but am not getting an offset when my query returns. Here is the query at the moment: const results = await productsBase('Products').select({ filterByFormula: `OR(FIND("${BRAND}",{BRAND}),FIND("${PRODUCT}",{PRODUCT}))`, maxRecords: maxRecords, }) return await results.all() Thanks in advance!

Hi I’m playing around with scripting (not a programmer) and I’ve run into a situation where I can’t update assign the collaborator object. I’ve modified my code to represent what I’m looking for Collaborator is the collaborator field on my base. I’m trying to assign a collaborator (through a previous function) named ‘assignCollaborator’ await table.updateRecordAsync(record, { "Collaborator": { "name": assignCollaborator} }) The errors I’m getting say that the fields don’t exist but I can create references like this let collabName = record.getCellValue("Collaborator").name Some explanation here would be super helpful. Thank you

Does anyone have any tips for creating multi-line tooltips in Custom Apps? My tool tip is a long sentence and it doesn’t appear at all if the window is too small. I’m trying to add new line characters and also tried the following which isn’t doing the trick. <Tooltip content={() => {return <Text>"LONG TOOLTIP TEXT HERE"</Text>}} placementX={Tooltip.placements.RIGHT} placementY={Tooltip.placements.CENTER} >

Hey everyone,I’m trying to send out an email using automations, but I can’t figure out how to do it correctly….I have a USERS table with USER_EMAIL along with DAYS_TENURE (how long they’ve been signed up)I have a PROGRAMMING table with a DAY_ID column, and a few additional columns with relevant data. For each user, I want to find their DAYS_TENURE value, then find the records in the PROGRAMMING table with the matching value in the DAY_ID column, and email them the 3 additional columns from the PROGRAMMING table. I think I need to use scripting to do this, but I’m running into issues. I’m more of a SQL and python person, so there’s something I’m missing for javascript… In my code, I’m trying to do a nested for loop…the outer loop loops through each unique DAY_ID from the PROGRAMMING table, and the inner for loop adds the users from the USER table to a javascript object if their DAYS_TENURE matches the DAY_ID. For the sake of simplicity, let’s say I have DAY_ID values of 1, 2….and for DA

I’m trying to import data from an API. I’m able to authenticate via my terminal, but I’m trying to write a script to automate that process (the access token is only good for 24 hours, so they recommend refreshing the authentication before every request or once per day). As I understand it, fetch() is the way to do an HTTP POST. I’ve written a function to do this, and I keep getting a 401 Unauthorized error. It looks like nothing after the url is getting passed on. I’m sure this is some kind of syntax error on my part, but I’m not familiar enough with JavaScript or API’s to know what it is. Any help would be appreciated. Code is below: async function authenticate() { let authentication = await fetch(authenticate_url, { method: 'POST', header: 'content-type: application/x-www-form-urlencoded', data: `grant_type=refresh_token&client_id=${clientID}&client_secret=${client_secret}&refresh_token=${refresh_token}&username=${username}&password=$

Hi all, I came up with the following design for the internal BI system. The first table is used to store the payments. (Payments table) I also need to calculate the monthly sales statistics for each sales representative along with their quota (a predefined value that differed from month to month and added manually each time) For that purpose, I have an additional table. (AM table) The combination of (sales_rep, month, year) creates the unique id for the AM table and the linkage between two tables works very smoothly. However, I believe there is room for improvement since I have to Link unique-id-am field to AM Quota manually every time. I just drag the cell to AM Quota as you usually do when copying the column. I want to automate this process and write a script that will perform this action for me in the add new row event. I thought of doing something like that, but obviously AM Quota doesn’t allow me to do that due to the conflicts of type. let table = base.getTable("Payments"); le

Hi. I want my formulae field ot be able to call a script I made. Is that possible and how? app is called times10 function times10(x) { output = x * 10 } I would then call it using the formula field. =times10(5) which would print out 50.

It’s Aug 2021. I read the posts from 2020. No help. Just starting here. Trying to do Hello World App., But on OSX Catalina (10.15.7), Blocks will not install. I tried the suggestion from 2020: “npm install -g @airtable/blocks-cli@0.0.52” Either way, lots of warnings about “Please upgrade to version 7” and then failure: npm ERR! code ENOENT npm ERR! syscall chmod npm ERR! path /usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/loose-envify/cli.js npm ERR! errno -2 npm ERR! enoent ENOENT: no such file or directory, chmod ‘/usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/loose-envify/cli.js’ npm ERR! enoent This is related to npm not being able to find a file. It would be great to get off step one. Thanks in advance.