Script Querying specific records with a specific value with more than 100 records

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)
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.