Development & APIs

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:94903) at invoke (bundle.js:formatted:94997) at bundle.js:fo

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 in correctly formatted date/time strings. Since there isn’t a datetime picker input type, I basically hacked my own using two conditional button inpu

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 the list guys? Using the API in my case: [myDate != ‘’] works fine, [myDate != Blank()] does not and in my case returned a truckload of records that didn’t need updating. I’ve posted other examples before, but blank() still is dangerous…

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 with Python and this is my first dive into Node development.

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 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. import { Tooltip, Button } from "@airtable/blocks/ui"; const tooltipExample = ( <Tooltip content="Notifications" placementX={Tooltip.placements.CENTER} placementY={Tooltip.placements.BOTTOM} shouldHideTooltipOnClick={true} > <Button icon="bell" aria-label="Notifications" /> </Tooltip> ); When I add a “disabled={true}” property to the button in the above example, the tooltip no longer renders. This is unfortunate because my main use-case for a tooltip was to indicate why a button was disabled. Am I missing something? If it is a bug, do you think it can be fixed before ne

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:

Hi Airtable! I am in the process of backing up Airtable Records and I don’t want to lose my data when I restore them, so I have 2 questions. My understanding is that the API only allows 100 records. Do I need to change anything in the URL for Retrieving Records? Apparently, the default number is 3 or do I change it to 100 in the URL, before I run the scenario? https://api.airtable.com/v0/appTcwWOhdqs5mJXj/Imported%20table?maxRecords=3 I will be using Integromat to do this, Webhook=>HTTP=>JSON=>Airtable (using Airtable API) Does using Airtable API keep the data in these field types, when restoring records back into a base with the same field names and types: Attachment (one image per record) Date Field Date Field (formula) Currency Currency (formula) Multi select Single select Linked field (base has two tables) URL (websites-one URL per record) Any help would be appreciated. Thank you, Mary Kay

For the voting block we’re building, the end-users submit data we need to save. Because the Base creator can share the Base with read-only permissions, it means we won’t always be able to write data back to the Results table. Is this alternative approach to get the total votes using a Download CSV button reasonable, or we could somehow save back data in a read-only Results table / another base that’s not shared?

Hi All - I’m a React newbie. My block code is getting unwieldy and I would like to split it into a few different files, starting with the settings ui. I am unsure how to do this. In the settings.js file how does it look? Do I have a single function that returns a div with all the other stuff in it? Then how does the export line of the file look? Then, in the index.js file, how does the import line look and how do I call this function that has my settings ui in it?