Development & APIs

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

HI there - I am wanting to try to efficiently add various combos of multiple arrays to try to find a set that has non-zero elements. This is an abbreviated version. I have a set of ~300 arrays x 30 elements in each array to try to find a complete set of sets. let arr1 = [0, 1, 0, 1, 0, 1, 0, 0, 1, 0] let arr2 = [1, 0, 0, 1, 1, 1, 1, 0, 0, 1] let arr3 = [1, 1, 0, 1, 1, 1, 0, 0, 0, 0] let arr4 = [0, 1, 0, 0, 1, 1, 0, 1, 0, 0] Update: Assume that instead of individual arrays, there is one matrix and we are adding the combination of columns in matrices to find a matching set.

Hi, I just paid for the Pro Account on Airtable even though I was not finished with the 14 days trial period since signup. However, it still shows I am on Pro Trial and does not let me use the scripting blocks in the automations. This is a problem because it is a big blocker for my project. Hope someone can help. Thanks!

Hi all! I am not very good at JS, but I have to figure out a way to built a robust front end for an Airtable base and I have zero budget (I might as well start working on world peace while I’m at it). I have figured out how to retrieve and log (Logger.log) all the data in a particular table (believe it or not I can return all 3500+ records in a couple of seconds), but does anyone know how to display the data that is returned as raw JSON in the HTML page created when I deploy the google script as a web app? I guess it would be helpful if I explained the use case. I have a table, “PartNoInfo”, that is linked to a “Concentration” table. The “PartNoInfo” table contains the metadata and calculations. The “Concentration” table has the individual concentrations, as well as lookup data from the linked table “ComponentData”, which has the information required for the calculations in the “PartNoInfo” table. I am trying to set up an UI where the user can enter a part number a

Hi guys! I’m fairly new to AirTable, especially using it in a backend server. I have created relational databases in SQL before, and I have designed my database just like how I did with SQL. However, I do not know if AirTable has a JOIN command that can join two tables together in Node.JS so that I can look up data across different tables that intersect. If so, how do I do that on AirTable? So far I have created Persons, Students, Mentors, Addresses tables and I have not been able to query them and join them together. Thank you!

So, I’ve been trying to bulk add some fields to the table using the suggested code in the API: base('GameRefereeSlots').create([ { "fields": { "GameCreation": "49", "Fee": 10, "Expenses": 10, "Type": "Referee" } }, { "fields": { "GameCreation": "49", "Fee": 10, "Expenses": 10, "Type": "Referee" } } ], function(err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { console.log(record.getId()); }); }); This, however, does not work as it returns the following error: message: “Invalid request: parameter validation failed. Check your request data.” statusCode: 422 I’ve tried different alternatives by removing the “field” key and just having the plain object but it does not work. When adding only one of the options without it being in an array, i.e not batch adding, it works perfectly. Any thoughts on what could

Hey, was anyone able to use vis.js timeline (Vis Timeline Examples) in blocks? I have tried to make it work for a while but I cannot figure out how to render the timeline with the functional style of the blocks. How can I workaround the “build on a div element with a certain id” approach?

Hi I wanna script a (+1) button, somehow (like) button… to increase (or decrease) number in a filed For example, When I click this button, the filed X become (10) instead of (9) Thanks