function search(){
const searchValue = searchCell.getValue()
const data = dataWS.getRange("A2:M").getValue()
const recordsFound = data.filter(r => r[13] == searchValue)
if(recordsFound.length === 0) return
idCell.setValue(recordsFound[0][0])
fieldRange.forEach((f,i) => formWS.getRange(f).setValue(recordsFound[0][i+1]))
}
How can I solve it?
It throws
'data.filter' is not a function
I'm trying to implement a search data function.