I'd like to have a Listbox or similar, where the user could start typing, and the Listbox would narrow down the choices depending on what has already been typed, and autocomplete once a unique option had been reached
相关问题
- How can I force all files in a folder to be owned
- Google Apps Script: testing doPost() with cURL
- Google Apps Script to turn in, grade, and return a
- Script fails on SpreadsheetApp.openById - Requires
- Split Lines and Bold Text within a ui.alert Window
相关文章
- How to allow access for importrange function via a
- Google app script trigger not working
- Set Date/Time to 00:00:00
- indexOf returning -1 despite object being in the a
- How can my Google Apps Script be run by others the
- How to stop execution of Google Apps Script?
- Profiling the Performance of a Google App Script
- String starts with in Google Script
See http://googleappsdeveloper.blogspot.in/2011/05/autocomplete-email-addresses-in-apps.html for an example of autocomplete
It's fairly easy in HtmlService and a bit harder in UiApp although doable. Here's an HtmlService example:
Code File
Html file named 'ui'
[Edit] HtmlService is faster and more advanced. UiApp works, but is slow because of the network.
The HtmlService solution here Populate jQuery autocomplete list using value array from Google Spreadsheet is much better.
A UiApp version: https://sites.google.com/site/scriptsexamples/learn-by-example/uiapp-examples-code-snippets/suggest-box
Or this way that I built:
To see it in action, type an airport name into: http://www.treesforlife.org.au/carbon-calculator
But this was is done with spreadsheet formulas, not google-apps-script. see http://www.cellmaster.com.au