SidebarJavaScript.html

<!--
 * Copyright 2014 Google Inc. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 -->

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
  /**
   * Run initializations on sidebar load.
   */
  $(function() {
    // Assign handler functions to sidebar elements here, if needed.
    $('#sidebar-info-button').click(onPullClick);
    $('#sidebar-shop-button').click(onPutClick);

    // Call the server here to retrieve any information needed to build
    // the dialog, if necessary.
  });

  /**
   * Calls the server to retrieve information from the sheet.
   * Gets the value in the active cell, which is then placed in the
   * sidebar text field.
   */
  
  /**
   * Calls the server to modify the sheet.
   * Replace the currently selected cell value with the value in the
   * sidebar text field.
   */
  function onPutClick() {
    this.disabled = true;
    
    // Gather any information that needs to be sent to the server here.
   
    var shopID = $('#sidebar-shop-select').val();
    Logger.log("Value",shopID);
    // Send the value to the server and handle the response.
    google.script.run
        .withSuccessHandler(
          function(msg, element){
            // Respond to success conditions here.
            showStatus('Cell set to reference value: ' + shopID);
            element.disabled = false;
          })
        .withFailureHandler(
          function(msg, element){
            // Respond to failure conditions here.
            showStatus(msg, 'error');
            element.disabled = false;
          })
        .withUserObject(this)
        .setActiveID(shopID);
  };
  
function onPullClick() {
      onPutClick();
    this.disabled = true;
     var infoValue =  $('#sidebar-info-select', function(e) {
      this.options[e.target.selectedIndex].val;});
    // Gather any information that needs to be sent to the server here.

    // Send the value to the server and handle the response.
    google.script.run
        .withSuccessHandler(
          function(msg, element) {
            // Respond to success conditions here.
            $('#sidebar-value').val(msg);
            showStatus('Pulled value successfully.');
            element.disabled = false;
          })
        .withFailureHandler(
          function(msg, element) {
            // Respond to failure conditions here.
            showStatus(msg, 'error');
            element.disabled = false;
          })
        .withUserObject(this)
        .setActiveSheet(infoValue);
  }

  /**
   * Displays the given status message in the sidebar.
   *
   * @param {String} msg The status message to display.
   * @param {String} classId The message type (class id) that the message
   *   should be displayed as.
   */
  function showStatus(msg, classId) {
    $('#sidebar-status').removeClass().html(msg);
    if (classId) {
      $('#sidebar-status').addClass(classId);
    }
  }

</script>