javascript - Check content of a "range" within a multidimensional array -


I have a multi-dimensional array that is based on data from a spreadsheet. It's structured like this: array [0] [row] [column] .

Now I want to check if values ​​are blank in many rows within a column or not. Is there a way to express something like what is (Array [0] [line 1 to 10] [column3] === "") ?

This is my current code:

  function update overview () {var ss = SpreadsheetApp.getActiveSpreadsheet (); Var database = spreadsheet. OpenById ('XYZ'); Var Overview Content = [ss.getDataRange () GetValues ​​()]; Var campaigndata = [database.getDataRange () GetValues ​​()]; (Var a = 1; a & lt; (campaign data [0]. Length); a ++) {for (var d = 4; d & lt; overview content [0]. Length; d ++) {If (campaignData [0] [a] [3] === Observations [0] [0] [1] and amp; utilityand date data (campaign data [0] [A] [7], "GMT + 01 : 00 "," Yyy Mimed ")) & lt; = (Utilities.formatDate (overview content [0] [D] [3], "GMT + 01: 00", "YYMEMMD") & amp; (Utilities datat (campaign data [0] [a] [8]], "GMT + 01: 00", "yyyammed") gt; = (Utilities.Date Date (Overview Content [0] [D] [3], "GMT + 01: 00" [8], "GMT + 01: 00", "YEMEMMD") - Utilities.Format (Campaign Data [0] [A] [7], "GMT + 01: 00", "YYYYMMDD"); Var campaign slot availability = true; For (var B = D; B & LT; (CampaignTension +1); B ++) {if (overview content [0] [B] [5]! == "") {campaignSlotAvailable = false; break; }} If (Campaign slot is available) {Overviews [0] [D] [5] === Campaign Data [0] [A] [6]; }}}}; . Ss.getDataRange () setValues ​​(overviewContent [0]); };  


Comments