Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onOpen() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var menuEntries = [ {name: "insert date/time", functionName: "listBoxVersion"}
- ];
- ss.addMenu("DaTime", menuEntries);
- }
- function listBoxVersion() {
- var app = UiApp.createApplication().setTitle('Time Picker');
- var main = app.createGrid(2, 4);
- var date = app.createDateBox().setName('date');
- var hour = app.createListBox().setName('hour').setWidth('100');
- var min = app.createListBox().setName('min').setWidth('100');
- for (h=0;h<24;++h){
- if(h<10){var hourstr='0'+h}else{var hourstr=h.toString()}
- hour.addItem(hourstr)
- }
- for (m=0;m<60;++m){
- if(m<10){var minstr='0'+m}else{var minstr=m.toString()}
- min.addItem(minstr)
- }
- var button = app.createButton('validate')
- main.setWidget(0,0,app.createLabel('Choose Date')).setWidget(0,1,app.createLabel('Choose Hours')).setWidget(0,2,app.createLabel('Choose minutes'))
- main.setWidget(1,0,date).setWidget(1,1,hour).setWidget(1,2,min)
- main.setWidget(1,3,button)
- var handler = app.createServerHandler('show').addCallbackElement(main)
- button.addClickHandler(handler)
- app.add(main)
- ss=SpreadsheetApp.getActive()
- ss.show(app)
- }
- function show(e){
- var cel1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getActiveCell().getA1Notation();
- ss=SpreadsheetApp.getActive()
- //ss.getRange(cel1).setValue(Utilities.formatDate(e.parameter.date,'GMT+02:00','MMM-dd-yyyy')+' @ '+e.parameter.hour+':'+e.parameter.min)
- var date = new Date(e.parameter.date);
- date.setHours(e.parameter.hour,e.parameter.min,0)
- ss.getRange(cel1).setValue(date)
- }
Add Comment
Please, Sign In to add comment