I have created this website with google that is hosted in my google drive https://sites.google.com/view/cryptocurrencyman/home
Now, on the page Crypto Currency Charts I want a dropdown box with all the available crypto currencies from the google sheet that is available on the page Crypto Currency Data so the visitor can select which crypto currency they want to plot the historical price for.
I get the names of all the crypto currencies in column 1 in that that google sheet by running the following google app script function. This is the data I want in the drop down box.
function Get()
{
var sheet = SpreadsheetApp.openById("...........").getSheetByName('Sheet1');
var lastRow = sheet.getLastRow();
var myRange = sheet.getRange("A2:A" + lastRow);
var data = myRange.getValues();
Logger.log("Data = " + data);
return data;
};
This is the html code for a simple drop down box.
<!DOCTYPE html>
<html>
<form>
Select the value of y:
<select id="s1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
</form>
</html>
This is where the problem starts. How can I create a HTML drop down box with all the available crypto currencies in column1 from that specific google sheet with data? I dont want to manually enter all the names into the above html table.
