30:[] 2e:{"title":"Tiny Tools viewer","cells":[{"id":0,"value":"md`# Tiny Tools viewer`","pinned":false,"hidden":false,"mode":"ojs"},{"id":104,"value":"md`Source: https://github.com/everestpipkin/tools-list`","pinned":false,"hidden":false,"mode":"ojs"},{"id":53,"value":"viewof list = {\n let arr = [];\n for (var i = 0; i< rows.length; i++){\n arr[arr.length] = `\n \n `\n }\n \n return html`\n \n `\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":66,"value":"\n{\n return list, stuff()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"{\n const x = rows\n .filter(d => !!d.title)\n .map(d => `\n

${d.title} - ${d.description}

\n `);\n \n return html`

${x.join(\"\")}

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"md`I learned this magic from [https://observablehq.com/@bryangingechen/importing-data-from-google-spreadsheets-into-a-notebook-we](https://observablehq.com/@bryangingechen/importing-data-from-google-spreadsheets-into-a-notebook-we)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"google_sheet_url=\"https://docs.google.com/spreadsheets/d/e/2PACX-1vSr0uv1_hyrmmEoB8XMbQSff-EW6bYP_6cssWdADuxDXMhehtcrLmO2SE0DbU5rFDn84ymMtsSsrjwC/pub?output=tsv\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"url = `https://cors-anywhere.herokuapp.com/${google_sheet_url}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"rows = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let rows =[];\n const spreadsheet = await d3.tsv(url).then(data => data.forEach(d => rows.push(d))); // d3.tsv returns a Promise\n return rows;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":74,"value":"stuff = function(){\n let detailsitem = ''; \n for(let i = 0; i < rows.length; i++){\n if(rows[i].title === list){\n detailsitem = `\n

Title: ${rows[i].title}

Description: ${rows[i].description}

\n\n

\n `\n }\n }\n \n return html`

${detailsitem}

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}