Development & APIs

Hi, I think I’ve figured out how to retrieve a unique record in my table using the following filter, but how can I get the ID of resulting query? let filteredRecords = query.records.filter(record => { let name = record.getCellValue('Order/Shipment ID'); return name !== null && name === range }); I’ve tried the following but am getting an error let filteredRecordsResult = filteredRecords.records[0]; output.text(filteredRecordsResult.id); Error: TypeError: Cannot read property ‘0’ of undefined

Hi, is it ok to integrate the block functionality inside another app for displaying purposes?

I have a fairly large base (approx. - 20k records, 20 tables, 300 fields, hundreds of views, etc.) and I am no longer able to open the IOS Airtable app (keeps crashing). Also tried to open via desktop mode on iPhone10 browser but crashes too. I must currently use a desktop/laptop to access my base. My temporary workaround was going to be use a shared view/snapshot of the information that I always need when away from desktop/laptop (view only/no editing) which would limit the records down to the view of a few thousand records. That worked ok, however I can’t filter & sort the information using the mobile website. Tried switching to desktop mode, which would have worked great, but I can’t scroll the base up/down & left/right. Any performance updates coming to IOS App? OR ability to filter/sort on mobile website views? OR ability to scroll on IOS with browser in desktop mode? Thanks.

Hey guys! Fairly new to scripting so bare with me. Wondering if it possible to export a spreadsheet at the end of the day using a script. This is for an inventory management system for a resort, and we would like to export the logs of the spreadsheet at the end of everyday via an IPAD. Ideally a staff member could press the script, and it would automatically export and save somewhere on the cloud. Any help with this would be greatly appreacied.

Hi all! I’m trying to create a new table using base.unstable_createTableAsync following the example in the guide. This is the code I’m using - const fields = [{ name: "MyField", field: FieldType.SINGLE_LINE_TEXT }]; if (base.unstable_hasPermissionToCreateTable("MyTable", fields)) { await base.unstable_createTableAsync("MyTable", fields); // and create records } But I keep getting the error Uncaught (in promise) Error: Can't create table: invalid field config for field 'MyField'. Creating or updating options for undefined fields is not supported at this time. at Mutations._assertMutationIsValid (bundle.js:formatted:7299) at Mutations.applyMutationAsync$ (bundle.js:formatted:6813) at tryCatch (bundle.js:formatted:94903) at Generator.invoke [as _invoke] (bundle.js:formatted:95131) at Generator.prototype.<computed> [as next] (bundle.js:formatted:94956) at tryCatch (bundle.js:formatted

Hey everyone, my name is Stephan, I am a designer and have an idea for a quite useful block. I believe it’s simple but powerful and I have the high-level concept together. It’s for the Education category but easily can be used in professional and everyday life. I would need a developer to create a prototype with me. I would take care of UX and UI plus tables logics. Skills I’d need: react, js, cloud services, a bit of frontend. If you feel like you can participate in a sprint with me, do let me know. Stephan

I’m trying to sort my records alphabetically and it logs perfectly with output.table() as you see below (first screenshot). But when I close the Scripting block it’s not reflected in Grid view (2nd screenshot). What additional step am I missing? Sorted correctly Not sorted

I am using Airtable as a data source for an app on AppSheet. Everything seems to work well except for values from linked tables. As shown in the image below, when a value is coming from a linked table, it is showing the record ID instead of the actual value. How can I fix this?

I noticed the date value provided is structured as M/D/YYYY. Is this consistent across all users? Or does this change depending on regions? ie. D/M/YYYY for EMEA Airtable users, M/D/YYYY for US Airtable users, etc. This might be a new Feature Request, but it would be awesome if CellRenderer can provide an easy Field type toggle to generate more consistent “universal” dates. I would love to see something like YYYY-MM-DD being available.

Hello everyone, I am trying to add the uploaded files to my base into a Zapier email. Not sure why its not working on this specific base. I have it working on another base of mine. Here are my links: [https://airtable.com/shr4OWctZTkg3CfVd](http://Airtable Base with Attachments)

We are trying to create a custom block. We follow all the instructions in the video, but we find that our folder is completely empty. How can we solve it? Thanks in advance.

Use Case: You have a table of stylists, therapists, technicians, etc. (“agents”) who perform any number of services, and customers are supposed to schedule an appointment with an agent to perform a service but only when that agent is available. While you think the No-Conflict Asset Reservations script is great, it doesn’t take into account your need to schedule an agent for more than one appointment per day. Solution: No-Conflict Appointment script by Kamille. An improvement upon my previous script, you can now schedule same-day appointments assuming those appointments don’t overlap. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing

I’ve been using the expandRecord() function call to provide a quick way to update content in my Block interface, but I would LOVE to use that flow for new data entry as well. Is that possible? I’ve read through the documentation and example projects and I didn’t see this noted. And expandRecord() does currently require a record to be passed to it.

Is this on the radar? Using "!=blank()" is not returning the correct result Formulas :angry: Just got bitten by this one again. Is this on

So this is probably a dumb question, but I have hit a wall! How do you write into a Date/Time field with the current date in the locale timezone? I have tried the .toLocaleString() method and the console will output everything perfectly, but nothing shows up in the field. This is what I have. var rightNow = new Date(); var res = rightNow.toLocaleString(); table.updateRecordAsync(record,{ "Date/Time Submitted To Shipping": res }) Any help would be greatly appreciated! Update: I can get the Date/Time in a Date/Time field by using the .toISOString() method, but the time is 5 hours off.

i have button to add record. before release , in development ,was able to add record from custom block succesfully with `table.createRecordAsync’ . when block is released does not add new record. block is started on terminal

Hi team, I’m working on an exciting block for the Devpost but that requires a user to prefill a few things (AWS key/access) and I see that in the Google Translate block, there is a nice Wizard set up page: Is there some sample code somewhere where we can see how the wizard works? It’s not listed as a component on Airtable Blocks SDK but the Design guide does seem to reference it Quip TIA!

I’m working on getting my dev environment ready to start working on a custom block. However, I’m running into an error. After running block run in Terminal and allowing my browser to load https://localhost:9000, opening the block in Airtable yields: /usr/local/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/node_modules/yaml/index.d.ts: Namespace not marked type-only declare. Non-declarative namespaces are only supported experimentally in Babel. To enable and review caveats see: https://babeljs.io/docs/en/babel-plugin-transform-typescript 107 | str: scalarOptions.Str 108 | } > 109 | export namespace scalarOptions { | ^^^^^^^^^^^^^ 110 | interface Binary { 111 | /** 112 | * The type of string literal used to stringify `!!binary` values. Any ideas as to how to start troubleshooting this? Admittedly, I work more w

Hey all, I think this is a bug, or maybe my React knowledge isn’t up to snuff. Looking at this Tooltip Example here: Airtable

Hi there, is there any way to trigger the “Send Record” functionality from a Block? I see there’s a POST to https://airtable.com/v0.3/view/VIEW_ID/emailRows with a stringifiedObjectParams that I could derive within my Block. Is there a friendly function to call from the UI to make this, say, on the view object? Anything to note here about calling these types of functions from blocks in general?

Hi everyone! I have a table, a collection of URLs to different articles and videos. I wanted to have the text parsed from these URLs (the content of the article, description of a youtube video). I made it with python (beautifulsoup4) and made a serverless function for this. When I’m running it in scripting block, it gives an error message (‘TypeError: Failed to fetch at Failed to fetch’). It appears sometimes after passing perfectly 10 URLs and sometimes after 38, or after 3. So it looks completely random. When it runs to an error, I test it with the serverless function outside of Airtable’s scripting block, and it works fine there. Do you know anything, what could cause the error in random lines? Thank you in advance for the help!

Hi, I have a Table that I use for inventory/stock management. I was wondering is there a way that once a certain stock’s quantity reaches a limit (i.e. about to run out), can an email be sent out directly to use (as a reminder) or directly to our supplier to order in more stock? If this can be done internally with Airtable, that would be great. Alternatively, if not, would it be possible to use Zapier to connect our Airtable and create a zap/trigger so that once the stock quantity reaches a certain amount, an email can be sent? I was also wondering if there was a way to connect details from standardized emails we receive and organize to have the information automated so that it is entered into my one of my tables. Again, would this be possible by connecting Airtable with our gmail using Zapier to collect the information from the email and plug in the data in certain blocks within the table?

Hey there, it’s short notice but I would like to participate in the current Airtable block challenge. I have an idea for a quite useful block, the concept and could take over design and table logic. I need a developer, that can realize that. Depending on team size any prize money is split per head count. Looking forward to connect. Stephan

I have integrated the Airtable API in my Wix site which was working fine with other filters but when I implemented date range filter with those filters then it’s showing empty items in response and here is the URL of my request https://api.airtable.com/v0/appGS7oZJd8MLqWKc/Candidates?filterByFormula=AND(({City}=‘Benton’),AND(IS_AFTER({Date_of_Submission},2020-06-03),%20IS_BEFORE({Date_of_Submission},2020-06-29)))&api_key=“key_provided_by_airtable”. I checked that on Airtable data UI by applying the same filter and it’s working fine over Airtable UI but not working in API calling when I applying the same filter via API.

We’re working on submitting a Team Voting block with a twist. And we noticed that there isn’t any visual controller for editing the fonts within the block (eg. editing the question, and the answers styles). Is this intentional? Is there a specific style our fonts should adhere to? If so, I’d love to know where we can get this info from, as to submit it pre-configured for this specific font style. Otherwise, end-users won’t be able to change the font. :roll_eyes: