title: Creating a search in Google Sheets Sidebar
body: <p>I have a sheet to track about 1400 parking spaces and was wanting to add an individual search in the sidebar. I have been able to get the sidebar to show up with a custom menu click. In the sidebar I have been able to rename it, add a search bar, and add search and close buttons below the bar. </p>
  
  <p>I am now needing help with once the user enters the space number in the search bar and clicks Search it will then take that space number, look through column B and collect the following information from that row and return to the sidebar in the below format:</p>
  
  <ul>
  <li>Column B: 'Return Column B information'</li>
  <li>Column C: 'Return Column C information'</li>
  <li>Column D: 'Return Column D information'</li>
  <li>Column E: 'Return Column E information'</li>
  <li>Column F: 'Return Column F information'</li>
  <li>Column G: 'Return Column G information'</li>
  <li>Row number: 'Return Row number that information is in'</li>
  </ul>
  
  <p>Below are the the codes I have right now.</p>
  
  <p>Menu.gs         </p>
  
  <pre><code>function onOpen() { 
  
  SpreadsheetApp.getUi()
  .createMenu('Sidebar')
  .addItem('Show Sidebar', 'showSidebar')
  .addToUi(); 
  }
  </code></pre>
  
  <p>Sidebar.gs</p>
  
  <pre><code>function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('index')
    .setSandboxMode(HtmlService.SandboxMode.IFRAME)
    .setTitle('Individual Space Lookup');
  SpreadsheetApp.getUi()
    .showSidebar(html);
  }
  
  function searchInfo() {
  
  return ('test');    
  
  }
  </code></pre>
  
  <p>index.html</p>
  
  <pre><code>&lt;div&gt;
  
  Search Individual Space: &lt;input type="search" /&gt;
  
  &lt;BR&gt;
  
  &lt;input type="button" value="Search"
  onclick="google.script.run.onSuccess()" /&gt;
  
  &lt;input type="button" value="Close"
  onclick="google.script.host.close()" /&gt;
  
  &lt;script&gt; 
  
  function onSuccess(searchInfo) {
  
  alert('Column B: ' + searchInfoColB
      &lt;br&gt;'Column C: ' + searchInfoColC
      &lt;br&gt;'Column D: ' + searchInfoColD
      &lt;br&gt;'Column E: ' + searchInfoColE
      &lt;br&gt;'Column F: ' + searchInfoColF
      &lt;br&gt;'Column G: ' + searchInfoColG
      &lt;br&gt;'Row Number: ' + searchInfoRowNum
  
      );
  }
  
  google.script.run.withSuccessHandler(onSuccess)
    .searchInfo(); 
  
  &lt;/script&gt;
  &lt;/div&gt;
  </code></pre>