Development & APIs

Hello. Am developing an app using Flutter. Would like to find if I can use Airtable as my database. Is there an API that I can use to integrate Airtable with Flutter? Will need to be able to do all CRUD operations. If so, is there any documentation that I can refer to? Thank you!

Hi everyone,I’m developing an app using Softr as a front end and Airtable as the data source. The app serves as both a client portal and an internal operations tool, with 3 user groups: clients, employees, and managers.Here are the key details:At peak traffic, I expect around 100 concurrent users interacting with the app (creating, updating, and reading records from Airtable).Given Airtable’s 5 requests per second limitation, I’m concerned about potential performance bottlenecks or errors.I don’t mind if there’s some delay when loading pages; my main concern is ensuring the app functions properly during high traffic.Questions:Will the app handle this level of concurrency without running into errors, considering Airtable’s request limits?Has anyone built something similar and can share their experience?I’d greatly appreciate your comments and insights!Thank you!

When editing a custom Airtable Extension, the process is to select edit on the block, grab the URL/port from AT,  run the block locally with block --run, and select "Start Editing Extension." However, the Chrome setting (flag) that used to allow developers to host the app code locally and run it in AT has been removed. (The flag was #allow-insecure-localhost.) This leaves us unable to edit the extension. Any suggestions for how to get development working again for extensions/blocks? 

I have a table of projects that all have an Estimated Cost field.  At the bottom of the table it is summing every field, including Estimated Cost.Is there a way to access that data from the API?

Hi All,I'm using Voiceflow, when i try to create a new table in an existing base using the API i get the following error:{ "error": { "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct." }, "VF_STATUS_CODE": 403 This is the url endpoint i'm using:https://api.airtable.com/v0/{baseID}/{table_name}I have a valid base id and i'm populating the {table_name} variable with the users 'user id' such as 'TYSCH'.I have all my scopes selected in my access token.Voiceflow API Settings: My JSON body:{ "table_name": "{table_name}", "fields": [ { "type": "singleLineText", "name": "UserId" }, { "type": "singleLineText", "name": "TokenUsage" }, { "type": "createdTime", "name": "Session Date & Time" } ], "views": [ { "name":

I am trying to sync AirTable data to HubSpot. However, I do not understand the "Last Modified Time" field requirement by HubSpot. I created a Last modified time field in my AirTable base, but it still isn't working. Have anyone experienced these issues? 

Hello and thank you for everyone I have api documentation from a Delivery Company and I would like to get shipping quote to our airtableThat’s what I got from themhttps://api.aitworldwide.comif anyone have idea I would love to know thank you 🙏

The Customer Rewards Extension Management codeunit encapsulates most of the logic and functionality that is required for the Customer Rewards extension. This codeunit contains examples of how you can use events to react to specific actions or behavior that occurs within your extension.This extension includes a requirement to make a call to an external service or API to validate activation codes that are entered by the user. Typically, you would complete this verification by defining procedures that take in the activation code and then make calls to the API. Instead of using that approach, you can use events in AL.To create a new codeunit in your project, create a new file with the name CustomerRewardsExtMgt.Codeunit.al.Next, add the following code to the codeunit:al-languageCopy codeunit 50101 "Customer Rewards Ext. Mgt" { EventSubscriberInstance = StaticAutomatic; // Determines if the extension is activated procedure IsCustomerRewardsActivated(): Boolean; v

Hey!I am trying to update a record based on the user's id, currently, I have this code but for some reason it errors saying: TypeError: Invalid arguments passed to table.updateRecordAsync(recordOrRecordId, fields): • recordOrRecordId → recordOrRecordId should be a Record, not a number (5) or recordOrRecordId should be a string, not a number (5)Basically I am trying to update the field URL for the user based off their user id, the text I want in the field URL is from the "strHash" stringlet table = base.getTable("Participant"); let record_id = inputConfig.record_id; await table.updateRecordAsync(record_id, { "URL": strHash })   

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?Thank you.

Hi there Airtablers, I’m using Airtable + MiniExtensions to do a little CSV uploading and processing, and I need to add client approval functionality. This would be via a PDF emailed back to them once a list is ‘approved’ via a limited write-access version of my base via MiniExtensions. Could someone please help me with some code in a code block, along the lines of… if CHECKBOX is ticked --> create PDF in PAGE DESIGNER, then save PDF somewhere useful afterwards. Any help very much appreciated, Airtable wizards! Thanks so much in advance.

In my automation script I am running a fetch request. In some cases the fetch requests takes longer than 30 seconds which results in an error. I don't really care about the fetch request result because it is a post request that is doing all it needs to however the error each time it runs is annoying.Does anyone have any suggestions on how I can run the fetch request without waiting for a response? Or perhaps there is a way to handle the error gracefully?

Hey folks,We are implementing Airtable OAuth integration, and we are getting the following error: You have reached the maximum access authorizations for this integration. You cannot authorize this integration again until you revoke at least one of the authorizations Is there public documentation and explanation of this error? --Artur

Hi, Does anyone have a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depending on eg ISIN, etc. I just found quite old posts and only one newer video (How to Track Stocks in Airtable - YouTube), but the script link in the video is outdated… So any help with providing a script, etc. would be highly appreciated. thanks a lot, Chris

It is impossible to communicate with the support team because requests can not be sent. Even though your API does not work, and I do not have any channel to communicate with   

I’m using your API to upload attachments.While simple requests work fine, when I try to send real files, the API responds with a 404 error. This makes it difficult to debug the issue.

Hello I’ve not been able to find documentation on whether it is possible to obtain the schema of an existing base, other than the one that is autogenerated in the form of online documentation. I intend to use this Schema to auto generate language bindings for specific bases; while code changes may still be required in the case of statically type languages one has to deal with updating the data structs that allow use to enforce type-safety and the specific code that use the endpoints. It’d be ideal if the API for each base conformed to something like Swagger 2.0 Best, Tristian

Use Case: You have a table of assets (library books, conference rooms, etc.) that you want people to reserve, but don’t want people to be able to reserve an individual asset at the same time it has already been reserved. Solution: No-Conflict Asset Reservations script by Kamille. This script allows you to schedule a new asset reservation in a form-like interface by setting a date range, then selecting from a list of assets which are un-reserved for that time period. Potential Users: Event Planners, Inventory Managers, Librarians, etc. Demo: drive.google.com No-Conflict Asset Reservations - Demo Video.mov (video) Google Drive file. Special shoutout to @Jeremy_Oglesby for his wonderful Detect Scheduling Conflicts script, which inspired me to make my own script. Using both scripts together, I think Airtable users will never have to worry about double-booking an asset again! Instructions: This script includes a “variables” section to

Hi allI've been working on SAP Integration Suite for connecting to airtable and perform CRUD operations. I've created a integration flow for PATCH request in my suite and wanted to test it through POSTMAN by hitting the endpoint of PATCH iflow. The issue here is that even though i'm sending my json payload in the format of airtable PATCH request postman is throwing 500 error.My table in airtableNote that EmpID is also Single Line Text hereBelow are my configurations of the integration flow i've created to perform a PATCH operation through POSTMAN.Json payload i'm sending through postman to suite{            "id": "rec6jjMo9lBFpfI62",            "fields": {                "Location": "India",                "EmpID": "4",                "Name": "Tester",                "D

With a correct budgeting process, companies can benefit from forecasting and use financial insights to compare actuals against allocated budget. You can use the Budgeting module in Finance for basic budgeting, budget planning, and budget control.After a budget is established and approved in Finance, you can convert the budget plan to a budget register entry. Budget register entries provide tools for maintaining the budget and for keeping amounts traceable through budget codes.Budget register entries let you revise original budgets, perform transfers, and carry forward budget amounts from the previous year. Based on the established budget, a company can enable budget control. The level of control depends on the organizational culture and the organization's level of maturity.Finance includes a budget control framework that lets the company's management select either hard control (which prevents postings that would go over the budget) or soft control (where users are warned that they will

By asking questions and gathering customer requirements, you can plan a chart of accounts that fits the customer's needs. In many cases, the customer chooses to bring in their existing chart of accounts from the legacy system into Dynamics 365 Finance. If this is the case, you need the source data that you create by extracting data or by exporting from the legacy system in a format, such as CSV or Microsoft Excel.Then, after you cleanse and restructure the chart of accounts according to what the customer wants, you can use the Data management workspace to import the data to Finance.For more information, see Migrate data and go live with finance and operations apps.The following questions are typical examples of what you can ask when interviewing personnel in your customer's finance department:What degree of specification is needed?How should the chart of accounts be structured?Have external accountants offered suggestions about the structure of the chart of accounts? Doe

Hey, I’m a newbie with JavaScript so this might be obvious … I need a delay(ms) method to slow down the script after 5 API calls (limit 5/min.). Problem is all the JavaScript help on the intertube points to the setTimeout() method of the Window object. But it appears that Window is not instantiated inside the Airtable code block, therefore, no setTimeout() method. What’s a good workaround for this? What might I be missing - other methods? Thanks David

Hi all,I'm using:Airtable as the main databaseFillout connected to Airtable to get responses from users (about 250 fields)Softr as front-end to get list of filtered records, get record detail, and buttons to open Fillout form or start an automation (basically change the status field to be used as trigger to n8n)n8n for automating the data processing (mostly to generate PDF using PDFMonkey, I received data from Airtable in the trigger and just change the status field at the end)My understanding (that was also confirmed by the support chatbot) is that:getting a list of records in Softr = 1 API call (I have only 8 records)getting a record detail in Softr = 1 API callone response in Fillout = 1 API call (maybe 2 or 3 as there is a lot of fields)automation trigger = 1 API callchange the status from automation = 1 API call (changing just one field)etc.If I test the solution - open list of records in Softr, get record detail, open Fillout, fill one response, start automation in n8n and finish

Hello everybody,I am experiencing issues running an automation script. Basically, I have created an automation that sends information to a webhook link. My issue arises during the step where the information is sent to the webhook link—I am encountering challenges here. I created one variable, which I then implemented in the code using the configuration provided by Airtable, but it does not work as expected.What happens is that if I run the same script without the variable, it works, eventhood i use thes same script for the variables (see attached photo). To sum up: it’s the same script in both scenarios. When the variable is present in the left column, the script does not work. However, when the variable is not present, the script functions correctly.