Using local variable inside a function Tabletop

Question

i'm currently using Tabletop to make a spreadsheet act like database for my blogspot

<html>
<body>
<p id="demo"></p>
<script src='https://cdnjs.cloudflare.com/ajax/libs/tabletop.js/1.5.1/tabletop.min.js'></script>
<script type='text/javascript'>    
  
  var publicSpreadsheetUrl = '1ZXZVfon9ywNelbVEchOu9HQbSLZJRE-x6G2xOFPA-lA';
  
  function init() {
    Tabletop.init( { key: publicSpreadsheetUrl,
                     callback: showInfo,
                     simpleSheet: true } )
  }

  function showInfo(data, tabletop) {
    alert('Successfully processed!' + data.length + 'rows!')
    // console.log(data);
    var str = JSON.stringify(data);
    document.getElementById("demo").innerHTML = str;
  }

  document.write("Document <a target='_new' href='" + publicSpreadsheetUrl + "'>Here</a>");
  window.addEventListener('DOMContentLoaded', init)
</script>
   
</body>
</html>
[enter image description here][1]

how to use local variable so i can print outside the function, like this

function showInfo(data, tabletop) {
    alert('Successfully processed!' + data.length + 'rows!')
    // console.log(data);
    var str = JSON.stringify(data); 
  }
  document.getElementById("demo").innerHTML = str;
  document.write("Document <a target='_new' href='" + publicSpreadsheetUrl + "'>Here</a>");
  window.addEventListener('DOMContentLoaded', init)
</script>

score 0 · Answer 1 · answered Sep 19 '20 at 05:07

full link https://docs.google.com/spreadsheets/d/1ZXZVfon9ywNelbVEchOu9HQbSLZJRE-x6G2xOFPA-lA/pubhtml

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/tabletop.js/1.5.1/tabletop.min.js'></script>

<p id="demo"></p>


<script type='text/javascript'>    
  
  var publicSpreadsheetUrl = 'https://docs.google.com/spreadsheets/d/1ZXZVfon9ywNelbVEchOu9HQbSLZJRE-x6G2xOFPA-lA/pubhtml';
  
  function init() {
    Tabletop.init( { key: publicSpreadsheetUrl,
                     callback: showInfo,
                     simpleSheet: true } )
  }

  function showInfo(data, tabletop) {
    
    var str = JSON.stringify(data);
    document.getElementById("demo").innerHTML = str;
  }

  document.write("Document <a target='_new' href='" + publicSpreadsheetUrl + "'>Here</a>");
  window.addEventListener('DOMContentLoaded', init)
</script>
   
</body>
</html>

Don't just post code. Explain what the problem was, and how you fixed it. — Barmar, Sep 19 '20 at 05:14
I assumed that was a link to code. Using full sentences would make your intent clearer. — Barmar, Sep 19 '20 at 16:05
I am weak in English - I do not mean the abbreviation in the explanation — Emy, Sep 19 '20 at 18:02

Using local variable inside a function Tabletop

1 Answers1