XL3Filter
Filters a range by returning an array of only the changed rows, on the basis of a column tracking changed values (used in conjunction with XL3TrackChanges to track the changed rows and as an argument for XL3RunSQLProc2 to pass a table of rows to be updated by an SQL Stroed Procedure.
Contents
Syntax
XL3Jsonify( Input, Filter )
Parameters
| Parameter | Description |
|---|---|
| Input | The range to watch for changes. |
| Filter | The range (column) that contains TRUE values to corresponding changed rows. |
Examples
Rows of the $D$7:$K$12 range for which the cell value is equal to TRUE for the same row in the $L$8:$L$12 range are returned as a JSON string.
