Adding Buttons To Google Sheets and Set value to Cells on clicking

Question

I am new to Google Script    I have a Google Sheet with 5 columns  on each column I need a button  with text 1 2 3 4 5     And on each button click I need to set text of button to corresponding cell and hide the clicked button   Is it possible

User · Answer

You can insert an image that looks like a button. Then attach a script to the image.

INSERT menu
Image

Insert Image

You can insert any image. The image can be edited in the spreadsheet

Edit Image

Image of a Button

Image of Button

Assign a function name to an image:

Assign Function

User · Answer

It is possible to insert an image in a Google Spreadsheet using Google Apps Script  However  the image should have been hosted publicly over internet  At present  it is not possible to insert private images from Google Drive   You can use following code to insert an image through script     function insertImageOnSpreadsheet       var SPREADSHEET URL    INSERT SPREADSHEET URL HERE        Name of the specific sheet in the spreadsheet    var SHEET NAME    INSERT SHEET NAME HERE      var ss   SpreadsheetApp openByUrl SPREADSHEET URL     var sheet   ss getSheetByName SHEET NAME      var response   UrlFetchApp fetch         https   developers google com adwords scripts images reports png      var binaryData   response getContent          Insert the image in cell A1    var blob   Utilities newBlob binaryData   image png    MyImageName      sheet insertImage blob  1  1       Above example has been copied from this link  Check noogui s reply for details   In case you need to insert image from Google Drive  please check this link for current updates

User · Answer

Consider building an Add-on that has an actual button and not using the outdated method of linking an image to a script function    In the script editor  under the Help menu    Welcome Screen    link to Google Sheets Add-on - will give you sample code to use

[google-apps-script] Adding Buttons To Google Sheets and Set value to Cells on clicking

Examples related to google-apps-script

Examples related to google-sheets