Skip to main content

 

const table1 = base.getTable("Table 1")

const view = table1.getView("Grid view");

const record_view = await table1.selectRecordsAsync({fields: ["Name"]})

const record_filtered = record_view.records.filter(record => record.name === "Test 1")

 

I'm just trying to understand how scripts work on airtable. i'm not a expert on JS so it can have some errors, but i think i already did the filter in a right way but i can't console.log anything about the "record_filtered"

And im trying to update the record_filtered, but i can't get the recordId

let table = base.getTable("Table 1");
//let record = await input.recordAsync("Converting record", table)

const record_view = await table.selectRecordsAsync({fields: ["Name"]})

const record_filtered = record_view.records.filter(record => record.name === "Test 1")

let test1 = "gui123"
let recordId = record_filtered.id;

await table.updateRecordAsync(recordId, {
"Name" : test1,
})

 

Is because record_view.records.filter returns an array an not object, you have two ways to solve this:

 

// the filter method returns an array, this is good you want to filter more than one record
// returns an array [{...}]
const records_filtered = record_view.records.filter(record => record.name === "Test 1")

let test1 = "gui123"
let recordId = records_filtered[0].id
// ^ access the first item in the array.

await table.updateRecordAsync(recordId, {
"Name" : test1,
})

 

 Alternatively you can use the find method

 

 

// Another way you can use if you only care about 1 record is the find method
// this method will return the first item that satisfies the provided testing function
// otherwise it will be null
const record_filtered = record_view.records.find(record => record.name === "Test 1") the record {...}

if(record_filtered) {
let test1 = "gui123"
let recordId = record_filtered
// you can use console.log too
console.log("recordId:", recordId);

await table.updateRecordAsync(recordId, {
"Name" : test1,
})
}

 

 The console.log will look like this:

I hope this helps. If you need more help feel free to schedule 15min call with me. 

 

Reply


Terms & Conditions