Development & APIs

we did a script to import data from an external api and works fine, but when adding a field that has a relation to another table the script does not insert of gives any error. does anybody has an example or reference for documentation in adding a record with related data on it?

Hello, I was working on a fetch to a site to retrieve JSON data with Basic Authentication. I got around the CORS block by setting " mode: ‘no-cors’" in my call to fetch. But I ran into a more serious problem. My calls to fetch() are not returning any data even if successful. Here’s my test program: var url = ‘https://www.google.com/thisshouldfail’; var url2 = ‘https://www.google.com/’; var response = await fetch(url, {method:'GET', mode: 'no-cors'}); var response2 = await fetch(url2, {method:'GET', mode: 'no-cors'}); output.inspect(response); output.text(response.status); output.inspect(response2); output.text(response2.status); The output to this running is: {} 0 {} 0 Looking at the browser’s network log I see the calls return the correct HTTP codes: GENERAL: Request URL: https://www.google.com/thisshouldfail Request Method: GET Status Code: 200 Remote Address: 172.217.9.228:443 Referrer Policy: no-referrer-when-downgrade GENERAL: Request URL: https://www.google.com/ Request Metho

I’m trying to make a script to make product planning easier in conjunction with the gantt chart. I have four fields. startDate (date) endDate (formular) depended (link field to same table) lookUp (looks up the endDate via the depended link field) In the first record I put I set a startDate and endDate gets automatically calculated based on various parameters. in the second record link to to the first record and and the look up field looks up the above endDate, which my script then passes into the startDate and then it stops. My problem is that I want to have a bunch of records stacked on top of each other. Set the dependency field (which job it should follow) and press a button and then it’ll pass the lookUp endates into every start date, but because the lookUp takes a little time to update, it stops after the the first date. Is there away to make kind of make if loop over itself again and again until all dates with dependencies are filled? const luPlanRecords = await prodView.select

For integration testing against Airtable API, it would be nice if it supported a “dry run” option which would fully validate the request on the Airtable side but wouldn’t actually write anything.

Sometime in the past few days I have not been able to export to CSV from an Airtable embedded in the www.adveritasdx.com website (go to Test Database). There may be some browser dependence - having trouble with Chrome and the latest version of Edge; old version of Edge works. Has there been an update to Airtable recently that would casue this?

Do you have an idea for the Custom Blocks contest but don’t know where to start or which examples are most relevant to your idea? We’re hosting a live Ask Me Anything (AMA) session in this thread on Wednesday (6/10) at 11am PT. Michelle Valentine and Kasra Kyanzadeh from our product team will be available to answer any questions about getting started and turning your ideas into reality. The top 3 upvoted questions will win a $40 Amazon gift card. You can even start posting your questions now, and we’ll be answering questions live from 11am - 11:30am PT on Wednesday. See you there!

I want to access Airtable Blocks SDK to create a custom block, but that option is gone for me, even though I have a Pro account. All I see under Block Categories is: Featured Blocks by Airtable All blocks Please help!

Hi there! I and my team are trying to figure out if it’s possible to automate the process of creating presentations from Airtable data. Something like - data from Airtable will populate some fields in our PowerPoint presentation. Guys, please, share your ideas. Thanks.

I have a TablePickerSynced that I’d like to filter the options for. I’ve got the element conditionally disabled based on the presence of a selection in another TablePickerSynced: <FormField label="Which table holds the Events/Bookings?"> <TablePickerSynced globalConfigKey={GlobalConfigKeys.APPOINTMENTS_TABLE_ID} onChange={() => apptCheckTablesAreNotSame()} size="large" maxWidth="350px" disabled={!props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)} /> </FormField> …but I’d also like the Tables available to be picked in this second TablePickerSynced to be filtered to only include those Tables to which the table selected in the first TablePickerSynced (props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)) has a Linked Record relationship. Is this possible? I don’t see anything in the documentation that would indicate that it is, but I know the FieldPicker can at least disable certain options within the picker

We’re starting work on our first block for the contest and there are a few questions I was hoping we can get an answer to: Will blocks, after being published, automatically show in Airtable for whoever wants to use them, or there is another submission process we need to go through? To what extent do new custom blocks require to be open-sourced, beyond the contest? For example, there are many integrations like Typeform and others, which have to be in sync with their servers & not open sourced for obvious reasons. For the contest, I presume the blocks submitted need to be free to use. Are there any considerations we need to keep in mind if we plan to offer subscriptions to future blocks, right inside Airtable? (as to minimize friction) And lastly, this isn’t a contest-specific question - but we were supposed to get “a 3-month Pro trial on your workspace” from Devpost in order to build the block, but the URL in the email doesn’t work. Can someone at Airtable update this accoun

Is it possible to pull all the “Views” of a given table via the API? I don’t mean specify a particular view as part of an API call, but rather, I want to pull ALL the views of a given table as its own list. The table object doesn’t seem to have a views object anywhere that I can find: 1. destroy: (...) 2. fetch: (...) 3. fields: (...) 4. id: (...) 5. patchUpdate: (...) 6. putUpdate: (...) 7. replaceFields: (...) 8. save: (...) 9. updateFields: (...) 10. _rawJson: (...) 11. _table: (...)

Is there a way to integrate a living google sheet that is produced by google forms into airtable?

Hello! I am trying to do the `Hello World but there is no option to “Build a Custom Block” in my base. Can someone help? I have a Pro account. Did they remove this feature? Thank you`

When Custom Blocks go live, if I were to design a base that is deeply integrated with a Custom Block (to basically create a mini application within Airtable), and add that base to Airtable Universe, when people copy that base to their workspace, would the Custom Block go with the base? Would it work seamlessly as Airtable’s blocks do? Would it receive updates if I update the source code of the block and re-release the base to the Universe? I guess I’m also just wondering how exactly these Custom Blocks will work in terms of an “open marketplace” for these things. If Airtable chooses to remain entirely hands off in allowing the free exchange of Custom Blocks via public GitHub repo’s, I can see the environment quickly devolving into a mess of poorly maintained, or unmaintained Blocks roaming around in the wild, perhaps lingering on aggregation lists/sites for years after they have gone defunct, and making it difficult for consumers to know, when they go to install a Custom Block, whether

I’m using the CollaboratorToken component: Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. but getting an issue. This works: <React.Fragment> {base.activeCollaborators.map(choice => ( <div> <p>{choice.id}</p> <p>{choice.name}</p> <p>{choice.email}</p> </div> ))} </React.Fragment> but the code in the docs is giving me an error: <React.Fragment> {base.activeCollaborators.map(choice => ( <CollaboratorToken key={choice.id} choice={choice} marginRight={1} /> ))} </React.Fragment> Any pointers on this one? I’m importing CollaboratorToken, useBase so think all is good there. Thanks!

Hi Airtable! I thought I would post this to notify users of GDrive and Gmail and users of their API. My understanding is that those users that have an active subscription with Google Suite are exempt from this verification process. My understanding is that Google is having all users of GDrive and Gmail to go through a verification process. This is in connection to users using their (Google) API’s. I believe that this has to do with those that use Integromat. I don’t know if it will affect Zapier. Here is a link to Google about this: https://developers.google.com/apps-script/guides/client-verification Thank you, Mary

Like the title above says, Is there a way for custom blocks to communicate with each other? For example passing data from one custom block to another which is installed by the user

Hi guys, Totally new here, moved from google sheets today. I’m looking to build a restaurant delivery app with an Airtable backend. I currently have a script I made on GS that pulls an address from one cell & calculates it’s distance in km to a predetermined address in the script (restaurant address). To what extent can I just copy this script over? Haven’t seem to make it work yet! Thanks in advance, Josef

I’m trying to connect to the API with a private code playground such as Codepen for quick experimentation. I’ve added the retrieve script to the JS editor: var Airtable = require("airtable"); var base = new Airtable({ apiKey: "key123" }).base( "app123" ); base("Base").find("rece123", function (err, record) { if (err) { console.error(err); return; } console.log("Retrieved", record.id); }); But I get this error: Uncaught ReferenceError: Airtable is not defined I’ve tried linking to the Airtable CDN but that hasn’t worked. What else am I missing to get this to work? Is there a simple way to get Airtable running in a JS editor in the browser? It’s private so the API key is protected. Here is a sample pen (not private with dummy key) https://codepen.io/meowpower/pen/eYJNoXK?editors=0011 Thanks in advance

Hello, I am working on writing a script for work, and as of about a week ago I ran into an error that I can’t seem to wrap my brain around. From what I can tell this doesn’t appear to be a standard JavaScript error, and I am concerned as to whether or not this correlates to some sort of change the Airtable development team may have made on the backend? Up until about a week ago a TypeError was causing some hangups, then this arose spontaneously without any changes to my code. Below is a screenshot of the error being thrown:

Hello, I have a field where I have a list of collaborator. I’m developping a block and I would like to get all the users ID from my field of my table. Currently I can get the name of the collaborator with : const base = useBase(); cont table = base.getTableByNameIfExists(“name_of_the_table”); const value_user = my_record[0].getCellValueAsString(“Name_of_collaborator_field”); I got the name of all my users in the value_user But now, I would like to get the list of user ID. How can I got it ? Thank you :winking_face: . Viken

I’m trying to format a bunch of date ranges to be used in WORKDAY(). I created a script that collects these dates from a base and have them converted to iso-dates. However all my dates has a trailing time stamp of T00:00:00.000Z. Wondering if there is a quick way to omit of the time stamp so it’s only YYYY-MM-DD?

I’m new to JS and been playing around with the scripting block, quite alot. I’ve been wondering about the use of the await keyword. I think i learned somewhere that await can only be used to consume promises inside async functions. Await is used in the main code. Is it me who is wrong or is the script block one big async function?

I’m trying to submit a url query with a filterByFormula to return only dealerships that have the specific brand in them. The brand side is linked, so it’s in a list on the return response and it’s by record ID. How do I build a filterByFormula that will look into a list instead of just the 2nd level value within fields?

Can we automate in a way where we can delate the duplicate entry in airtable on the basis of time stamp or the previous entry?