Create a record without Linked Data throws Error

516 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am trying to write an Airtable automation Script where I am trying to create a new record to an existing table that has 4 fields

  • Friendly Name (String)
  • Platform Name (String)
  • Platform Type (Prefixed Value)
  • Data (Self-reference Linked Records field)


When I run this code where I am setting all the values except the "Data" field because I don't want the new record to be linked to any other record




const data = {
"Friendly Name": d,
"Platform Name": d,
"Platform": {name: "Launch"},
const record = await table.createRecordAsync(data)


I keep getting the same error


Error: Field "fldtUMUOntLLXvVx8" cannot accept the provided value.
    at <anonymous> on line 121
    at <anonymous> on line 137
    at main on line 43



where fldtUMUOntLLXvVx8 is the field ID for the "data" field. 


Can someone help me understand what I am doing wrong. I just want to create the new record without any interlinking

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @rsharma13 ! Great question. The error you're getting is a data type error b/c airtable doesn't understand the data you're trying to input to create a new record. Here's a quick Loom Video I recorded to show you step by step how I'd solve this. 

Clarification: When you say a prefix value do you mean a Single Select Field? This is an important distinction. 

To create new records with a single select you'll need to pass both  the Name AND ID ie: 


  id: "selTK7GUxsdiB6ss6",
  name: "Launch"



To find the Name and ID of your single select fields you can use this script (remember to change my table / field / record ID variable names to match yours)



var recordsTable = base.getTable("Records")

var recordsSelect = await recordsTable.selectRecordAsync("recwIxFLjepJ0444Z")


var recordsRecords = recordsSelect.getCellValue("Platform Type");



Expected output:

Screenshot 2023-11-11 151029.png