Development & APIs

Hi I’m trying to add data to a table using the API, one field of which is a ‘Multiple Choice’ field, so i’m passing data as an array. However, it will only accept the POST if the table has predefined multiple choice options and you’re sending a POST with one or more those options, else it throws a ‘INVALID_MULTIPLE_CHOICE_OPTIONS’ error. And, from what I see you cannot create multiple choice options by using the API either. I assume this is expected behaviour, but… is there a way of programmatically adding new options to a multiple choice typed field, or even getting a list of acceptable values for that field, so i can check the data before calling the API? Thanks! mk

HiThis is Elias. I work with Airtable Api. I need to know is airtable personal token has any expiration date?I did not get any mention about the token expiration date over the api documentation.Please reply the posts.

 Hello, folks, i am trying to change the filename for files in an attachment field, and i noticed that when there are a few records it seems like the names get changed, but when i try to process more than 30, the attachments automatically get removed. I also noticed that the comments in the records id indicate that two actions have taken place  But for the ones that worked it shows just one time the record has been edited  The script that i use is below, i noticed a similar behavior when i was trying to upload attachments from a URL as well, some get updated, while some do not.   // Define the table, view, and field names const tableName = 'StuTable'; const viewName = 'StuMis

HelloAssessing airtable for some internal operations work that has some custom process flows, part of which sometimes require filling data to move to the next step in the flow.We're looking at both the "data" option and the "interface" option.The "Data" option seems to provides more flexibility when it comes to custom extensions (using the bocks sdk). On the other hand, the "interface" option seems to build nicer UIs but with more limitations on UI customizations.Did anyone go through a similar scenario of assessing data's extensibility vs interface's nice UI?     

I've been using passwordless login through the Wized v2 beta, and today the magic links stopped getting emailed. The requests are successful (New users still created in Airtable, status code 200 etc), but no email. Is this a known issue at the moment?

Hi,I'm trying to patch call an empty cell which is always be in the last/current row. Is there a way to do this with a parameter?

Struggling to install the blocks CLI. Getting the following error. 4757 error code 1 4758 error path /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/@sentry/cli 4759 error command failed 4760 error command sh -c node scripts/install.js 4761 error node:internal/modules/cjs/loader:1093 4761 error throw err; 4761 error ^ 4761 error 4761 error Error: Cannot find module 'core-util-is' 4761 error Require stack: 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/node_modules/readable-stream/lib/_stream_readable.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/node_modules/readable-stream/readable.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/tracker-stream.js 4761 error - /opt/homebrew/lib/node_modules/@airtable/blocks-cli/node_modules/are-we-there-yet/tracker-group.js 4761 error - /opt/homebrew/lib/node_modules

Is there a way to have a list of employees on a Base as 'users' (the tagging option) without paying for their seats? None of them will be collaborators or have access to the Base or Workspace, it is just a feature that I find very useful. I selected Development and APIs because the use case is currently on Softr, which is connected via API. Use case: I have a form that is being used externally (on Softr.io); I want to be able to allow my Softr.io users to 'tag' to an employee they are requesting in the form so that the Base automatically associated/assigns a request or task to that employee. Again, these employees would not actually be a user or collaborator on the bases. It is only for me to organize the workflows when external users in my front-end are requesting specific internal users. Thanks. 

Hi,Looking for some scripting help. I am manually copy and pasting values from a Lookup field to a Multi-select field on the same table and want to know if there is a way to create a script that could do this process for me.  Example below:Want to copy the teams in the "Lookup of Teams" field and paste it into the "Manual Copy Paste (multi-select).  Any suggestions appreciated! Thank you. 

I would like to add a signature block to a inspection form. I am a small company(2) and I do not want to spend 1200 yr for 1 mini extension.

Hi, Could someone demo this script showing how to properly create the parent/child and template tabs to utilize this script? I am having difficulty getting it to properly work. Thanks.

Hello Airtable Community,I'm working on a script in the Airtable Scripting App that processes a table with 1700 records. The script is designed to fetch records from the table, generate tracking links using the Impact.com API, and update the records with the newly generated tracking links.Unfortunately, I'm experiencing an issue where the script gets stuck at the "Fetching records" step. The script does not proceed to fetch any records or send API requests, and no further logs are displayed. I've tried various approaches, including fetching records in smaller batches, but the issue persists.Here's the latest version of the script:let settings = input.config({ title: "Add Impact.com tracking links", description: `This script generates Impact.com tracking links for the specified Envato links and adds them to a new field in the same record. To use this script, you will need an Impact.com API key, affiliate ID, program ID, and media partner property

I want to Create Record by API and one field "Multiple choice" throw error.I want to add "Other" value and I get "Value not found in options in parameter"And when I try add this option I get error, even if it's one of valid option In other cases like "SP z.o.o.", "SP akcyjna", "SP komandytowa", it work well.  

I’m pretty new to JS, but trying to learning all the time. Some of the first code I wrote in the scripting blog has gotten supper hard to update, so thought to experiment to write small modules to keep divide up the code. However it seems I can’t put buttons into functions? let test = function () { let firstClick = await input.buttonsAsync( 'What do you want to do?', [ {label: 'Check todays rate', value: 'today', variant: 'danger'}, {label: 'Convert currency', value: 'convert', variant: 'primary'} ] ) } this gives me an error saying ‘SyntaxError: await is only valid in async function’ does theis mean my button can only be used in the global scope?

Hi,I need to lookup a value from shipping rate tables based on the weight value from another table.I have two tables I need to look up data from, an example of one is below, The other is the same structure but different data.This is my source table containing my weight values.I need to select a value from the 2nd column on the above table, when the weight in my source table is between two row values.For example, if source weight is 7.75kg, it should return 53.3 for the rate.Hope someone can point me in the right direction 😁Thanksjohn

We are assessing AirTable for our Website and it works great. The last thing is a full text search.The only way I've found is to list all the records with a filter such as:filterByFormula=OR(FIND("search phrase", Field1), FIND("search phrase", Field2))Is this the way to achieve this or is there a more efficient way?

My app is using OAuth integration to authorize access to Airtable. However, if users want to switch account, they need to log out first. Are there any log out URL ? I cannot find it in Airtable. 

Hi, I am trying to find a workaround to Airtable's limit of 20 syncs coming into one base at a time. I have two bases, and I would like around 30 tables from the first base to sync with the second base. Can anyone recommend the best approach, in light of the limit? I could write a script to sync the relevant tables each time it is run, but this would be very laborious. I have heard mention of webhooks as possible solutions to similar problems but I do not know much about these and whether they would be suitable. 

I have created an app using Wized that allows a user to type the name of a city into a web form and get back the current weather conditions for that city.  I've saved the various weather icons into an Airtable base.  My Wized app uses an API call to Airtable to fetch the name of each icon and display the associated icon (PNG) file in a div on my web page.The problem I'm having is that when I run the API request, I get back this error:{"error", "Error: configuration does not exist"}Status code: 500Server errorI understand what 500 errors mean but I can't figure out why I'm getting this error. I'm calling the correct base "Wized Weather" and table "Weather icons" in my request.I'm using the correct personal access token for my workspace.I have a Pro plan paid account so there shouldn't be any account i

function blabla(){  // Replace the placeholders below with your own API keys and table information  var airtableApiKey = '-';  var airtableBaseId = '-';  var airtableTableName = '';    // Get the active sheet and the range of cells containing your data  

Hi there,I am trying to figure out a way to automatically select linked records via another field.I have two types of records:Property listings that are in a project(condo building or gated community) and listings that are NOT.Project properties I'm able to use Lookup fields to select linked records showing the District of the property.Listings outside of a community we must select the District manually.Now I need an automation to select the District on the linked records. It MUST Be a linked record as I will then sync with a Webflow real estate website and you cannot sync anything other than linked records if you want the. Webflow field to be a reference field.I figured out a script but I get this error message. I think it has something to do with the script not being able to select in the  Linked record. Please advise Error message:  Error: Field "fldQe8Zq6eDEjs99l" cannot accept the provi

is there a way to update multiple records including upsert on linked records?  // fld4nItZFaesqE3hi: 'Pet-Dose' is a linked record chunk=[ { id: 'recDZL0CMwcu8nh0w', fields: { fld4nItZFaesqE3hi: 'Pet-Dose', fld6kqVwPYlYRsI73: 0.715 } }, { id: 'recoAcgIEbo0vXqRv', fields: { fld4nItZFaesqE3hi: 'Pet-Dose', fld6kqVwPYlYRsI73: 1 } }]; //update records chunks.forEach(function (chunk) { airtable.base(baseID)('Artikel').update(chunk, {typecast:true}, function (err, records) { if (err) { console.error(err); return; } }); }); 

Hi everyone! We’re excited to announce a new beta feature for the scripting block: script settings! With script settings, you can define settings for your script: a title, description, and settings items (table, field, view, text, number, and select). From your definition, we render a settings UI. Users of your script can update the settings and run the script without needing to modify the code. You can sign up for the beta via this form. You’ll only be able to use script settings if you’ve signed up for the beta: if you’d like to test it out with your script users, please have them also join the beta. Please submit any feedback/issues here. Read on for more information about how to use script settings!

Using Airbyte, I was transferring data from Airtable to Google BigQuery. I was able to transfer some data, but some columns are missing. There were more than 70 fields (columns) in the original table, but only 17 have been transferred to GBQ. Several of the missing fields, as described in the documentation, are entirely empty. Unfortunately, about 30 columns with data are missing as well. Originally, I assumed that Airbyte was not correctly transferring all of the columns. Therefore, I tried a different connector, but I got the same result. Is there anyone who can explain why these columns are missing, and how to resolve this problem?

Hi!So I have a "Newsletter" table that has a linked records field that links to an "Events" table. I want to prepare my Newsletter with all the Events between today and 30 days from now. So I'm trying to link those Events to a newly created Newsletter.Since the "Find records" automation module doesn't provide a sorting feature, I'm externalizing my automation to Make via a webhook.There I use the "Search records" module that returns the list of Events I want, in the chronological order that I need to link back to my Newsletter.The problem is I cannot figure how to update multiple linked records. I've tried an array of IDs and an array of ojbects with "ID" parameter without succes.I'm getting these errors:The operation failed with an error. [422] Value "["recp52K5lovXI8Q8p","recMylG9MZx6O1kCj","recSgsOeULsCZhOzj","recG5cVdLPJTXxyN1","recXhysdl7joff667"]" is not a valid record ID.The operation faile