Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*global SpreadsheetApp: false, UiApp: false */
- // Close the current UI
- function exit() {
- "use strict";
- var ui = UiApp.getActiveApplication();
- return ui.close();
- }
- // Callback action for button labelled "Add Row"
- // Take the values from two text boxes in the active GUI and
- // add them as rows to the active sheet.
- // Prepare for next input by:
- // re-setting the text boxes to empty strings
- // Set the focus to the first text box
- function addRow(e) {
- "use strict";
- var ui = UiApp.getActiveApplication(),
- sheet = SpreadsheetApp.getActiveSheet(),
- name = e.parameter.txtName_Name,
- email = e.parameter.txtEmail_Name,
- txtName = ui.getElementById('txtName_Id'),
- txtEmail = ui.getElementById('txtEmail_Id');
- sheet.appendRow([name, email]);
- txtName.setValue('');
- txtEmail.setValue('');
- txtName.setFocus(true);
- return ui;
- }
- // Build a GUI with two labels, two text boxes and two buttons.
- function guiDemo() {
- "use strict";
- var ui = UiApp.createApplication(),
- ss = SpreadsheetApp.getActiveSpreadsheet(),
- uiTitle = 'Add Row To Spreadsheet',
- panelInput = ui.createVerticalPanel(),
- panelName = ui.createHorizontalPanel(),
- panelEmail = ui.createHorizontalPanel(),
- panelButtons = ui.createHorizontalPanel(),
- lblName = ui.createLabel('Name:'),
- lblEmail = ui.createLabel('Email:'),
- txtName = ui.createTextBox(),
- txtEmail = ui.createTextBox(),
- btnAddRow = ui.createButton('Add Row'),
- btnExit = ui.createButton('Exit'),
- exitHandler = ui.createServerHandler('exit'),
- addRowHandler = ui.createServerHandler('addRow');
- panelName.add(lblName);
- panelName.add(txtName);
- panelEmail.add(lblEmail);
- panelEmail.add(txtEmail);
- panelInput.add(panelName);
- panelInput.add(panelEmail);
- panelButtons.add(btnAddRow);
- panelButtons.add(btnExit);
- panelInput.add(panelButtons);
- ui.add(panelInput);
- ui.setWidth(200);
- ui.setHeight(100);
- btnExit.setWidth(80);
- btnExit.addClickHandler(exitHandler);
- btnAddRow.setWidth(80);
- btnAddRow.addClickHandler(addRowHandler);
- addRowHandler.addCallbackElement(txtName);
- addRowHandler.addCallbackElement(txtEmail);
- txtName.setName('txtName_Name');
- txtEmail.setName('txtEmail_Name');
- txtName.setId('txtName_Id');
- txtEmail.setId('txtEmail_Id');
- ui.setTitle(uiTitle);
- txtName.setFocus(true);
- ss.show(ui);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement