title: dropdown list from google sheet script with option of inserting free text
body: <p>So I'm trying to get a dropdown list that would allow me to also insert free text with this code I can select an item from my selected range in google sheet but is there a way to make it so it will also allow text input new text. Here's my code
  I've also tried using Datalist (could be better) but I could not get it to work properly any help would be greatly appreciated</p>
  <pre><code>&lt;div class=&quot;row&quot;&gt;
          &lt;script type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
   
           &lt;script&gt;
            &lt;?
            var sheet   = SpreadsheetApp.openById(&quot;ID&quot;).getSheetByName(&quot;Sheet&quot;);
            var lastRow = sheet.getLastRow();  
            var myRange = sheet.getRange(&quot;A2:A&quot;+lastRow); 
            var data    = myRange.getValues();
            
            ?&gt;
            google.script.run.withSuccessHandler(populategetEmp1).getEmp1();
           &lt;/script&gt;  
     
      &lt;div class=&quot;form col-md-6&quot;&gt;
        &lt;label for=&quot;emp1&quot;&gt;Client&lt;/label&gt;
          &lt;select  id = &quot;emp1&quot; class=&quot;form-control&quot; &gt;
           &lt;option value=&quot;&quot;  &gt;&lt;/option&gt; 
           &lt;? for (var i = 0; i &lt; data.length; ++i) { ?&gt;
           &lt;option &gt;&lt;?!= data[i] ?&gt;&lt;/option&gt;
           &lt;? } ?&gt;
          &lt;/select&gt;
        &lt;/div&gt;
  </code></pre>