Development & APIs

Hey Y’all, Is anyone familiar with Google Data Studio? Context: I’m playing with an idea of archiving data from Airtable. To do that, I’m routinely exporting the JSON output from the API, and appending a CSV in Google Cloud Storage. I’m using that CSV to create a report in Google Data Studio. Problem: I’m at a loss of how to leverage Linked Records in visualizations, which output from the API as an array of Record IDs. Currently, Data Studio only sees them as strings. Questions: What are my options for replicating many-to-many linked record relationships in Google Data Studio? Will I need to load my data into Big Query first? If so, what are some best practices/suggestions for working with Big Query I can leverage? Links are much appreciated! Thanks in advance!

Hi I’m trying to build a script that updates a multiple select field from one option “option1 / option2 / option3” into multiple options after I map through the string to make each word an individual option. Example Before: option a : "option1 / option2 / option3" After: option A: option1 option B: option2 option C: option3 Any ideas on how this could be done?

I’m trying to simply copy text from one column to another. Only about 20% of the records are being copied over. However the console logs each name correctly… Im using this script, which i’ve edited for my own use from here: Using a script to add values from one field to another Scripting app Hi @Jens_Schott_Knudsen1 - try this script: // set the table let notesTbl = base.getTable("Notes"); // get the table records let notes = await notesTbl.selectRecordsAsync(); // loop through the records for (let record of notes.records) { // set variables to the record values let notes = record.getCellValue("Notes"); let notesHistory = record.getCellValue("Notes History") // set variable for today's date let now = new Date().toLocaleDateString("en-GB"); // define the new… // set the table let table = base.getTable("Inventory Item Summary"); // get the table records let itemCode = await table.selectRecordsAsync(); // loop through the record

I have a script that calls an API and writes the JSON objects to my table. This has hit the limit of what I know about scripting. Can anyone help modify my script so that on the next call, it will update any records that exist and insert any records that are new. I assume I need an IF statement to look for an existing ID and validate if the associated string matches ELSE create a new record. My existing script is: let response = await remoteFetchAsync(“APIURL”, requestOptions); let json = await response.json(); let table = base.getTable(“Titles”); for (i=0; i < json.length; i++) { let recordId = await table.createRecordAsync({ “Title”: json[i].Title, “ID”: json[i].ID }) }; Thanks!

Currently, I am using the API to get record(s) information. I have a query like this: filterByFormula=Search(‘478-1160-1’,Upper({MD Part Number})) which the syntax is working either by returning 1 or more records. However, I am wondering if there is a wild character that I can pass in case that instead of “dashes” there is spaces or other character. So I can do something like: filterByFormula=Search(‘478%1160-1’,Upper({MD Part Number})) Thanks in advance.

Hi! We sync Airtable records to our own bases via Airtable API. The thing is when a record is deleted in Airtable it just vanishes from Airtable API. To discover deleted records in API we have to iterate all records in both source and destination bases. Then delete records in destination with Airtable Ids that are missing in source. Is there a way to track deleted records in Airtable to delete them in destination base without a one-by-one comparison? Thank you.

Given this record “fields”: { “Opportunity name”: “Timbershadow expansion”, “Owner”: { “id”: “usrTqRt8glK7HcmEg”, “email”: “katherineduh+collab8@demo.htable.com”, “name”: “Casey Park” } I want to perform a filter to exclude it. Neither of this worked and I can’t find an info on the pages: var filter = “NOT({Owner.name} = ‘Casey Park’)”; var filter = “NOT({Owner}{name} = ‘Casey Park’)”;

Has anyone been able to make an api call to remove.bg from scripting or a script within an automation?

It’s curious to me that the last mod time for any cell is not available through the scripting, REST, or metadata API as part of any records’ metadata. For example, I would think that for Airtable to display the data in a last mod time field, especially comparatively when more than one field is specified in the config, the last mod time would need to be stored somewhere. Perhaps I am just thinking about it incorrectly. That the cell values update accordingly when the last mod time field is reconfigured (e.g. a specific field has a date from months ago, but when the last mod time field is reconfigured to show all fields and something was updated today, it shows a date-time value from today) makes me think the data must be somewhere… just not accessible :frowning: :man_shrugging: Per the API doc on lastModifiedTime, the cells are read only and creating or updating such fields is unsupported. Where or how does Airtable gets this data when a last mod time field is created and configure

Hi - I saw this tutorial but it isn’t quite specific enough. DEV Community Using Airtable as backend service The hell of finding the right backend When it's time to write a Single Page Application in... How is it possible to duplicate this with a bit more specificity? Embed a javascript section into a website?

it works once and the second time i try to run it (without modifying it at all) it just resets. Seems like a bug to me. WIll delete and leave for another day as it’s causing major annoyance… Thanks

Hiya, I’m using nextjs and using the airtable npm package. I have an emails table and I want to check whether I already have an email in the base so thought I could try to retrieve one. Firstly…this seems like a GET but with a body…? Does that work? Secondly, what am i doing wrong here? When i try and test it in postman it doesnt work but i’m not sure what i need to do. Help would be appreciated!

I Have this code let settings = input.config({ title: "Datas aleatórias", description: ``, items: [ input.config.table("table", { label: "Table" }), input.config.field("field", { parentTable: "table", label: "Field to randomize", }), ], }); let { table, field } = settings; output.text(`Randomizing ${field.name} field in ${table.name}.`); let bounds; switch (field.type) { case "date": bounds = await inputBounds(async () => { let min = await inputDate("What should the earliest date be?"); let max = await inputDate("What should the latest date be?"); return await confirmBounds(min, max); }); await updateField((record) => lerpDate(bounds.min, bounds.max, record)); break; case "dateTime": bounds = await inputBounds(async () => { let min = await inputDate("What should the earliest date time be?"); let max

Hello, everyone; first topic here! I’ve known Airtable for a little while and done some tests and now I’m trying to use the API. Is there an endpoint for fetching collaborator’s data? There was some topics in here asking that but I didn’t find the HTTP endpoint for that in them: API not returning profilePicUrl on Collaborator column API Hello! The API seems to not return the profilePicUrl on the Collaborator field, even doe the collaborator has a profile picture. Does anyone have the same problem? API List all base collaborators API I use a work around, I have a table with metadata in. I would like table metadata accessible too! It’s quick to update but not automatic. Each row is a table name from the current database. One field is a multi collaborator type field with all the current collaborators added, another field is a multi tag type with all the tags included etc. Then I get use that information to populate combo box’s

Hi all, I was being diligent and read the ToS for Airtable and the following section caught my attention: 1.2 Access, Restrictions, and Use […] Except as we otherwise agree in writing or to the extent a restriction is prohibited by law, you agree not to do, and not to assist, permit or enable any third party or Application (defined below) to do, any of the following: … use any robot, spider, scraper, data mining tool, data gathering or extraction tool, or any other automated means, to access, collect, copy or record Airtable; […] Now, I’ve developed a small web application that acts pretty much as a “front” to some user’s Airtable data. It works like this, User puts a contact form in their website, when someone signs up, that data goes straight to some Airtable base. After that, I provide said User with info and tools to query “how many people are signing up?”, “list of emails that have been recorded”, etc… I am doing all of this using Airtable’s API in the intended way, following

Hi! Im very new to airtable so please forgive me if i ask a silly question Im publishing hundred of blogs every month with Rich Text field in Airtable. I need to put hyperlink on certain keywords in each of our blog Im wondering whether we can create script / automation / anything that allows us to set: defined keywords defined url and automate the hyperlink placement for our blogs? thank you!

Hello, Sorry for my bad english. II have a beginner’s problem. I am unable to add a multitude of rows to add to a table by merging two other tables. I manage to create the function to do it, but airtable blocks beyond 15 lines. I don’t understand how to do the asynchronous function. I think we should add each field to an object and then transfer it with the asynchronous functions. Can you tell me how to create this temporary object with a loop. Thank you Here my code import { initializeBlock, useBase, useRecords, expandRecord, TablePicker, TextButton,} from '@airtable/blocks/ui'; import React, {useState} from 'react'; const BATCH_SIZE = 15; function Cretionproduits() { // YOUR CODE GOES HERE const base = useBase(); const tableLogos = base.getTableByNameIfExists('Logo'); const recordsLogo = useRecords(tableLogos); const tableSuppports = base.getTableByNameIfExists('Support'); const recordsSuppport = useRecords(tableSuppports); const

Hi All, I’ve writing a script that uses an automation to create a list of tasks. So what I have is an onboarding base with a table full of onboarding tasks, when a record in the employee onboarding table is added it need to create a list of task, based on there Job Title, so need to filter the list to only create the tasks that are relevant to the Job Title. This is the script so far: let inputConfig = input.config(); output.set(’’,${inputConfig.FirstName}); fname_var = ${inputConfig.FirstName}; output.set(’’,${inputConfig.Surname}); sname_var = ${inputConfig.Surname}; output.set(’’,${inputConfig.StartDate}); sdate_var = ${inputConfig.StartDate}; output.set(’’,${inputConfig.StartLocation}); sloc_var = ${inputConfig.StartLocation}; output.set(’’,${inputConfig.JobTitle}); jtitle_var = ${inputConfig.JobTitle}; output.set(’’,${inputConfig.PersonalEmail}); pemail_var = ${inputConfig.PersonalEmail}; output.set(’’,${inputConfig.LineManager}); lnman_var = ${inputConfig.LineManager}; let import

Hi! How to determine the number of records / entries in a table via API using curl / php / pyton? Imagine a table with 12304 entries. Our current stumbling block is the API limit: we can only get 100 entries at a time via the API using PHP. In this regard, we have to make a lot of requests page by page. Then count the number of pages and multiply them by 100. Is there a more elegant way? Thank you!

Hi there! Looking to see if it’s possible to use the scripting block to create a folder structure from my airtable records that I would be able to download (presumably from an attachments field) and use right away in finder on my Mac! Possibly interested in hiring someone to make this happen if it makes sense!

Hi! I’d like to port an app I’ve been building to be an Airtable custom app, but my codebase heavily uses CSS imports everywhere (+ an important dependency I have does the same). This doesn’t seem to be supported by block; seems like all it would take would be to change the webpack config to use webpack’s CSS loader: webpack css-loader | webpack webpack is a module bundler. Its main purpose is to bundle JavaScript files for usage in a browser, yet it is also capable of transforming, bundling, or packaging just about any resource or asset. FTR the error looks like this: Module parse failed: Unexpected token (7:0) You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders > .some_css_class_here { .... Importing CSS files is used by create-react-app and most React examples, and would help lots of developers start porting apps t

Hi, I have two simple tables votecount: cityid (text e.g. ‘Birmingham’) emails (linked to emails) count (number) emails: emailid (number…) email (email address) votecount (linked to votecount table, displays the cityid) On my react app, i want users to enter their email address and select their chosen city. I want to post that data to my airtable base. I’d like to simply post the email and the city name (not the linked record id) to the emails table. Please could someone give me a hand with how to do that? I read something about typecast:true but i dont quite understand how that works. Thank you

I, I upload picture (bar code) from Google drive to airtable throught Integromat. But, the pictogram of the picture appear first time and desappear just after on Airtable. Sometime it work, sometime it do not work, it’s difficult to learn on it. You can see my scenario on integromat : I respect everything i see on web : Can you help me please ? Maybe something wrong on my configuration ? Is there an alternative ? Thank’s a lot, Matthieu

Hello, I’m trying to create a new block, but npm install -g @airtable/blocks-cli is not working The error log: ERR! stack at maybeClose (internal/child_process.js:1021:16) node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:286:5) node-pre-gyp ERR! System Darwin 19.3.0 node-pre-gyp ERR! command “/usr/local/bin/node” “/usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/.bin/node-pre-gyp” “install” “–fallback-to-build” node-pre-gyp ERR! cwd /usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/nodegit node-pre-gyp ERR! node -v v12.18.0 node-pre-gyp ERR! node-pre-gyp -v v0.13.0 node-pre-gyp ERR! not ok Failed to execute '/usr/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/nodegit/build/Release/nodegit.node --module_name=nodegit --module_path=/usr/local/lib/node_modules/@airtable/blocks-cli

I have a Timesheets base with a “Timesheets” table that is filled when my workers submit timesheets each month. I have a separate “Rates” table (in a different base) that is synced to my Timesheets base and table. In this Rates table, I have a list of rates connected to each of my referral partners, including a start and stop date. If they do not have a stop date then that rate is considered active, if it does have a stop date than that is not an active rate. My problem is that I am currently manually syncing the Rates table Referral partner to the Timesheet entry, and it’s too much work and error prone. The whole point of doing Rates in a different table was to not break that past timesheet entry’s as you can see here: Financial reporting dynamic changing past data - #3 by Justin_Barrett I am looking for a script that can automatically detect what record selection to make in the Timesheets table from the Rates table, connecting my referral partner to the timesheet. The identifier can