sheet = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data
let sheet =[];
const url = "https://docs.google.com/spreadsheets/d/e/2PACX-1vS_fQFNcSrpAwaY4EC5mMLVnqTiY9AMOsoNl9Ph0IiC8hqphTZHXFANN4BDt2rwdhJ6qGqxPnC5KCM9/pub?gid=1799576380&single=true&output=csv";
const spreadsheet = await d3.csv(url).then(data => data.forEach(d => sheet.push(d))); // d3.csv returns a Promise
return sheet;
}
html`
<form action="https://docs.google.com/forms/u/0/d/e/1FAIpQLSdCV2Q08RVsl877jXniP9nlDlOsBu97XHM_Gehkr5Hp2_fYxA/formResponse" method="post" target="hidden_iframe">
<input placeholder="Name" type="text" name="entry.1707258535">
<input placeholder="Age" type="number" name="entry.2081908180">
<input placeholder="Details" type="text" name="entry.323618692">
<button type="submit">Submit</button>
</form>
<iframe name="hidden_iframe" id="hidden_iframe" style="display:none;"></iframe>`
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
