import { getColumnLetterByName } from "./getColumnLetterByName" ; import { getColumnPositionByName } from "./getColumnPositionByName" ; import { getColumnNames } from "./getColumnNames" ; export function getEditedRows ( fromRowIndex , toRowIndex , sheet ) { const editedColumnLetter = getColumnLetterByName ( "edited" ) ; const editedColumn = sheet . getRange ( fromRowIndex , getColumnPositionByName ( "edited" ) , toRowIndex , 1 ) ; const textFinder = editedColumn . createTextFinder ( "^YES|NEW$" ) . useRegularExpression ( true ) ; const matches = textFinder . findAll ( ) ; const rows = matches . map ( ( match ) => { return sheet . getRange ( match . getRowIndex ( ) , 1 , 1 , getColumnNames ( ) . length ) ; } ) ; return rows ; }