CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsintegrationjotform
Kristine M.
Kristine M.

Reputation: 1

Google Script for Spreadsheet to Hide Cells

We currently use JotForm to collect submissions, and have those submissions collect in a Google Sheets. We need to "mask" two column's entries (NOT the header), which we typically default to ****. Our current code masks one column (Column B) but we would like to mask another (Column R).

Does anyone know where I would inject a piece that would include masking Column R in addition to Column B? ("B2:B" masks Column B.)

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var pins = ss.getRange("B2:B").getValues();
  for (var row = 2; row < pins.filter(String).length + 2; row++){
    ss.getSheets()[0].getRange(row,2).setValue("****")
  }
}

Form URL: https://form.jotform.com/81144822339153

Upvotes: 0

Views: 807

Answers (0)

Related Questions