Increment Cell value by one by clicking

by

First create a script to increment the cell value. For instance, to increment cell “A1” by one the following script would work:

function increment() {
  SpreadsheetApp.getActiveSheet().getRange('A1').setValue(SpreadsheetApp.getActiveSheet().getRange('A1').getValue() + 1);
}

Save this script and open your spreadsheet and follow these steps:

  • Go to “Insert” > “Drawing” and draw a button using shapes and text.
  • Position your button accordingly, and right-click on it to display an
    arrow on the side of it.
  • In the drop-down menu, select “Assign Script.” and type the name of
    your function. (In this case “increment”)
  • The first time when you click on it, it’ll ask for permission but
    should work subsequently.

Dropdown Menu

Result

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  3. How do I make a Sidebar display values from cells?
  4. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  5. button click is only working on Windows & not working on Android mobile sheet
  6. No permission to call msgBox in Google Apps Scripting
  7. Custom functions intermittently hang with “Error – Loading Data”
  8. How to define global variable in Google Apps Script
  9. Periodically refresh IMPORTXML() spreadsheet function
  10. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  11. Format a Google Sheets cell in plaintext via Apps Script
  12. UiApp has been deprecated. Please use HtmlService instead
  13. Google app scripts: email a spreadsheet as excel
  14. Is there a way to keep two sheets synchronized?
  15. Selecting the last value of a column
  16. Google apps script to email google spreadsheet excel version [duplicate]
  17. How to get filtered values from Filter after using setColumnFilterCriteria?
  18. GAS “On edit” trigger not running when edited from API
  19. Difference between getValue() and getDisplayValue() on google app script
  20. How to allow onEdit function to affect protected cell in a Google Sheet?
  21. Hidden field in a Google Form
  22. Measurement of execution time of built-in functions for Spreadsheet
  23. onEdit() doesn’t catch all changes
  24. Google Spreadheets Scripts: check if cell is empty
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. Converting .xls to google spreadsheet in google apps script
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment