Development & APIs

Hey, guys. I have an issue with an integration of mine. I’m extracting a time from a string from Google sheets and then putting that time into Airtable. I want to put it into the duration field, but it will not accept it. Does anyone have any idea of how to format this correctly or work around the duration field paramaters? Thank you!

Hi y’all, I’m trying to use Zapier to perform an action on a comma separated string of records, where that string is variable in length. It could be four records long, it could contain no records. As you probably know, Zapier natively will not iteratively work through a list of records and perform the Zap’s step to each. Having the ability to perform the following steps on a list of records would be fantastic. Alternatively, if I could break that string of records out into individual items, I could set up a complex series of filters and repeating steps, but I’m having trouble with that as well. In the past, I’ve used Zapier’s Text module to separate text into separate fields using [:space:] or [:return:]. However, when I try to use comma as a separator, I only get the string of records back as the output, not the individual records. Go easy on me. I’m not much of a coder, and still a bit of an Airtable n00b. :slightly_smiling_face:

I’m trying to query Linked Records out of a Linked Record Field from the record selected by cursor. I am trying to do so inside a component that is nested 4 levels deep, and has had said record passed down to it through props. When I attempt to await the result of .selectLinkedRecordsFromCellAsync() I get an error: And when I attempt to get them directly from .selectLinkedRecordsFromCell(), I get nothing back in my const linkedRecords, even though I’m 100% certain I have Linked Records there to query:

I read through this thread and this one trying to find a way to remove escaped quotes /" from the API response on a couple of fields. It looks like, if the field is calculated (I could be misspeaking, I’m just a developer working with the API so I’m unfamiliar with how using the Airtable interface works.) and includes a comma, it’ll wrap the string in extra quotes in the response. Ex: Agency Name for Website: "\\"Hearing, Speech and Deaf Center (HSDC)\\"" I’ve tried all of these variations in filterByFormula: `SUBSTITUTE('\\"', '')` `SUBSTITUTE("\\"", "")` `SUBSTITUTE({Agency Name for Website}, '\\"', '')` `SUBSTITUTE({Agency Name for Website}, "\\"", "")` and all versions without escaping the double quote, and encoded each

Hi there, hope someone can help me. I am used to visual basic which is obviously different. Is there any good guides anyone knows about how to get used to this or pointers on where to find the information. So excited (I know sad) to get some scripts working so I can speed up some of my more repetitive stuff and use new features on my base which I use daily and love it. Cheers Mark

I know there is getView(‘ViewName’) to retrieve a particuilar view of a table, but what if you don’t know the name of a view, or how many views there are? Is there a way to fetch ALL the views of a given table? Something like this: let table = base.getTable("TableName"); let allViews = table.getAllViews(); // something like this? output.inspect(allViews); I have a custom Vue app and want to display a table’s records and then populate a navbar with all the views so a user can click links to switch the table view.

I have a table that has a text column containing filenames. Each record has a single filename in it. On my computer, stored locally, I have a folder that is full of the actual files referenced by the filename field. What I want to do is create a script that goes through each record, attempts to match the filename to one of the files in the local folder, and then if there is a match uploads the matching file as an attachment to the record. Does this sound possible? Or am I dreaming impossible scripting-block dreams?

Hi there, I am very new to Airtable and I am trying to build a database that is able to go to the website and pull all products along with their ingredient list in the order that is listed. I have added the clipper google chrome, but I am not sure how to set it up to pull correctly. I would love anybody to help with this!

I have been using an AirTable base with about 600 records for an MVP backend of a webapp built through AppGyver using Airtable’s API. Unexpectedly, I can no longer access the base, whether through the API or through the AirTable interface. I get the following message: the base is unavailable. And I am certainly not sending over 5 API calls a second. What gives?

Hey! So, I have been using the scripts and absolutely love it. Is there a way I can freeze the first two columns in the options? Would be great to have official support for the same, because my data output size is huge and needs to be frozen for viewing easily. If anyone has written a Chrome plugin, do let me know, else happy to hack over the weekend. Thanks,

Hi! Is a composition of custom blocks available? In UI guidelines I found this phrase: You don’t need to build charting into your block if users can install the existing chart block alongside your block. Does it mean that a user can install one block inside another one?

Hey everyone, I’m a “Shortcuts developer” (for lack of a better word) and I tend to use Airtable’s API frequently to log records, retrieve them, and update them. Just curious if anyone else does the same! I see a thread from a few years ago, but it’s gotten even easier with the Shortcutify app lately.

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

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

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)

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

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`