Google Spreadsheets: Assign A Script To A Button With Parameters

I can successfully assign scripts to images in Google spreadsheets. My problem is with parameter passing. I have this script to write the current time on a cell. function Time(cell

Solution 1:

Sorry, but this really doesn't solve my problem. I don't want user input. The idea is to have a button associated to each cell. The user just presses a button and the cell is filled with a timestamp. If the user must input the cell name, it's ruined. Current solution works but it's ugly:

functionTime(cell){
  var  d = newDate();
  var timeAsString = d.getHours() + ":" + d.getMinutes() + ":" + d.getSeconds();
  SpreadsheetApp.getActiveSheet().getRange(cell).setValue(timeAsString); 
};

functionTimeB12(){Time('B12')};
functionTimeB13(){Time('B13')};

// about 500 more cells...

I then associate script TimeB12 to button next to cell B12, and so on.

Solution 2:

Yes you can xD

you must use a prompt , ask the user to input string : Browser.inputBox documentation : https://developers.google.com/apps-script/reference/base/browser#inputBox%28String%29

And your script use this string exemple : 'A1'

ex : SpreadsheetApp.getActiveSheet().getRange("A1")