JSFiddle - React, Tailwind, and code Playground

by orlandotigereye

HTML

<div id='divResult' />

<select id="something">
  <option> Choose a option </option>
</select >

<select id="something2">
  <option> Choose a option </option>
</select >

<select id="something3">
  <option> Choose a option </option>
</select >

<select id="something4">
  <option> Choose a option </option>
</select >

JavaScript

//151126
//連接Google Sheet 將值以JSON儲存,並以下拉回傳值
//第一欄為名稱-名稱取法為-
 //opt2.value = data.feed.entry[i].title.$t;
//第二欄為值-值取法為-
//  var cost = //data.feed.entry[i].content.$t.split(' ')[1]; 

var url ='https://spreadsheets.google.com/feeds/list/1yQ2o6S1RQ7vG43WhIiAkB0NFFOCF1JO2YJttzIXeOG0/od6/public/full?alt=json';
$.getJSON(url,function(data){
    $.each(data.feed.entry,function(i,item){
        var obj=$('<li/>');
        $.each(item,function(ii,iitem){
            if(ii.indexOf('gsx$')>-1)              obj.append('<span>'+iitem.$t+'</span>');
               
            
        });    
        $('#divResult').append(obj);
    });
    
    var a= data.feed.entry.length;
    for(var i=0; i<a; i++) {
         var select = document.getElementById('something');
    var opt = document.createElement('option');
    var cost = data.feed.entry[i].content.$t.split(' ')[1]; 
        //get "Price: "value
    opt.innerHTML = cost;
    select.appendChild(opt);
            
              var select2 = document.getElementById('something2');
    var opt2 = document.createElement('option');
    opt2.value = data.feed.entry[i].title.$t;
    opt2.innerHTML = data.feed.entry[i].title.$t;
    select2.appendChild(opt2);
            
        var select3 = document.getElementById('something3');
    var opt3 = document.createElement('option');
    opt3.value = i;
    opt3.innerHTML = i;
    select3.appendChild(opt3);     

   var select4 = document.getElementById('something4');
    var opt4 = document.createElement('option');
    opt4.value =  data.feed.entry[i].title.$t;
    opt4.innerHTML = data.feed.entry[i].title.$t;
    select4.appendChild(opt4);     
      }
});