Development & APIs

Hi, I am getting an error when using POST via Postman. I am copying the example exactly from the API documentation and changing the authorization key. I have tried changing the content type, modifying the fields, but nothing worked. GET method is working. Why is this?

Hi AllI am having issues with linking information between tables.I have the below linked:1) Master Order Table 2) Order Line ItemsI wanted to create a new table called Purchase Orders (POs) which is just relevant purchase order information (excluding any sell price etc from the master order) so i can send the PO to my suppliers.The issue i am having is that the information on the POs table is not linking with the Master Order or the Order Line Items tables as per attachments. Please help me with solving this.Thank you!

When mapping a WordPress CF7 with airtable, Airtable allows Contact Form 7 to write into the field Email if it's an "Email" field-type, but not if i convert it to a linked table.I would like that the field "Email" inside of the table Messages links to a table named Email, where Email is the PK. Like this we'll be able to see all related messages.Unfortunately CF7 outputs an error with this setup. Is it there a workaround? Or should be build an airtable automation that reads the contact form user input that goes into the (unlinked) Email field and updates another field named LinkedEmail?So, either CF7 links messages to the Emails table, or we will have to auto-link using an automation.What's your opinion on that?

Thanks in advance for the help! I want to find a way to use an automation to clear out a pre-filled field when a record matches conditions. For example: We have a check column to see if a task has been completed. We also have a collaborator column to see whom the task is assigned to. I want to create an automation to just clear the collaborator column when the task was completed without deleting the entire record (for archiving purposes). Any way to do this? Thank you!

I'm trying to use the options from a single select field as an 'input' selection in my script. I'm not sure if Airtable allows this. So far I have: let selectTable = base.getTable("Courses"); let selectField = selectTable.getField('School Year'); let schoolYears = selectField.options.choices; console.log(schoolYears) Which provides Then I make an array from just the names: let yearNames = schoolYears.map(record => ({name: record.name})) console.log(yearNames) Which gives:I'd like to then use those choices as an input: let selectYear = await input.buttonsAsync('Pick a year', [yearNames]); But this gives an error that you

I can call my endpoint (with hardcode variable) it's successful in requesting ( got a response ), but when I try to use a variable, params from the record. It's stuck on the CORS problem, but I am not sure why,(both variables are the same, the difference is the one from the variable does not worked,and one from hardcode is worked)//if I used hardcode in data, it work fine.const requestApi = async (params) => { const myHeaders = new Headers(); myHeaders.append("api-key", "xxxxxxxxx"); myHeaders.append("Content-Type", "application/json"); try { const requestOptions = { method: "POST", headers: myHeaders, body: params, // JSON.stringify({ // "pid": "xxxxxx", // "firstName": "xxxxxx", // "lastName": "xxxxxxx", // "birthDay": "xxxxxx", // "laser": "xxxxxx" // }), }; const response = await remoteFetchAsync("https://xxxxxxxx", requestOptions); const result = await response.text(); console.log("Record updated successf

Hi,I am trying to run the following script based on my screenshots and I am getting an error “Your script exceeded the 512MB memory limit.”.What am I doing wrong and how can I fix this? Thanks! 

Dead link! 

I have a base that has a number of junction tables. For example a product links to a product assembly item that links to a product assembly with multible product assembly items which links to an estimate.Its very cumbersom to have to go through each of these tables and use the forms to add data to each indivdual table. I wanted to create a single form that lets a  user select products and then creates all the related junction tables.I was wondering if anyone had any work arounds for being able to add data to multible tables from a form.  Right now forms do not allow for record creation or buttons with scripts, making it hard to create a new junction table entry that relates to the record being created.The only work around I can see is to create a seperate dummy " input table" that has a number of records related to each ipnut action I would like. Instead of creating a record users would just be editing the record through an interface. There would then

Here's a weird one. So I had am automation set up using the airtable "Slack: Send a message" action and it always worked great. I add the slack workspace account, authorize, then it shows a chanel list of all chans, I pick my chan in the workspace. Good. We created a completely new slack workspace since our product got split to another business and now I need to make this message get sent to the NEW Slack workspace. Simple. Go into the automation, remove the old Slack workspace integration, add the new one with the NEW slack URL and new user/pass, and then... wait... It is showing the OLD slack channel list from the old workspace. The channels are totally different so I must have made a mistake. I remove the "Slack: Send a message" action completely, then to Account -> Integrations section to remove the integration from my entire airtable profile. I notice that this integration DOES show the name of the NEW company, which isn't looking promising (since that mea

Hi! very new to using Airtable. I am trying to find out if it’s possible to use Airtable to populate users profiles for a small 30 members community. I am trying to display name, title, image, etc.. or would I be better using something I am more familiar with like Supabase. any thoughts or advice would be appreciated. Steve 

If you’re using a rollup field to summarize linked records with ARRAYJOIN(), the array’s order is determined by the order of the linked records. I created this script to automatically sort linked records in a cell. My use-case is to summarize interactions with companies. I sort by descending order to show the latest summary on top. Enjoy! // Set a trigger: when a record is updated -> watch the linked records field // Set an action: run a script // You should set the record ID of the triggering record as an input variable // Grab the triggering record's ID let inputConfig = input.config(); let recordID = inputConfig.recordID; let table = base.getTable("tableName"); // Load table let queryResult = await table.selectRecordsAsync(); // Get all records in the table let record = queryResult.getRecord(`${inputConfig.recordID}`) // Find the one with the ID from the input // Get the linked records array let linkedRecordsArray = re

I'm creating a script between 2 tables: 'Engagements' and 'People'.Engagements is a list of event attendancePeople is a master list of peopleI have a script that, using the attendance sign up info (name, email), tries to find a matching person from the master list. (This step is part of a loop to go through each Engagement record.) let peopleTable = base.getTable('People'); // find a matching Person record let personQuery = await peopleTable.selectRecordsAsync({ fields: ['Person IDENTIFIER'] }); let foundNames = personQuery.records.filter((record) => { let name = record.getCellValue('Person IDENTIFIER'); return name == engagement.getCellValue('Person IDENTIFIER'); }); This works fine. Now I need to link all the 'foundNames' to that 'engagement' record.  The linked field is called 'Person' in 'Engagements' table: let numPeople = foundNames.length; if (n

Hi Folks,I have come up with a workaround for not being able to filter on query within scripting automations. Since you can query on a view but views can't be adjusted via the API either we use a view that has a checkbox and then check the box through update records and uncheck when done.  This is useful when you have a list of records from a linked field more than a dyanamic filter.  It is also still best to filter the records that are returned to ensure they do meet your criteria but greatly reduces the number of records returned.  First we use this async function to make the object for updates:   ​async function setAutomationFlags(table, recordIds, flagValue) { const automationFlags = recordIds.map(recordId => ({ id: recordId.id, fields: { "Automations": flagValue } })); await updateRecordsInChunks(table, automationFlags); }

I'd like to build a field that returns the days until due if >0, or "Assign Due Date" if Nan, or "Passed Due" if <0.I am struggling to combine the IF statement with the following formula:DATETIME_DIFF({Deadline},TODAY(),'days')Any tips on how to accomplish this? 

I'm developing a Block Extension. When I type block release I get"Error: Your Airtable API key is invalid. Please use block set-api-key to update it. Code: airtableApiWithInvalidApiKey"Since api keys are deprecated (I have deleted my key and can't create a new one) I have created a personal access token. But I can't get it to work with block release; running block set-api-key <my-personal-access-token> returns"Error: Invalid Airtable API key specified. Make sure you copied it correctly from airtable.com/account. Code: airtableApiKeyMalformed"How do I use my PAT with Blocks?  

I am trying to updated a linked record via Siri Shortcuts. I keep on getting error “value is not an array of record ids” The update is done vie Get content of URL. Request Boyd JSON. I figured out the id of the record that I am trying to link to. I tried setting the fields text to the record ID but I still get an error.

I saw what looks like support for type script in airtables online IDE but I couldn't find any documentation on it. I'd like to get rid of some of these type errors that are populating my code.  

Is there a way to get the list-of-values that are available for a single- or multi-select column?

When I change a status in my record I want to check my data entry. If this check fail I want to stamp a warning in a popup message or similar because I want that the user knows this. Somebody can help me? It was more simple in vb but I didnt find nothing about. Thanks

There's an Airtable that's been shared with my account (A) from account (B). I have a personal access token from account A.- The Airtable's restricted to account A's domain- The Airtable is password protectedIs it possible to use the API to fetch the records of the Airtable?I've tried this approach:const Airtable = require("airtable");const PERSONAL_ACCESS_TOKEN = "...";const baseId = "...";const tableName = "...";const base = new Airtable({ apiKey: PERSONAL_ACCESS_TOKEN }).

Hello, I was wondering how I update my fetch code in observable to use the personal access tokens? Here is the notebook: https://observablehq.com/@datagrazing/fermentation-jar and the code in question: Airtable = (await import("https://cdn.skypack.dev/airtable@0.11.1?min")).defaultfull_data = { data = { const base = new Airtable({ apiKey: API_KEY }).base(BASE); const records = await base("ratios").select({ view: "Grid view" }).all(); return records.map((d) => d.fields); }

Hello I am developing a browser extension. It does Airtable OAuth and then lets the user fetch tables and quickly add records directly from the browser.Yesterday it all worked well for me and today the Airtable API does not send the appropriate CORS headers."Access to fetch at 'https://airtable.com/oauth2/v1/token' from origin 'chrome-extension://bnpbihfpfplcakeplbgbmopmppdkgcdn' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled."It is indeed true that the preflight request does not have these Access Control headers.I tried the same request from cURL and it passes there and I get back the tokens just fine so it's clear this is an issue

I’ve been working on a custom Extension (App) using the “Getting started” guide. The Extension has been working fine, running on my localhost at https://localhost:9000. Today, the Extension in the Airtable UI started showing the following message: { "error": "FORBIDDEN", "message": "blockId mismatch. Make sure you are entering development for the correct block." } The error message is very clear, but I haven’t changed the blockId in the remote.json file. I’ve also tried restarting my local and reloading the UI, but this error persists. Somehow it seems like the blockId must have changed, but I’m not clear on how/why or where I would get the new blockId from. Any thoughts on how to fix? I’m assuming I could just create a new Extension, but I’d rather get to the root of the problem. Thanks in advance!

Hi, I've been testing Airtable to create a visual database system for skilled professionals in Nepal. While fetching data from Airtable API to my APP, I hardly get all data. Few of my data are missing. I have tested it using postman.