button click is only working on Windows & not working on Android mobile sheet

by

Workaround is to use checkboxes(say, in F1) instead of buttons/Images. Then hook your function, that is supposed to run on button click to a trigger function like onEdit().

Sample script:

function onEdit(e){
  const rg = e.range;
  if(rg.getA1Notation() === "F1" && rg.isChecked() && rg.getSheet().getName() === "Sheet1"){
    callFunctionAttachedToImage();
    rg.uncheck();
  }
}

Some limitations of this workaround in mobile app is described here.

References:

More Related Contents:

  1. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Is there a way to evaluate a formula that is stored in a cell?
  4. Automatic timestamp when a cell is filled out
  5. How to auto select range from a filter without having to manually enter it?
  6. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  7. Script to Change Row Color when a cell changes text
  8. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  9. How to get onFormSubmit to trigger automatically?
  10. Copying a spreadsheet copies all linked files as well
  11. “SpreadsheetApp.getUi() cannot be called from this context”
  12. copy data from one sheet to another in google app script and append a row, one small issue
  13. Using built-in spreadsheet functions in a script
  14. Google App Scripts cannot be given Authorization or Permission
  15. How to get the correct range to set the value to a cell?
  16. Refresh data retrieved by a custom function in Google Sheet
  17. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  18. Increment Cell value by one by clicking
  19. email notification if cell is changed
  20. Dynamic selection options in Google Apps Script for forms
  21. Determine current user in Apps Script
  22. How to ignore empty cell values for getRange().getValues()
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment