0
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.

TheMaster
  • 45,448
  • 6
  • 62
  • 85

0 Answers0