var ss = SpreadsheetApp.getActiveSpreadsheet() Please use this script as the container-bound script. In this sample script, the checkboxes are created to "A1:C3" of Sheet1. If now you are opening the script editor with the script for using Sheets API, you can enable Sheets API for the project by accessing this URL Sample script : If API has already been enabled, please don't turn off.At Search for APIs & services, input "sheets".At Getting started, click Enable APIs and get credentials like keys.Enable Sheets API v4 at Advanced Google Services When you use this script, please enable Sheets API at Advanced Google Services and API console as follows. Renders as a cell checkbox.įrom this, I could understand how to create the checkbox using Sheets API. The cell's value must be TRUE/FALSE or in the list of condition values. When I saw ConditionType of dataValidation, the document of BOOLEAN says (When such methods are tried to be used, the error occurs.) So I would like to propose to create it using Sheets API. If my understanding is correct, how about this workaround? Unfortunately, the Class SpreadsheetApp has no methods for creating the checkbox yet. You want to create the checkbox in the cells of spreadsheet using the scripts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |