![]() The user specifies a title for the new spreadsheet in the form, although including a default value in case the form is blank might be a good choice. Now, when the user clicks on the "New Sheet" button the add-on generates a new spreadsheet formatted with a header row that is frozen such that it is always visible. ![]() NewSheetSection.addWidget(CardService.newButtonSet().addButton(newSheetButton)) Var newSheetButton = CardService.newTextButton() Var createExpensesSheet = CardService.newAction() Var sheetName = CardService.newTextInput() var newSheetSection = CardService.newCardSection() To get started, add the following card section to the card that createExpensesCard returns. For our add-on, let's allow the user to create a spreadsheet for expenses. Return createExpensesCard(null, e).build() īeyond using Google Apps Script to edit an existing spreadsheet, you can create an entirely new spreadsheet programmatically. Replace the contents of appsscript.json with these configuration settings: e An event object containing form inputs and parameters. In appscript.json, specify the metadata associated with the add-on, such as its name and the permissions it requires. To open the manifest file, at the left, click appscript.json.Select the Show "appscript.json" manifest file in editor" checkbox. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |