Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
D
Douglas_SousaNew Participant
posted in Development & APIs
REST API - Fetch collaborator's picture

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

90
D
A
Al_MoNew Participant
posted in Development & APIs
Airtable and API use under the Terms of Service

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

40
A
H
Handi_SetyadiNew Participant
posted in Development & APIs
How to insert hyperlink to set of defined keywords within Rich Text?

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!

91
Justin_Barrett
B
Boutique_KKONew Participant
posted in Development & APIs
Add multiple row async

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

31
Justin_Barrett
I
IT_DepartmenrtNew Participant
posted in Development & APIs
importQuery.records filter help please

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

52
Justin_Barrett
E
Evgeny_BylymNew Participant
asked in Development & APIs
Get the number of records in a table via API

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!

23512
Justin_Barrett
A
Adrian_HeadKnown Participant
posted in Development & APIs
Creating mac folder structures with scripting app

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!

22
ScottWorld
A
Ahmed_KachkachNew Participant
posted in Development & APIs
How to use a package that imports a CSS file (not handled by block)

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

180
A
H
Helen_KentNew Participant
posted in Development & APIs
How to create new record with text of linked record rather than recordid?

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

32
H
M
Matthieu_LABERIInspiring
posted in Development & APIs
Integromat : Upload picture from Google drive to Airtable

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

12
M
S
Sergey_RoyzNew Participant
asked in Development & APIs
Unable to install blocks-cli

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

470
B
M
Michael_TownsenInspiring
asked in Development & APIs
Link a record to another record automatically

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

154
Justin_Barrett
Z
Zachary_HunterNew Participant
posted in Development & APIs
Trouble appending linked record

I have looked at other postings regarding this same topic and cannot determine why I keep throwing a specific error. We are attempting to utilize a project management setup where there is a list of issues. An issue can be a parent or can be linked to a parent record (in a linked record field called “Parent”). For sorting and interface purposes, I am working to set up an automation that will add the children to the parent record (in a linked field called “Child”). I’ve written a script that will allow the child records to be appended, but I keep getting an error that the Child field “cannot accept the provided value” when I try to spread the existing array. What am I missing here?

93
Z
M
Matthew_MoranInspiring
posted in Development & APIs
Two way base updates - aka: dynamic synchronization. How to do this manually/via API?

I am building a fairly simple projects and tasks list. However, we need to isolate tasks and information between individuals who the tasks are assigned to. To do so we need to have a master project/tasks base and a series of other bases where tasks will be copied/synced to. Those bases will have 1 to 2 individuals assigned to them. They will view their tasks in their own base and when they make updates, their updates will write back to the master list. I store the master record ID and the child record ID for each task assigned. Right now, I write from the master table to the child when a record is added or updated using a webhook but today will switch to using the API key so that I can get a more complete response from any given update. My question is general: Who has done something similar - two-way updates between bases - and what was the logic and triggers you used? Not the code - more or less the concept. For instance, in a child base, the person can add a tasks as well but I need

173
Alexey_Gusev
Alexey_Gusev
Alexey_GusevBrainy
asked in Development & APIs
Issue with POST to the php-site, using remoteFetchAsync in Scripting app. Filled form data passed as empty form due to Redirect 302

Hi, i’m strugling with it 3rd day and read many docs about querying with fetch on JS, but seems like my understanding of web stuff is not enough. I used similar method for fetching from API with JSON, or from simple html site parcing text, but here I can’t achieve desired goal. Site is a base of clients, sorry but for now I didn’t have approve to disclose real name. https://search.somelongdomain.com, reloading to https://search.somelongdomain.com/ClientSearch.php?Accept=Accept it contains form with “Name”, “LastName” etc, then “Start Date”, “End Date” and two buttons, Search and Reset. After submitting “start_date”, “end_date” i press Search and have list of Clients registered within this period, 20-50 names for 2-3 days, and that’s my desired result. output loaded as https://search.somelongdomain.com/NamePick.php, it’s a form with name table and checkbox near each, but that’s ok, i know how to extract my data from any type of text format is html text, site looks a bit old, it doesn’t

81
Alexey_Gusev
L
Luis_BritoNew Participant
posted in Development & APIs
Support for .env files

Any plans to add support to environment files? I’ve tested but it seems blocks SDK don’t have support. Create React App has support for this. It’s a kinda basic feature and would be super useful. Thanks

141
Justin_Barrett
Andrey_Kovalev
Andrey_KovalevInspiring
asked in Development & APIs
How to put an Array into Object?

Hello everyone! This is probably a simple question, but I could not figure out the answer. I have an Object and two arrays: const arr = [1,2,3]; const arr2 = []; const obj = {}; obj.id = arr[0]; obj.fields = {}; obj.fields["Array items"] = arr; arr2.push(obj); console.log(arr2); //array contains 3 items as expected arr.length = 0; //empty array console.log(arr2); //array is empty As I understand the Object instance keeps only a pointer to the array. Is it possible with an Object to keep a copy of array contents and how to achive that? Thank you in advance.

650
Alexey_Gusev
D
Daniel_StuddsNew Participant
posted in Development & APIs
Are airtableblocks.com domains unique per app?

How are airtableblocks.com domains generated? Trying to whitelist domains for my app and wondering if that is possible.

20
D
S
Santiago_MilitoNew Participant
posted in Development & APIs
Where do I find the client secret?

I’m trying to find the X-Airtable-Client-Secret inside Airtable Account URL. But it isn’t there. Reading this Airtable API Meta I thought I was going to find it inside airtable.com/account but it doesn’t seem so. Where do I find the airtable client secret ? thanks in advance

1051
Justin_Barrett
L
Luis_BritoNew Participant
posted in Development & APIs
useBase and useCursor not working properly

useCursor does not re-render my component when the active Table or active View changes useBase does not re-render my component when I add or remove tables or when I rename fields This was working a week ago. Any feedback?

34
A
EricWongMusic
EricWongMusicParticipating Frequently
posted in Development & APIs
API Updating Script in Automation

Hi, everyone! I need some hints to solve the scripting problem. I am not a programmer and only know easy html. Please let me explain what I am trying to do and see if you can help. I have setup a sync of a table 禮儀選曲 from Base A to Base B, so both Bases has the same set of data in this table. I have created a VIEW for any records meeting the filtering criteria in both bases. I have setup an automation to create a record in a table 選曲表 of Base B triggered when any record(s) appear in the VIEW. The data of the new records are from the table 禮儀選曲. The recordID of the original record is also stored in the new record. Until this point, everything work fine. I need to update the original record with the recordID of the auto created record. Since the automation cannot update record in another base, I have to use an API request to do this. I am just don’t know how to write this script to make it work. Please see my script and attached screenshot. Thanks for anyone would like to help! It is a c

40
EricWongMusic
Ruchika_Abbi1
Ruchika_Abbi1Inspiring
posted in Development & APIs
How to update multiple linked record field through script

I haven’t been able to figure out the syntax to update a multiple linked record field through a script. I want to add to the linked records. I’ve looked through the multiple posts that address similar questions, but somehow none of the changes are working. :see_no_evil: Any help appreciated!

20
Ruchika_Abbi1
Jack_Manuel
Jack_ManuelInspiring
asked in Development & APIs
Best way to read and write record as fast as typing?

Any help on this issue would be really appreciated! I’m making a simple app to create quotes. I’ve got everything up and running to edit fields with the <Input /> component and for anything other than text it works great e.g. function updateRecord (quote, recordFields) { quotesTable.updateRecordAsync(quote, recordFields) } <Input name="Hire Start" type="date" value={quote.getCellValue('Hire Start')} onChange={(e) => updateRecord(quote, {'Hire Start': e.target.value})} /> However, when the input type is text (or currency, anything that can be typed quickly), there’s a very noticeable delay in the update to the cell value which makes input glitchy and, if you type fast enough, inputs get dropped. I then switched to controlling the <Input /> with a state object, only writing back to Airtable in a useEffect() that watched the state object. This solved the issue but now updates made in Airtable (outside of the app) are of course not reflected in th

210
S
K
Karthikeya_AlaNew Participant
asked in Development & APIs
Does Airtable allow to read the content within/ inside the documents/ attachments with its own APIs?

Does Airtable allow to read the content within/ inside the documents/ attachments with its own APIs?

81
ScottWorld
M
Michael_TownsenInspiring
posted in Development & APIs
Financial reporting dynamic changing past data

The problem I’m having is that I use airtable for my financial reporting and because its a relational database if I (or someone on my team) changes data in one base itll change all my past financial reports… Is there any workaround for this? Possibly an app that can capture the dynamic data and make it static so I dont have to copy/paste each month into a google spreadsheet…?

173
M

Badge winners

Show all badges
Terms & Conditions