Development & APIs

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.

I have a multi-select field with 10 options I have a single select with the same 10 options I want to run a script to take the value in single select and update the multi-select with it. For example, if the values in a record before running the script are: Multi-select: Apple, Bat Single-Select: Car After the script executes, I would like to see this: Multi-select: Apple, Bat, Car Single-Select: Thanks in advance!

I am trying to use Outseta authentication with my custom airtable app. I need to have the outseta tags at the top of my code and then a button with a specific link on it to trigger their auth-modal. Is this possible? The best I have been able to get so far is a new tab opening :slightly_smiling_face: Thanks for the help!

Blacklight detected an AirTable third-party cookie on my site? I would rather not “serve these up” to my end-users. Is there currently a way to disable these using embed code, and if not could you please develop it. Browsers are phasing out third-party cookies anyway, and it’s not a good look for AirTable long-term. edit: this post was marked as spam for some reason. Not sure if just I tried to post a reply containing the url

If my app is utilising a third part API I need a way to authenticate the user inside of airtable rather than storing the key in the global config. Has anyone seen a good guide on how to do this with firebase or something else? I would love some more information / pointing in the right direction. Thanks!

I’m looking for ways to customize the gallery view of an airtable base on my wordpress site. I like the mini extensions plugin but the $39/month price tag is out of my budget. Are there other ways to customize and embed gallery views on a website? Thanks!

Hi, I have a ‘Communiques’ table that lists the interaction I have with clients. I have just setup a Zapier that adds a new row to the Communiques table when a client emails me. What I would like to do is add an email column to the Communiques table - then have a script that takes the email and looks in my Contacts table to find an email that matches from the email column in Contacts - and then adds that Contact to the ‘Contact’ link column in the Communiques table. If anyone could give any input or let me know which functions I should look for and start with would be much appreciate.d Thanks!

Hi there - When I run this code, I am getting extra commas and the values are not lining up. What am I doing wrong? let vowels = “aeiou” let sentence = “Your bumpkin is so beautiful” let mda= let fullsetofzeros = var i var j for (i = 0; i < vowel.length; i++) { // p1 mda[i] = 0 } for (i= 0; i < sentence.length; i++) { // p1 fullsetofzeros.push(mda) } output.text( Matrix of zeroes ${fullsetofzeros} ) for (i= 0; i < vowel.length; i++) { // p1 for (j= 0; j < sentence.length; j++) { // p1 if (vowel.includes(sentence[j])) { fullsetofzeros[i][j]= 1 } } } output.text( Matrix after test ${fullsetofzeros} )

Hi there - When I run this code, I am getting extra commas and the values are not lining up. What am I doing wrong? let vowels = “aeiou” let sentence = “Your ass is so beautiful” let mda= let fullsetofzeros = var i var j for (i = 0; i < vowel.length; i++) { // p1 mda[i] = 0 } for (i= 0; i < sentence.length; i++) { // p1 fullsetofzeros.push(mda) } output.text(Matrix of zeroes ${fullsetofzeros}) for (i= 0; i < vowel.length; i++) { // p1 for (j= 0; j < sentence.length; j++) { // p1 if (vowel.includes(sentence[j])) { fullsetofzeros[i][j]= 1 } } } output.text(Matrix after test ${fullsetofzeros}) When updating my array, something strange happens