![]() You add a button via the Insert > Drawing menu. You want to do that directly from your Google Sheet. ![]() You don’t want to have to open up the script editor every time. You can run this function from the script editor and it will clear out the contents of the invoice. In the script editor, accessed through Tools > Script Editor, add a very simple script to clear these specific cells out:Ĭonst sheet = SpreadsheetApp.getActiveSheet() Ĭonst invoiceNumber = sheet.getRange("B5").clearContent() Ĭonst invoiceAmount = sheet.getRange("B8").clearContent() Ĭonst invoiceTo = sheet.getRange("E5").clearContent() Ĭonst invoiceFrom = sheet.getRange("E6").clearContent() The user can enter information into cells B5, B8, E5 and E6 (shown in yellow). Let’s start by creating a basic invoice template with placeholders to hold information: Well, you can add a button to Google Sheets so you can run scripts and clear your invoice with a single button click. Imagine you have an invoice template you use on a regular basis, but it’s a pain to clear out all the values each time you need to start over. ![]() Let’s see how this works with a simple example. Learn how to add a Google Sheets button to run your Google Apps Script functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |