Development & APIs

I have this table set up where I have a running balance of what being added and taken from a cash register. I am running this script for it: // change these names to pick a view:let table = base.getTable('TIN');let view = table.getView('ALL');let result = await view.selectRecordsAsync({fields: ['Gross Added or Subtracted']});let runningTotal = 0;for (let record of result.records) {// change the field names here to adapt this script to your baserunningTotal += record.getCellValue('Gross Added or Subtracted');await table.updateRecordAsync(record, {'Running Balance': runningTotal,});} BUT, when someone counts the actual amount in the register, I want the running balance field to become equal to the actual count. How to I do this? 

I am trying to achieve the following:A "Points" table that stores usernames and points associated with themA "Leaderboard" table that aggregates all points for the users, i.e. sums up the points for each userI set up the Leaderboard table first where I defined a "Username" field as the primary key and a "Total" field as a number field. Worked fine.Now I wanted to setup the Points table so a Username field points back to the primary key "Username" of the Leaderboard table, like this: { "name": "Points", "description": "Points table to track points per user", "fields": [ { "name": "Id", "type": "singleLineText" }, { "name": "Username", "type": "multipleRecordLinks", "options": { "linkedTableId": "tbl..." } }, { "name": "Points", "type": "number", "options": { "precision": 0 }

Hello, i'm calling an API but i'm getting different results if i'm using Android or iOShere is my call:https://api.airtable.com/v0/appOwBv51ih******/teamtim****/?filterByFormula=FIND("Maurizio Polverini",{Nome})=1&sort%5B0%5D%5Bfield%5D=ID&sort%5B0%5D%5Bdirection%5D=ascAndroid response (it works well as everything is sorted "asc" by the column "ID") - as you can see everything is well sorted starting from fields{ "ID":36:--------------------------------------{"records":[{"id":"recHkGRBjaYe3ohuO","createdTime":"2024-11-09T08:19:32.000Z","fields":{"Nome":"Maurizio Polverini","Created":"2024-11-09","Device":"Android","Entrata":"9:19","Uscita":"9:20","GPS":"Estensione GPS non attiva","Ore Lavorate":0.016666666666666666,"Mese Nome":"novembre","Anno":"2024","ID":36,"Giorni":"09","GPS Uscita":"Funzione GPS non disponibile per l'utente"}},{"id":"reczyPzSXGnyMGXey","createdTime":"2024-11-09T08:20:46.000Z","fields":{"Nome":"Maurizio Polverini","Created":"2024-11-09","Device":"Android","E

Hello Airtable Community,I'm currently working on creating a custom extension in Airtable, but I've encountered some challenges and would appreciate any guidance. I have followed the prerequisites and setup steps, including installing Node.js, setting up a project directory, and running the commands “block init” and “block run.” However, I'm facing issues when trying to connect the extension to Airtable for a live preview.Here are some details:Project Directory: I've set up a new directory and used “block init” with my Airtable base and block IDs.Development Server: After running “block run,” I see the localhost URL, but Airtable seems unable to connect to it.Environment: I'm using a Mac with all required dependencies installed, including the latest version of Node.js and the Airtable Blocks CLI.If anyone has experience with troubleshooting these types of connection issues or can suggest further steps, your help would be greatly appreciated. Additionally, if there are any common config

Hi, following these instructions Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support I was able to link a single Airtable table to PowerBI and this works very well. However, I would like to link multiple tables from the same Base to PowerBI. Does anyone know how to solve this? Cheers!

Hello,I am coding a specific HTML form with google script and airtable. I am using the webhook automation with my HTML form (using action=" URL of my airtable webhook ").  <form class="form_style" id="subscription_form" action="https://hooks.airtable.com/workflows/v1/genericWebhook/app5FlLF4JRKgnLGQ/wfle1FROme98xqd3d/wtr9QlkcULz" method="POST">  All work fine but I am always redirected to the airtable success message. I tried to use AJAX with google script and Airtable but had no success (I saw that CORS is a problem with webhook automation). I want to stay on the page and display a success message (form submitted on the same page). Could it be possible and could you help me, please? Best regards

Hi,I am sure you will all tell me to simply build my web form in Airtable and connect it to my website. ( I dont know how to do this). I have a web form with fields in it on the web site ( fluent forms on WP) . I have got a token and connected to Airtable but i do not know how i can use the fields in the web form to create the fields in the Airtable base?any help will be gratefully received. ash 

I am using API calls to read information in a Airtable Base and bring in values into Excel.I only have one person as a Collaborator in airtable but multiple people have a copy of the Excel sheet in my team that use the sheet and its associated calls but they are not registered with Airtable.I am on a free plan but I see that my Monthly API calls are over the 1000 person limit. I plan to upgrade to the Teams plan with will give me 100,000 calls but my question was if I do so do I need everyone who uses my Excel sheet added as a collaborator just because the sheet they have has the API calls?

Hi AllI am trying to connect to airtables through power bi and have the API setup with the key, base id and table id. however when i enter the details into Power Bi i get an "We couldn't authenticate with the credentials provided. Please try again." error. now sure why as i do have access to the airtable with the same power bi credentials.Thanks 

To create a base through API you  need to provide a workspace_id -> https://airtable.com/developers/web/api/create-baseBut I can't find a way to list the workspaces a token/user has access to. How do I get the different workspaces for a token (in non-enterprise accounts) ?

Greetings devs! First post here after doing a bit of googling to no avail… I’m looking for an example of how to upload a zip archive to an attachment field. In the documentation there is mention of attachment objects but no mention of how to create one pro-grammatically. Any sample code or general guidance would be helpful regardless of language although Python would be greatly appreciated! Cheers, Jean

Hello, we have had 422 errors in our integrations suddenly, when trying in post man everything works correctly but from the VB.NET application the same record gives error 422, this is happening in several integrations from different databasesEdit: for now all api integrations are working fine, check yours

Goal: importing JSON from an open API into my airtable base.How: Using a script extension in the base (at the bottom of this message), with proper error logging.Result: No return after “let response;” The script just seems to stop without any error triggering. The last log is “console.log("⏳ Start fetching domeinen data...")”Test that does work: A curl request to the API does yield the complete JSON, just as a request through postman. So the API is reachable.The code to request and import the data:  // API credentials let apiKey = "(API key censored, but it's working)"; let apiUrl = "https://opendata.slo.nl/curriculum/api/v1/domein/"; // Function to fetch the domeinen data async function fetchDomeinen() { console.log("⏳ Start fetching domeinen data..."); let response; try { response = await fetch(apiUrl, { method: "GET", headers: { "Accept": "application/json", "Authorization": "Basic "

I have implemented OAuth integration with Airtable.However, if the users want to switch another account, they cannot do that because browser stored last login session. Are there any way to get rid of it ?

I am looking to Run a script in an Action. basically whenever the Category “Done” or “Postpone” is set to the record by single select field. I like to run a script that deletes those records. The trigger is pretty much easy to do by the automation configuration. The script is the one I didn’t figure out how to do.

If anyone is interested, I wrote some code to sync over new Shopify orders to Airtable using the Shopify Order Created webhook and the APIs of both platforms. The code can be found in this Github repo:https://github.com/codeupify/functions/blob/main/shopify/airtable-order-integration/README.mdThe code is in Python and using Flask as a webserver that you can host somewhere. There is also a serverless solution available here if you don’t want to spin up your own server:https://codeupify.com/f/yMYerkEaOB

Hi there, I have the automation example in Airtable that sends a digest email of certain records for yesterday (in our case, overrun on tasks). On days when there was no overrun, the email would still send but would be blank, which is not appreciated by management. I found this script in the forums here that helps prevent the email going out BUT it means I get an error alert & email instead, and it makes me go and check the automation is still working: // A script to stop the automation running when no records are found. // This prevents blank emails being sent. // See: https://share.support.airtable.com/2NuwnyDD?method=GET let numRecordsFound = input.config().numRecordsFound; if (numRecordsFound < 1) { throw Error("No records were found. Aborting so no blank emails are sent.") } Is it possible to stop or exit the automation silently, without throwing an error? Many thanks in advance, Chris

I am trying to use the API request to retrieve comments from a record using the following URL: v0/{baseId}/{tableIdOrName}/{recordId}/comments. However, I encounter a '[404] NOT_FOUND' error. I am using an OAuth connection in Make, which works when I use any other request, such as a simple 'Get a record': v0/{baseId}/{tableIdOrName}/{recordId}.

Looking for an API that can be. used for integration purpose to fetch all the data related t the subscripted plans 

Suddenly my api calls have stopped working and getting error code 422 INVALID REQUEST.  Didnt change anything its the same requests that have worked for months and now nothing works

I using airtable's api by connecting it to front end in flutter and a javascript backend using vercel function,these functions are working in dev environment but not in productionfunction call in front end in flutterFuture<void> createRecord(String firstName, String lastName, String address, String phoneNumber, String password, String personalMobileNumber, String salary, String role) async {final String url = 'crmvercelfun.vercel.app/api/addemployee';// Prepare the data to be sentfinal response = await http.post(Uri.parse(url),headers: {'Content-Type': 'application/json',},body: jsonEncode({ "fields":{"First Name": firstName,"Last Name": lastName,"Address": address,"Phone Number": phoneNumber,"Password": password,"Personal Mobile Number": personalMobileNumber,"Salary": salary,"Role": role,}}),);print(jsonEncode({"First Name": firstName,"Last Name": lastName,"Address": address,"Phone Number": phoneNumber,"Password": password,"Personal Mobile Number": personalMobileNumber,"Salary":

Hey All,This forum has been of great use to me over the years, and wasn't able to find evidence of this solution in existing posts, so figured I would share!When designing a multi-button script in the Scripting extension, I found myself wanting to make buttons with labels of different character length of equal size.Turns out Braille Pattern Blank (U+2800) is a good enough solution.  // Create the initial buttons let action = await input.buttonsAsync('', [{label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀New Business in Existing Storefront⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'New Business in Existing Storefront', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀Business Relocated⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'Business Relocated', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀Business Expanded To Additional Storefront⠀⠀⠀⠀⠀⠀', value: 'Business Expanded To Additional Storefront', variant: 'primary'}]); You'll note that I added both value and label parameters to each button, so as to not have to include the spacers in

Has anyone figured out how to move an AirTable table onto an SQL database. I use Air-table for everything, but I’m starting to run into issues with the 100 record limit that Airtable imposes. Unfortuntely, it is a proprietary plugin making the API requests and it generates an error when the user retrieves over 100 records at a time (leaving many records blank). Does anyone have codebase or ideas on how to ‘sync’ Airtable records into an SQL database, which can then be queried by a web app that displays dynamic content. I don’t want to move away from Airtable as a CMS because its so easy for other project collaborators to use for data entry.

Hi, I would like to import a CVS file into my base and write an automation to adapt the file to my base on airtable. For example: the title of the colums are different on each, some info need to be extracted but others not. Does someone have a script for that ?  Thank you so much !

Hi, I am trying to use REST API to retrieve data from a base that includes both the records from a primary table and the linked records from a related table in a single request.  Is there a way to obtain this data in just one API call? Know that in SQL, a single query can fetch data from multiple tables in one request, but Airtable has me stumped. Any guidance is much appreciated. Thanks in advance.