Development & APIs

I have some multiline text I for some reason do not seem to be able to split into parts. My text is: “506070 80” let arr = multi.toString().split(" "); console.log(arr) //["506070 80"] Does anyone know how I can split this? If i make real space in the multiline text it splits as expected.

Hi there - Currently, I am trying to do a data automation script to check if values meet specific criteria and then make recommendations for what is there vs what isn’t. The script is working as intended, however my CPU time is exceeded (3438 ⁄ 1000ms). Any recommendations on how to fix?

Here’s what I have let table = base.getTable("-Some Matter Name-)"); let field = table.getField(“Request Date”); await table.updateRecordAsync(record,{ “Date Requested”: new Date() }); I haven’t done a lot of programming for a while now, so I sort of have an idea but not exactly how to write it

I’m surprised I can’t find anyone else having asked about this; is there any scope for: increasing the PATCH limit from current max of 10 or making it explicit in API documentation that PATCH is limited to 10 … so users aren’t left troubleshooting an error that can be quite subtle (I had to tell browser console to unfold several layers of nested error logging).

I am just curious if it is possible to write a script that uses a multi select date picker calendar to create bulk records with same details via script. Use case - I want to create jobs on specific dates, times, locations, etc. in bulk. I can see this being used for a ton of different use cases though. Example - Select Multiple Dates with Calendar Picker - (1/13, 1/20, 1/21) Shift #1: Enter Employee Quantity per date - (2) Fields (option to pick the fields that need data added) Enter Location - (123 Main St) Enter Start Time - (07:00) Enter End Time - (15:00) + add another field Shift #2: Enter Employee Quantity per date - (1) Fields (option to pick the fields that need data added) Enter Location - (123 Main St) Enter Start Time - (09:00) Enter End Time - (17:00) Enter Event - (Basketball) + add another field + add another shift So my created records would be a total of 9 records: 1/13 - 0700-1500 - 123 Main St 1/13 - 0700-1500 - 123 Main St 1/13 - 0900-1700 - 123 Ma

I am trying to use AirTable as part of a node.js app to lookup users. Here is how it should work: The table has multiple columns, including one for ID. The API looks up the user ID by listing all and filtering by ID. If there is no record found for the user ID, it will create a new record for it. I tried to attempt this using the code below, and it works fine when a user is found, but when it doesn’t, it outputs a 422 error with the status text “Unprocessable Entity”. I would really appreciate if someone could show me how to do this, or show me what I did wrong in my code. (The code is in Node.js and I used request and axios because I was copying existing code that was in Node.js request and I only know how to use Axios) request({ headers: {'Authorization': 'Bearer <TOKEN>'}, url: `https://api.airtable.com/v0/<APPID>/Users?maxRecords=1&filterByFormula=${encodeURI(`{ID}=${<ID OF USER>}`)}`, json: true },function (error, response, bod

Ok so I know that this would be fairly complex, and may not be possible, but if it is, how would I go about making a login system using Airtable. I am trying to see if I can use Airtable as the backend database to something, and I’d like to try and refrain from using an SQL database, if possible. Of course, if completely necessary, I am completely comfortable doing so. Any help is appreciated.

Hey there. I have a custom app that’s installed in a couple Tables. I would like to convert it to a Marketplace app so that others can install it. How can I make that happen?

I have a bunch of property data I am getting each month for multiple properties. My end goal is to build monthly summaries for each property like this: Avg price for each floor plan(1br,2br,studo) amount of units available at by floorplan (1br,2br,studio) Eventually I’d like to put these calculations in some type of chart to compare these metrics at these levels. Is there a way to run these calculations in Airtable dynamically? Maybe using scripts? My goal is to create these charts where users can assess these trends. Any advice would be greatly appreciated!

I’ve read in this thread that the Airtable block CLI requires Node versions below 15. Unfortunately, I’m on an Apple Silicon Mac trying to help my fellow developer with a custom app project. As it turns out, as far as I can tell, Node 15 is the minimum that builds on Apple’s arm64 architecture. This in effect means that until block is updated to support Node 15, I cannot help build custom apps. I have tried installing older versions of Node with NVM, and they fail to build. Is there any way that I can use block with Node 15, or any idea of the timeline for it to be ready?

I’m trying to limit the available choices when picking a field for my app. Looking through the FieldPickerSynced documentation I found “allowedTypes” property. Per and example I found here: Error: Cell values for field X are not loaded - #3 by Maximilian I added the “import {FieldType}” line. I can pick a table, but I can’t pick a field and it doesn’t limit my choices to a specific field type. If I removed the “allowedTypes” property, I can select any field. The table I’m testing this on only has two columns (autonumber, link to record). What am I missing? import { initializeBlock, TablePickerSynced, FieldPickerSynced, useGlobalConfig, useWatchable, useLoadable, useBase, } from '@airtable/blocks/ui'; import {cursor} from '@airtable/blocks'; import {FieldType} from '@airtable/blocks/models'; //<--ADDED THIS LINE import React from 'react'; function CopyDataset() { // YOUR CODE GOES HERE const base = useBase(); const globalConfig = useGlobalConfig(); const tableId = globalConfig

Hello out there, I am not experienced in writing code and I am hoping that someone can help me make a workflow dream come true! I’ll do my best to explain what the goal is below, but please let me know if it is unclear. In my Program Management base, I recently followed this example to add tasks from a Task Template table to specific projects, just copying/pasting the code: https://www.airscript.dev/2020/10/04/generating-tasks-for-projects The code copies every task from the Task Template table into the project. What I am hoping for help with is: We have several different project types, each that involves its own set of tasks. Is there a way for me to add to the above code so that I can pick a specific set of tasks in the Task Template table, based on an identifier? Currently, to separate out which project types that tasks are associated with in the Task Template table, I have a ‘multiple select’ field that includes types like Solo Exhibition, Juried Exhibition, Traveling Exhibition, e

Happy New Year! We’re excited to open up a beta for a new remoteFetchAsync function in the Scripting App. One of the most common issues we see users run into when writing scripts is in trying to use the fetch API to communicate with an external service. Because Scripting App scripts run directly in the user’s browser, fetch requests will be blocked by the browser if the target server doesn’t support Cross-Origin Resource Sharing (CORS). The new remoteFetchAsync method transmits the request from Airtable’s own servers rather from the user’s browser, thereby getting around CORS issues. remoteFetchAsync works very similarly to fetch and expects the same inputs, except for a handful of “gotchas” stemming from the fact that this is run from a backend. We’d love to get your feedback on this new API. To sign up for the beta, fill out the form here and we’ll enable the beta on your account. You’ll then be able to check out the documentation for remoteFetchAsync here.

Hi guys, So I have an “email address” field which when a new entry is made an email is triggered and sent to someone. I’d like that email to be sent after a certain amount of time… like 5-6 hours. How can I write that as a script?

Hi, Here is my code using record.get([“Attachments”]); : function showListe() { base("Works") .select({ view: "Grid view" }) .eachPage(function page(records) { records.forEach(function(record) { var li = document.createElement("li"); li.textContent = record.get(["Attachments"]); document.getElementById("root").appendChild(li); }); }); } which gets me : [object Object] [object Object] If i do record.get([“Attachments”][“url”); i get nothing… Help!

Hi, I’m having trouble filtering data from a table that is linked to another. I am getting the id of a company and when I want to show all the branches of the compant it return an error or and empty array. I am trying to filter them by the ID of the company. The structure of the branches is: { ‘ID_COMPANY’: [ someId ], ‘COMPANY’: [ companyName ] } What I was trying to do was: filterByFormula={ID_COMPANY}="someId" and it didn’t work, but when I did this: filterByFormula={COMPANY} = "companyName" it did work. Blockquote Can you help me?

I just post another topic,but nobody replies to me. Can anyone help me? Hi, I’m using block sdk to build a custom app. But I meet an error after I install an es6 modules( @antv/x6 ) Bundle Error: 'import' and 'export' may appear only with 'sourceType: module' I tried to add a .babelrc file to add prset-env but don’t work. what should i do to solve this problem?

After following the quick start from CKEditor documentation here. I observe that the component is created but it is not visible. Has anyone encountered a component not visible due to CSS problems before? If so, how can it be solved? Thank you in advance.

Is it possible to inject Browserify transform plugins into the blocks-cli bundler? Has anybody had any success doing this? Thanks!

Hey everyone, I have a form where I am collecting responses, but I need to have the the form change the questions after each submission. I have a script set to run automatically after a new record is added which will generate the new field name and has the field id set as a variable, but I do not know how to change the name of a field while using scripting. Does anyone know if this is even possible? I basically need a function which takes a field id and a new field name, and the function will update the field name. I would even be okay with keeping the field name the constant, if I could just update what shows up on the form. I do not think there is a high level of coding allowed for forms though. Any help is appreciated! Thanks!

I’m looking for ways to embed a more customized gallery view of an airtable base (on my wordpress site) on my wordpress site either by modifying the iframe or through a third party plugin. Specifically, I would like to: Have the images open up in a lightbox. Sort and filter records. Disable the record view and larger views in airtable. Any help would be appreciated. Thanks! Frank

Hi! I’m new to scripting in Airtable and trying to figure out how to do something. I have 3 tables: Table3 contains a linked field to Table1 and a linked field to Table2, each limited to one record, along with a lookup field to a field in Table2. I would like to have a 4th table that automatically creates and updates one record for each combination of Table1 and Table2 that is contained on a record in Table3 that has a certain value in the look up field. It should contain a field that links to every record on Table3 that matches the linked field values for Table1 and Table2. Any help you could provide would be very much appreciated. Thanks!

I have 3 bases (let’s call them small, joker, and big) The entire relationship is built on ParentID and ChildID Small is connected to a joker (small is the child of the joker) Big is connected to joker (big is the parent of the joker) Joker can be connected both to Big and Small, but the tricky part is that it can also be connected to itself (A Joker can have a child that is a Joker and a Parent that is a Joker) I want to create a lookup in the Small base that shows me the name of the Big, which means that I need a script that looks at the parentID of the Joker and keeps going up the child-parent chain until it gets to the Big_ID. Can someone help me with this? Thank you in advance!

Hello, Is it possible to synchronize our database (SQL or CSV) with Airtable? We have a database (SQL) of vendors with different information such as name, turnover, number of products etc… We want when we add/modify/delete a vendor, product or something else to our database, that it automatically adds the new data to Airtable. Do you have a solution for me ? API ? Synchronize in real time ? We can generate a CSV several times a day with our data. In order to retrieve the data from this CSV to update it in Airtable. Thank you, David

Hey Guys, I currently have a functioning invoice generator that I modified from the “Product Catalog” Template Block. I’m realizing that while this does generate a visual Invoice, I can’t seem to find a way to import that data into Stripe or some form of online payment portal if I wanted to email that invoice over. What suggestions can I do to: Auto Generate a PAYABLE invoice by client. This does not need to be paid on airtable. but it needs to generate a link (Lets say stripe) to be sent to be paid via email.