Create a button in google sheets

Select a cell in google sheet.
Insert->Drawing.
Insert a textbox. Add text to it and give it an outline.
Save and close.
Go to Tools->Script Editor.
Create a new function, for instance:
function hello()
{
}
Click on the 3 dots at the top right hand corner of the textbox you have created.
Click on assign script.
Assign it the name of the function - hello.


Comments

Post a Comment

Popular posts from this blog

Popup message box

Code: Browser.msgBox("Hello!", Browser.Buttons.OK) Another popup message box is the toast, which shows up at the lower-right hand corner of the spreadsheet (this only works with sheets): SpreadsheetApp.getActiveSpreadsheet().toast("Hello", "This is the title"); If timeout seconds is set to -1, it means that the toast will be there forever. Create a modeless dialog that does not prevent you from doing other things: function showDialog() {   var html = HtmlService.createHtmlOutputFromFile('hi');   SpreadsheetApp.getUi().showModelessDialog(html, 'This is the title') }
Read more

Create a side bar

In Script editor, go to File -> New -> HTML file. Add in HTML code inside your file. function functionToShowSideBar() {  SpreadsheetApp.getUi().showSidebar(HtmlService.createHtmlOutputFromFile('NameOfHTMLFileCreated').setTitle("Hello")); } This bar will pop up at the right hand side of your sheets.
Read more