Skip to main content

Is it possible to select records in scripting with specific conditions? If I wanted to get all the records that have a field value of green, how would I write that query? I don’t want to just get all the records; I want specific records with more than 100 results.

You currently cannot specify conditions when querying records in scripting. You must get all the records and then filter the result in JavaScript.


const table = base.getTable("myTableName")

const fieldName = "color"

const queryResult = await table.selectRecordsAsync({fields: [fieldName]})

const greenRecords = queryResult.records.filter(record => (

  record.getCellValueAsString(fieldName) == "green"

))

console.log(greenRecords)

Reply


Terms & Conditions